K2 Office Tips Header
Volume 10, Number 2  

February, 2015

We are half way through winter and so far the weather has been kind to us here in Brampton. As I write this Nancy and I are enjoying ten days in Jamaica. It is sure nice to be outside again. 


Many of you have asked for an index of past tips and I have finally built the links to most of the past issues. Still to come is an actual index of the contents of these back issues. That is going to take a while. To access the links to the previous editions CLICK HERE.


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




Alan Salmon

Excel Tips

Excel1Turning off AutoFill  

Summary: AutoFill is a great feature in Excel when you want to fill in a series of cells based on the contents in other cells. It is also a feature that you can turn off. Some Excel users find the AutoFill handle, which is visible in the bottom-right corner of a selection, to be distracting and would like it turned off. Here is how to do this:   

  1. Click on the File Menu or the Office Button in Excel 2007.
  2. Click on the Excel Options dialog box.
  3. Click on the Advanced option at the left of the dialog box.
  4. In the Editing Options area, clear the Enable Fill Handle and Cell Drag-and-Drop check box.
  5. Click on OK.

Note that this not only turns off AutoFill, the above steps also turn off the ability to drag the contents of a cell from one location to another.

Excel2ABacking Up Your AutoCorrect Entries           

Summary:  AutoCorrect is a very useful feature in Excel that allows for the rapid correction of commonly misspelled words. It can be customized and I have a large list of words that I misspell in my AutoCorrect. I like to backup my AutoCorrect entries, so I can easily move the file to a new computer. Here is how to do this: 

Excel's AutoCorrect information is stored in files with the ACL extension. If you want to make a copy of your AutoCorrect information, use the search capabilities in Windows to locate files with this extension and copy them to your backup destination.

Back to top


Summary: There are times when it is useful to see all the formulas in a worksheet. Here is how to do this: 
  1. Press the F5 function key. 
  2. Excel displays the Go To dialog box.
  3. Click on Special. 
  4. Excel displays the Go To Special dialog box.
  5. Choose the Formulas radio button.
  6. Using the four check boxes under the Formulas radio button, indicate the type of results that should be produced by the formulas you want selected.
  7. Click on OK.
Excel will now highlight all of the cells in the worksheet that contain formulas.


Word Tip


Summary: By default, Microsoft Word does not make backup copies of your files. Instead the old file is deleted after the new file is written to your hard drive. If you want Word to keep backup files here is how to do this:  


  1.  In Word 2010 and 2013 click on the File menu. In Word 2007 click on the Office Button.
  2. Click on the Word Options dialog box.
  3. Click on Advanced.
  4. Scroll down until you see the Save options. (Don't confuse this with clicking Save at the left side of the dialog box; they are not the same.)
  5. Click on Always Create Backup Copy, so there is a check mark in the check box.
  6. Click on OK.

When that is done Word will save a backup copy with the file extension .wbk in the same folder as the original document. 


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.