K2 Office Tips Header
Volume 13, Number 5 

May , 2018
Spring has finally arrived here in Brampton, ON and I'm patiently waiting for the weather to warm up enough, so I can get out on the deck again. It's been a long time since I enjoyed a little bit of sun.

In April I completed the three reports for the 2018 Canadian Accounting and Bookkeeping Operations and Technology Survey. It was a lot of work, but it was enjoyable for me. I really appreciated the kind remarks that I received from many of the readers of the report.

Late in the month we finalized plans for the 2018 Accounting Technology Seminar series. For the 26th year we will be going coast to coast in 14 cities to present this one day seminar that will update accountants and bookkeepers on the the technology that they and their clients use.

This year we will have an exciting program with several new sponsors presenting their product line. Registration opens on May 1st. To reserve your spot CLICK HERE.

In 2018 we are continuing our "Road to Excellence" mini-webinars. You will find information on them below. Attend in person and earn 1 verified CPD credit when you answer 75% of the polling questions during the session. Every registrant will receive the recorded webinar; so sign up today to ensure that you're on the list. All sessions begin at 12:00pm ET.   
K2's Road to Excellence with Excel - Part 8 and VohCom

Tuesday May 15
K2's Road to Excellence with Excel - Part 9 and Adagio

Wednesday May 23
Tuesday June 19
K2's Road to Excellence with Excel Part 11 and Doc.It

Monday June 25
New for 2018 is our broad  curriculum of over 50 technology-focused CPD live webinars accessible from the comfort of your home or office and available for a remarkably low price. We invite you to explore our calendar of  Live Webinars covering a wide range of topics including Mastering Advanced Excel Functions and Formulas and Top Excel Tips and Tricks.  

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

Alan Salmo n, FCPB


Excel Tips


ExcelAutoFilterChanging the Orientation of a Cell      
Summary: Excel allows you to adjust how you want information to appear within a cell. You can easily specify how the information should be oriented (in which direction the cell data should be displayed). Here is how to do this:

Select the cells whose orientation you want to change.
  1. Click on this icon  in the Alignment group on the Home tab.
  2. In the drop down window select the angle for the cells.
  3. Click on OK. Your headings are turned as you directed.
  4. Format your columns so their width is better suited to the new text orientation.
Summary: There are times when you will want to clear everything in a worksheet except for cells which contain formulas. Here is how to do this:
  1. Press F5. Excel displays the Go To dialog box.
  2. Click the Special button. Excel displays the Go To Special dialog box.
  3. Select the Constants radio button. The four check boxes under the Formulas option then become available.
  4. Make sure that all the check boxes under the Formulas radio button are selected. (They should be selected by default.)
  5. Click OK. Excel selects all the constants (cells that don't contain formulas) in the worksheet.
  6. Press the Del key.
You are now left with only the formulas in your worksheet.

  1. Click the File tab on the ribbon.
  2. Click Options. Excel displays the Excel Options dialog box. At the left side of the dialog box click Quick Access Toolbar.
  3. Click the Import/Export drop-down list at the bottom right corner of the dialog box. Excel displays two options.
  4. Choose Export All Customizations. Excel displays the File Save dialog box.
  5. Using the controls in the dialog box, select a location where you want the backup file saved.
  6. Click Save. 
  7. Excel saves the customization file where you specified in step 5.
  8. Click on Cancel to dismiss the Excel Options dialog box.
The file created in step 7 is your backup file. Note that this file also includes any customization you have done to the Ribbon. You can store it where you store your other backups, and then reuse it by following the above steps, but choosing to import in step 4.

The Quick Access Toolbar files are plain text files and can be copied to a separate location for backup. There will be one for each Office application that has a Quick Access Toolbar defined.

  Back to top  


WordTipHeaderWord Tip


Adding Lines to a Document       
Summary: Lines are useful to enhance the way you convey informatiion in a document.Here is how to do this:
  1. Display the Insert tab of the ribbon.
  2. In the Illustrations group, click the Shapes tool. You'll see a large selection of shapes you can create.
  3. Click one of the line types in the Lines group. (Word allows you to draw several types of lines, including lines with arrows on the ends.)
  4. Position the mouse pointer where one end of the line is to be located.
  5. Click and hold the mouse button.
  6. Drag the mouse until the line is the desired length.
  7. Release the mouse button. 
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   CLICK HERE
. Your information is always kept secure and we
value your privacy; our Privacy Policy is available on our website.   
Alan Salmon
K2E Canada Inc.