K2 Office Tips Header
Volume 11, Number 8 

August , 2016
The long hot summer is coming to a close. We haven't been out on deck very much in the last month; the 35 plus temperature is just too much for me. Hopefully we will have a nice fall.
August has been has been a busy planning month for me. We are well along with plans for an outstanding Accounting Technology series which will visit 14 cities from coast to coast in October. Registrations are over 900 and some of the cities will sell out shortly. To make sure you get a seat go to  www.salmon.ca to register.
September will see two new ventures. The first is a new relationship  with the CPA community that will provide you with a catalog of webinars and recorded videos that are excellent and will qualify for full CPD credits.
The second is a series of free mini seminars. The first focuses on the move away from paper. If you are an accountant, bookkeeper or tax professional you will have the opportunity to spend an hour with my partner Ward Blatch CPA, CA and Don Emory CPA, CA, who is the Director of Client Solutions at Doc-It while they cover "Working Smarter with Document Management and Workflow". This webinar will qualify for 1 CPD credit. To register for this free webinar on September 13st, 2016 at 3:00 pm EDT please go to:  https://attendee.gotowebinar.com/register/5734322950875004164
As usual, I would welcome your comments at   alan@k2e.ca .

Alan Salmo n

Excel Tips

ExcelTopQuickly Closing all Open Excel Workbooks Without Closing Excel
Summary:  There are times when you want to close all of your open Excel Workbooks. Excel normally requires you to close each one individually. Here is how to this as a group:    
You need to add the Close All icon to your Quick Access Toolbar
  1. Right mouse click on your Quick Access toolbar
  2. Select All Commands from the drop down arrow in the middle panel of the QAT window.
  3. Select Close All.
  4. Click on Add. The Close All icon will now move to the Quick Access Toolbar selections on the right.
  5. Click on OK
The Close All icon will now be in your Quick Access Toolbar. To close all your open workbooks just click on the Close All icon. Note that you will still have to save any workbook that has been changed. 
Excel2AWatching a Formula Update on Another Sheet

Summary: The Watch Window in the Formula Tab lets you watch a cell update as you make changes to it. This is highly useful when you have formulas that span multiple sheets and you need to watch a cell on one sheet while you make changes to another sheet. Here is how to do this: 
  1. Select the Formula tab.
  2. In the Formula Auditing group select Watch Window.
  3. Click Add Watch to open the Add Watch dialog box.
  4. Select the cell on the worksheet that you want to watch update and click Add.
  5. Repeat steps 3 and 4 to add additional cells to monitor.
If you leave the Watch window open and make changes to cells that will affect the watched cells you will see the changes in the Watch Window. 
Click on the Watch Window icon again to minimize the Watch window area.

Excel3Finding Hidden Rows and Columns
The solution is to select all visible cells in the worksheet. You can then easily detect the hidden rows/columns, as they will be highlighted in white. To select the visible cells on the worksheet.
  1. On the Home tab, in the Editing group, select Find & Select
  2. Select Go To Special.
  3. Under Select, click Visible cells only.
  4. Click OK. 
All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns are marked with a white border. 
Note: Clicking anywhere on the worksheet will cancel the selection of the visible cells. If the hidden cells that you want to unhide are outside of the visible worksheet area, use the scroll bars to move through the document until the hidden rows and colum ns that contain those cells are visible.


Word Tip


WordTip2Making Backup Copies of a Word Document
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, 2013 and 2016 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.