K2 Office Tips Header
Volume 11, Number 3 

March, 2016
Looks like spring has come to Brampton. We got a scare last week with an ice storm, but the ice was all gone by the end of the weekend. I can hardly wait until it's warm enough to have my coffee breaks on our beautiful deck.

March, April and May are planning and cleanup months for me. I am about to start on our fall and winter scheduling and that takes a couple of months to finalize, as it is a very complex operation. As well, we are totally rebuilding our web site at www.k2e.ca. When it is completed it will have some really cool features.

I am now starting to be very active in social media. Look for my comments, tips and news in my K2E Canada Twitter, LinkedIn and Facebook accounts.
As usual, I would welcome your comments at alan@k2e.ca.

Alan Salmon

Excel Tips

ExcelTopHow to Find Hidden Rows and Columns
Summary: When you want to print certain rows/columns of data you are most likely to hide the other rows/columns. However, when you want to unhide cells in hidden rows/columns, it can be a challenge to locate them. Here is the solution: 
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


WordTip2Highlighting Blocks of Text Using Shading
Summary: There are times when you would like to highlight a paragraph in your document. Here is how to do this:  

You can do this with Word's shading tool.  To add shading to a paragraph involves the following steps:
  1. Click and place your insertion point in the paragraph that you want to shade.
  2. Click on the Home tab of the ribbon.
  3. In the Paragraph group, click on the down-arrow to the right of the Shading tool. (This tool looks like a tilted paint bucket, spilling paint to the right.) Word then displays a shading palette.
  4. Hover over a color and your paragraph will be shaded with that color. 
  5. When you find a color that you like, click on the color and your paragraph will be shaded. 


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.

K2E Canada Inc. | Unit 10 - 8550 Torbram Road | Suite 121 | Brampton | Ontario | L6S 6H4 | Canada