K2 Office Tips Header
Volume 10, Number 7  

July, 2015

July is always a quiet month for us so Nancy and I are enjoying the nice weather, our deck and our garden which backs onto the woods of the conservation area behind our house.

My focus this month is on getting all of our K2E Canada seminars ready for the busy fall teaching season. I have four new courses to produce plus updates to a number of our current courses.

If you are in public practice and are looking to move to a "less paper" office I suggest you spend an hour on Tuesday September 1 with my partner Ward Blatch during his free webinar "
Working Smarter with Document Management and Workflow". Ward will have Don Emery, CA, CPA from Doc.It join him to talk about how to scan, organize and retain control of your firm's data all while improving your workflow and providing secure information exchange with your clients. For more information please click on the link below.

Register for the webinar.


As usual I would welcome your comments at alan@k2e.ca.




Alan Salmon

Excel Tips

Excel1Using the Mouse to Move Cells

Summary: It is handy, at times, to use the mouse to move cells around a worksheet. Here is how to do this: 

  1. Select the range of cells you want to move by highlighting the range with the mouse.
  2. Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow.
  3. Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
  4. When you are satisfied with the new location, release the mouse pointer. 

The cells are moved. If there is anything already at the target location, Excel may ask you if you want to overwrite the existing cells. You can respond according to your desires.


Hiding a Worksheet       
Summary: There are times when you want to hide a particular worksheet so that it cannot be easily accessed. This is often done to protect information on a worksheet or keep it from prying eyes. To hide a worksheet, follow these steps:

Select the worksheet you want to hide.

  1. Display the Home tab of the ribbon.
  2. In the Cells group, click the Format tool. Excel displays a menu.
  3. Choose Hide & Unhide, and then choose Hide Sheet.

The worksheet is immediately hidden. Once hidden, there is no way to tell it is "missing," as there is with hidden rows and columns. If you later want to unhide the worksheet, follow these steps:

  1. Display the Home tab of the ribbon.
  2. In the Cells group, click the Format tool. Excel displays a menu.
  3. Choose Hide & Unhide, and then choose Unhide Sheet. Excel displays the Unhide dialog box. Select the worksheet name you want to unhide.
  4. Click on OK.

You can also display the Unhide dialog box by displaying the View tab of the ribbon and clicking the Unhide tool, in the Window group.


Back to top


Summary: There are many different ways to sum a column or a row. Here is how to quickly do it from the keyboard:  

  1.  Select the first empty cell at the bottom or to the right of the numbers you want to add.
  2. Select ALT+"=".
  3. Press the Enter key.

The numbers will be summed. 



Word Tip


Word1Displaying the Ruler             

Summary: The ruler appears at the top of each Word document window. It is highly useful when you need to adust your formatting. There are times, however, when the ruler is not visible. When that happens here is how to get it back:    


Word allows you to control whether the ruler is displayed or not. If the ruler is not displaying do the following:

  1. Click on the View tab of the ribbon
  2. In the Show group click on the ruler check box.

The ruler will now be visible.


K2E Canada Inc. is a leading provider of professional development seminars for the Canadian accounting world. Each month we publish this free Office Tips e-mail newsletter. These tips will save you time and enhance the appearance of your Office files.


To subscribe to our K2E Canada Inc. newsletter send an e-mail to

alan@k2e.ca  with "Subscribe to newsletter" in the Subject. 
Your information is always kept secure and never shared.
Alan Salmon
Managing Director
K2E Canada Inc.