K2 Office Tips Header
Volume 8, Number 12  

December, 2013

It's almost Christmas and the end of another year. We have much to be thankful for and in our situation this Christmas, unlike last year, I will be home with family. Nancy and I send Seasons Greetings to you and yours and hope that 2014 will be a wonderful year for you.


My next webinar will be in the new year. Stay tuned for news about the new series. I am about to start on two new eBooks and they should be available late in the first quarter of 2014. 


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




Alan Salmon

Excel Tips

Excel1Unhiding Column A

Summary: 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. Here is the solution: 


  1. Press the F5 function key.
  2. Excel displays the Go To dialog box.
  3. In the Reference field at the bottom of the dialog box, enter A1.
  4. Click on OK.
  5. Cell A1 is now selected, even though it is not visible on the screen.
  6. Select the Home tab on the ribbon.
  7. Click on the Format tool in the Cells group.
  8. Select Hide & Unhide.
  9. Select Unhide Columns.

Column A will now be visible.  


Excel2Sorting a Protected Worksheet       

Summary: When you protect a worksheet, Excel prevents you from performing a wide variety of tasks. If you want to sort a protected worksheet you need to change a setting. Here is how to do this:  

  • Click on the the Review tab of the ribbon
  • Click Protect Sheet in the Changes group, Excel displays the Protect Sheet dialog box.
  • At the bottom of the dialog box is a long list of check boxes.
  • Select the Sort check box. 

If you select this option, then users can sort protected data. 



Excel3Saving an Excel File in the CSV Format
Summary: CSV is a file type that allows you to transfer data from one program to another.If you need to save your Excel file into a CSV file here is how to do this: 

CSV stands for "Comma-Separated-Values. In the file, each value is separated by a comma. The importing program knows that when it sees a comma, it can get rid of it and accept a new value. If you have information in Excel that you want to get into a different data-oriented program, there is a good chance that the other program will accept CSV files. In order to save your workbook data in CSV format, follow these steps: 


  1. Click on the File tab. (In Excel 2007 click on the Office button).
  2. Click on the Save As dialog box.
  3. In the Save As Type drop-down list at the bottom of the dialog box, select the CSV (Comma delimited) option.
  4. Specify a file name and where the file is to be saved.
  5. Click on Save.
  6. Excel may display a dialog box telling you that not all Excel features can be maintained in the format you have chosen.
  7. Click on Yes to continue saving the information in the CSV format. 
At this point your worksheet is saved in the CSV format. You will now have your original Excel workbook (in the Excel format) and the CSV file, which contains the information you wanted in the CSV format.


Word Tip


WordQuickly Selecting a Block of Text             

Summary: You can select text in Word by holding down the left mouse button and dragging the mouse to make the selection. There is an even faster way to select text using your mouse. Here is how to do this:  
  1. Position the insertion point where you want the selection to begin.
  2. Move the mouse cursor so it points to where you want the selection to end.
  3. Hold down the Shift key as you click once on the left mouse button.

The block of text is now selected.


Back to top 

 PowerPoint Tips


Summary: Using the Shift 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 SHIFT key when drawing a line to get a perfectly straight line.
  • Hold down the SHIFT key when drawing an oval to get a perfectly round circle.
  • Hold down the SHIFT key when drawing a rectangle to get a square.
  • Hold down the SHIFT key while clicking on the normal view icon to get the Master slide.
  • Hold down the SHIFT key while clicking on the slide sorter view to get the handouts master.
  • Hold down the SHIFT key while pressing Enter to get a blank line without a bullet.
  • Hold down the SHIFT key to select multiple objects on a slide at the same time.
  • Hold down the SHIFT key while resizing a graphic to retain the same proportions in the resized graphic.
  • Hold down the SHIFT key while pressing F3 to change the case of letters.
 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.