K2 Office Tips Header
Volume 13, Number 7 

July , 2018
The weather here in Brampton now is just right which means that I get out on our deck for coffee with Nancy on a regular basis. 

July will be a busy month for me as I have five webinars to do. I am now focused on plans for the 26th edition of the Accounting Technology seminar series, which will go from coast to coast in October. This year we will have an exciting program with a special segment on accounting apps. During this hour you will learn the advantages of using HubDoc, Receipt Bank and Payment Evolution with the Intuit and Sage products. We already have 700  registrations so you would be well advised to register early.  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 a link to the recorded webinar; so sign up today to ensure that you're on the list. All sessions begin at 12:00 pm ET. 

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 catalogue 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 TipsExcelTips


How to Display a Negative Percentage in Red
Summary: It is not obvious how to display a negative percentage in red. Here is how to do it:: 
  1. Select the cell or cells that may contain negative percentages. Click on the Home tab.
  2. Click on the Number Group.
  3. Click on the small icon in the lower left hand corner of the Number Group.
  4. Select Custom.
  5. In the Type Box enter the following:

        _(* 0.00%_);[RED]_(* (0.00%);_(* 0.00%_) 
  6. Click OK. 
The format you specified above will display positive percentages with two decimal places and will display negative percentages in red with brackets and two decimal places.

Summary: The AutoFill function is a great tool to use when you are doing certain types of editing. Here is a useful keyboard way of saving time using AutoFill:
Let's assume we have a column full of values in column A running from A3 through A417. We want to fill the adjacent cells in column B with a numerical sequence of values running from 1 through 417. 
  1. Use the following steps to accomplish this task:In cell B3, place the value 1. 
  2. In cell B4, place the value 2.
  3. Select the range B3:B417.Double-click on the AutoFill handle. (The green square in the bottom right corner of cell B3)
No dragging and you now have cells B5:B417 filled with sequential values.  

We will use the GoTo feature in Excel. Simply follow these steps:
  1. Press F5. Excel displays the Go To dialog box.
  2. Click Special. Excel displays the Go To Special dialog box.
  3. Make sure the Formulas radio button is selected.
  4. The only check box that should be selected under Formulas is Errors. 
  5. Click OK. Excel selects all cells where the formula returned an error value.
  6. Type 0 or whatever value you want.
  7. Press Ctrl+Enter.
Note that this approach results in any error values being replaced, not just those with the #N/A error. The errors will be permanently replaced with the value you type. Use this tip with caution.

  Back to top  


WordTipHeaderWord Tip


Summary: The ruler appears at the top of each Word document window. It is highly useful when you need to adjust your formatting. There are times however, when the ruler is not visible. When that happens, here is how to get it back:
Word allows you to control whether the ruler is displayed or not. If the ruler is not displaying do the following:
  1. Click on the View tab of the ribbon
  2. In the Show group click on the ruler check box

The ruler will now be visible.

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.