K2 Office Tips Header
Volume 9, Number 1  

January, 2014

Happy New Year to you and yours. It is hard to believe that this is the ninth year that I have produced our K2 Office tips newsletter. 


It has sure been a different winter here in the suburbs of Toronto. Cold and more cold. Snow and more snow. it's been a long time since we have had a winter like this. The good news is that in two weeks Nancy and I will be in Jamaica for ten days.


I am now working on a new series of webinars that will launch in March. Stayed tuned for more information.


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




Alan Salmon

Excel Tips

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


Excel2Rounding to the Nearest Half Dollar        

Summary: There are times when you need to round amounts to the nearest half dollar. Here is an easy way to do this:  

For this task you can use Excel's =MROUND function. This function will round a value to any multiple you specify. In this case, if you want to round the value in B10 to the nearest half dollar, you would use this formula:



The 0.5 in the formula tells it to round it to the nearest half dollar. By changing this figure you can round to any multiple you want.




It is easy to Hide and Unhide columns in Excel. The exception is when you hide Column A. If you later want to unhide Columns A, the solution is challenging. Last month I gave you one solution. Here is another way to do


This method is even quicker, but you will have to have a good eye and a steady hand on your mouse pointer to make it work.

  1. If you move your mouse pointer into the column header area, and then slowly move it to the left, it will turn into a double-headed arrow with a blank spot in the middle, as you place your cursor over the small area immediately to the left of the column B header.
  2. This double-headed arrow is like the double-headed arrow that appears when you position your cursor  over the dividing line between column headers. You will now see that there are two black lines with a gap between them.
  3. When your cursor changes to this special double-headed arrow, right-click and select Unhide.


Your previously missing column A now reappears.



Word Tip


WordIndenting an Entire Paragraph             

Summary: It is quite easy to indent a whole paragraph to the next tab stop. Here is how to do this:  

To indent a paragraph to the next tab stop, follow these steps:

  1. Place your cursor in the paragraph that you want to indent.
  2. Click on Home tab of the ribbon.
  3. Click on the Increase Indent tool, in the Paragraph group. 

The block of text is now selected.


Back to top 

 PowerPoint Tips


Summary: Using the Control key in PowerPoint gives you access to some powerful short cuts. Here's how to use it save yourself a lot of time when you are formatting a slide.   

  • Hold down the CTRL key while clicking the slide show view button when you are editing a slide show. This will open a preview window so you can see that slide in slide show mode.
  • Hold down the CTRL key while dragging an existing Guide to create a new guide.
  • Hold down the CTRL key while turning the wheel on your mouse to zoom in and out of the slide
  • Hold down the CTRL key, plus the HOME key to go to the first slide
  • Hold down the CTRL key, plus the END key to go to the last slide in your presentation
  • CTRL + A (on the Slides tab) to select all objects
  • CTRL + A (in slide sorter view) to select all slides
  • CTRL + A (on the Outline tab) to select all text in your slide show
  • CTRL + B to apply bold formatting
  • CTRL + C to copy the selected object
  • CTRL + D to duplicate (make a copy of) the selected slide
  • CTRL + E to center a paragraph
  • CTRL + F to find text
  • CTRL + G to open the grids and guidelines dialog box
  • CTRL + H to replace text
  • CTRL + I to apply italic formatting
  • CTRL + J to justify a paragraph (full alignment)
  • CTRL + K to insert a hyperlink
  • CTRL + L to left align a paragraph
  • CTRL + M to insert a new slide
  • CTRL + N to create a new presentation
  • CTRL + O to open an existing presentation
  • CTRL + P to print a presentation
  • CTRL + Q to quit PowerPoint
  • CTRL + R to right align a paragraph
  • CTRL + S to save a presentation
  • CTRL + T to change the formatting of characters between sentences, lowercase, and uppercase
  • CTRL + U to apply underline formatting
  • CTRL + V to paste a cut or copied object
  • CTRL + W to close a presentation
  • CTRL + X to cut a selected objected
  • CTRL + Y to redo or repeat an action
  • CTRL + Z to undo the last action
 Back to top 


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