K2 Office Tips Header
Volume 10, Number 9  

September, 2015

Fall has officially arrived in Brampton but the weather is still warm. We had an excellent summer, the weather has been great and we have enjoyed our deck immensely. 


August and September are busy months for me. At the end of September I will be doing two sessions and a keynote presentation at the Institute of Professional Bookkeepers of Canada annual conference in Niagara Falls. Both Nancy and I are looking forward to seeing many old friends at the conference. Also at the conference IPBC will be releasing their Benchmark Survey which is the authoritative resource on the state of the bookkeeping profession in Canada. For further information on this study go to the 




My focus now is on the 2015 edition of the Accounting Technology Seminar Series. This is a one day seminar offered in fourteen Canadian cities that provides bookkeepers and accountants with an update on the technology that they and their clients use. It is worth ten CPDs. This is my 23rd year in organizing the tour. Toronto and Calgary are already sold out and the others only have a few seats, so now would be a good time you to register.  


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




Alan Salmon

Excel Tips

Summary: Instead of using the mouse to select a range of cells, here is a quicker way to get the job done:   
You can use the mouse to select a range of cells by holding down the left mouse button and dragging the mouse to make a selection. There is an even quicker way to select cells using the mouse. Here is how to do this:
  1. Select the cell that marks one corner of the range of cells you want to select.
  2. Move the mouse pointer so it points to the cell at the opposite diagonal corner of the range you want selected.
  3. Hold down the Shift key as you click once on the left mouse button.
That will select all the cells in the range.

Excel2AReplacing Dashes with Periods           
Summary: If you ever need to substitute periods for dashes in a cell, here is the formula to do this:
If you have a phone number such as "123-555-1212" you might want to change it to "123.555.1212". This is easy to do using the SUBSTITUTE function. 

Let's assume column B has a list of phone numbers with dashes. Insert a helper Column C. Select cell (C1) and enter the following formula into the cell:

C1 will now have the phone number with periods. Copy that formula down the column to convert the rest of the phone numbers. 

The final step is to copy the new phone numbers in column C and do a Paste Special Values to the numbers in column B. You can then delete the numbers in column C.
Back to top

Excel3Ensuring Rows and Columns are Empty 
Summary: It is important to check if a row or column has data before you delete it. Here is a quick way to check for a completely blank row or column: 
it is easy to delete rows or columns you think are blank, when in fact they contain data you cannot see on the screen. Here are the steps to check for data without scrolling through the gazillion rows and columns in your worksheet: 
  1. Click on the first cell of the column (A1, H1, etc.).
  2. Hold down the Ctrl key as you press the down arrow or the right arrow.

Performing these simple steps causes Excel to move to the next cell containing data. If there is no data, Excel selects the last cell in the column (at row 1,048,576) or the last cell in the row (at column XFD). You then know that the row or column is empty and you can safely delete it.

 Back to top


Word Tip


WordTip2Inserting the Date Your Document was Last Printed          
Summary: It is useful sometimes to know when a document was last printed. Here is how to enter that date in your document: 
Word maintains when a document was last printed. Every time you print your document, this piece of information is updated. There may be times when you want to display this "last printed" date in your document. To do this, follow these steps:
  1. Position the insertion point where you want the date to appear.
  2. Display the Insert tab of the ribbon.
  3. Click Quick Parts (in the Text group) and then click Field. Word displays the Field dialog box.
  4. Choose Date and Time from the Categories list. Word updates the choices in the Field Names list.
  5. Select PrintDate from the Field Names list.Select a date format from those offered, if desired. 
  6. Click on OK to insert the field.


K2 Enterprises Canada 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
President & CEO
K2E Canada Inc.