K2 Office Tips Header
Volume 9, Number 11  

November, 2014

Winter is certainly here in Brampton and we had our first snow storm last week. The snow was only on the ground for three or four days, but it was a reminder that winter is upon us.  


I was pleased to be able to present our Tech Update at the CGA Ontario conference in early November. As well, I did a keynote at the first Canadian Accounting Technology Show in Toronto, also in early November.


My latest project involves Excel Keyboard Shortcuts, which are a great time saver. I am now tweeting an Excel keyboard shortcut five days a week. If you want to receive these useful tips, click on the "Follow us on Twitter" tab in the Quick Links panel below on the left.


There's just a few weeks left to ensure that you have enough professional development hours for the 2014 year. On-Demand Webinars from K2E Canada Inc. are an affordable and convenient way to earn 2 CPDs from the comfort of your home or office, on your time. 

We're having a Black Friday sale by taking $10 off the price of any webinar in our catalog - that's a 20% savings - until Friday December 12!

Visit our webstore and enter the Coupon Code BFSALE to receive the discount upon checkout. 

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




Alan Salmon

Excel Tips

Excel1Going to the Corners of a Selected Range    

Summary: There are times when you need to quickly move to a corner of a selected range.There is an Excel shortcut that makes this easy to do. Here is how:  

Once you have selected the range, hold down the 
Ctrl key while you press the period key. Excel will move you around the outside corners of the range, in order.

In addition, you can move from the upper-left corner of the selection to the lower-right corner by pressing Shift+Tab once. To move back (from bottom-right to upper-left), just press the Tab key once. 

Excel2ARapid AutoFill       

Summary:  The AutoFill function is a great tool to use when you are doing certain types of editing. Here is an example to illustrate how useful it can be. 

Let's assume we have a column full of values in column A running from A3 through A417. We want to fill the adjacent cells in column B with a numerical sequence of values running from 1 through 415. Use the following steps to accomplish this task:

  1. In cell B3, place the value 1. 
  2. In cell B4, place the value 2.
  3. Select the range B3:B4.
  4. Double-click on the AutoFill handle. (The black square in the bottom right corner of cell B3)

No dragging and you now have cells B5:B417 filled with sequential values.  

Back to top


Summary: It is very useful to be able to define hyperlinks in your workbooks. However, there are times when you no longer need a hyperlink and you need to delete it. Here is how to do this: 

Select the cell that contains the hyperlink.

  1. Right-click on the hyperlink. Excel displays a Context menu.
  2. Choose Remove Hyperlink. Excel dutifully removes the hyperlink.

You can also get rid of a hyperlink by simply deleting the contents of the cell. Select the cell and press the Del key or the Backspace key. The cell contents will disappear. However, only the contents have been deleted; the formatting remains. If you later type something into the cell, it will appear as blue and underlined, and you will think it is a hyperlink and it isn't. It is just formatted as a hyperlink. To solve this problem you will need to change the formatting.



Word Tip


Word1Formatting Page Numbers           

Summary: Word has a variety of standard page numbering formats. However, you are not restricted to these formats. You can format page numbers exactly the same as you format any other text in your document. Here is how to do this: 

Your first step, of course, is to insert the page numbers in either the header or footer.

When you are working in the Print Layout view, you can double-click on the header or footer, select the page number, and manually format it.


You format the page numbers exactly the same as you format any other text in your document. For example, you can make the page numbers bold, italic, change their size, etc.


However, if you are in the Draft or Outline view, you will have to  switch to the Print Layout view before you can edit the header or footer. (If you use the Header and Footer tools on the Insert tab of the ribbon in order to access the header or footer, Word switches you to the Print Layout view automatically.)

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 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.