K2 Office Tips Header
Volume 8, Number 5  

May, 2013
ExceltopIn This Issue 
Excel Tips 

Quick Link
 Technology Tips Video
WordtopIn This Issue 
Word Tip
PPTTopIn This Issue
PowerPoint Tips
Quick Links


Previous versions of Office Tips



Like us on Facebook 


Follow us on Twitter



View our profile on LinkedIn 

















Spring has finally sprung in my part of Ontario, just north of Toronto in Brampton. I came home from rehab at the end of last month and it was sure great to get out of the hospital. We have made renovations to our home so I can live and work on the ground floor. Another major step is I am now able to move from my wheel chair to the car, so I have a lot more mobility.


My focus at the moment is our fall Accounting Technology seminar series which we deliver in 13 cities across Canada to bookkeepers, small accounting firms and consultants. In one day they get an update on what's happening in technology for their clients and their practices. This is the 21st year I have been doing this For more information go to

Look for more of my popular eBooks in 2013 and an exciting new online program that we will launching this summer. More information to come in the coming months. 


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




Alan Salmon

Excel Tips

Using a Text Box 

Summary: There are times when you want to add a note to a cell. It is easy to do this with a Text Box. Here is how to do this:  

  1.  On the Insert Ribbon select Text Box.
  2. Draw a rectangle in your worksheet about the size and shape that you want your text to fill.
  3. Paste or type in you text.
  4. Select the text in the text box and use the Mini Toolbar to format the text to an appropriate font size.
  5. Right click in the text box and select Format Shape. On the Line Color category, select No Line. In the Text Box category you, you can specify the number of columns you would like in the Text Box. 

Excel2ASorting Protected Worksheets             

Summary: When you protect a worksheet a number of useful functions are turned off. This includes preventing you from sorting the worksheet. If you do need to sort a protected worksheet you need to change a setting. Here is how to do this:


When you protect a worksheet, Excel prevents users from performing a wide variety of tasks on the data in the worksheet. This includes being no longer able to sort data. However, there may be times when you will want to be able to sort data, but still keep the sheet protected.


There are settings in Excel that allow you to specify what users can and cannot do with a protected worksheet. If you display the Review tab of the ribbon and click Protect Sheet in the Changes group, Excel displays the Protect Sheet dialog box. This dialog box contains a list of check boxes. This enable you to define what the user can do with the worksheet. One of the options is Sort and if you select this option, then users can sort protected data. 


Back to top


Excel3Quick Translations 
Summary: Since we live in a global world it is sometimes useful to be able to translate text in Excel to another language. Excel now has a translation tool that will do just that in most of the major languages. Here is how to do this.  
 Select a cell that contains the text you want to translate. 
  1. In the Review tab click on Translate.
  2. The research panel will appear on the left hand side of the window.
  3. Select the From and To languages.


Excel will then send the phrase out to WorldLingo.com and return a translation of the phrase.


Word Tip


Word1Be Selective with How You Select            

Summary: There are numerous shortcuts for selecting text in Microsoft Word. Here are two little known ones that will enhance your productivity.  

 If you just want to select a single sentence, hold down Ctrl and click on any word. To select an entire table, hold down Alt and double-click. 


Back to top 

 PowerPoint Tips


Summary: Here are a series of composing tips to help you prepare a professional PowerPoint presentation

  • Don't copy & paste slides from different sources.
  • Keep the design very basic and simple. It shall not distract.
  • Pick an easy to read font face.
  • Carefully select font sizes for headers and text.
  • Leave room for highlights, such as images or take home messages.
  • Decorate scarcely but well.
  • Restrict the room your design takes up and don't ever let the design restrict your message.  

Remember that your slides are only there to support, not to replace your talk! You'll want to tell a story, describe your data or explain circumstances, and only provide keywords through your slides. If you read your slides and if you do it slow and badly, the audience will get bored and stop listening.


 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 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
K2 Enterprises Canada