K2 Office Tips Header
Volume 13, Number 3 

March , 2018
We're having a spring weekend as I write this newsletter here in Brampton, Ontario. Nancy and I are hoping that this marks the end of winter.

I am busy now analyzing the data from the  2018 Canadian Accounting and Bookkeeping Operations and Technology Survey. We received an amazing 2,532 respondents. When I get the report finished in mid March it will provide a comprehensive picture of the Canadian accounting and bookkeeping world today.

K2E Canada Inc. in association with Intuit Canada, is proud to announce the launch of the 2018 Top 10 Influencers in the Canadian Bookkeeping World recognition program. This program will recognize the key thought leaders whose efforts left a visible mark on the bookkeeping profession in Canada.
Eligible to be nominated for this recognition are bookkeepers and accountants in public practice; employed accountants and bookkeepers; consultants; and educators who teach bookkeeping and accounting.

The Top 10 Influencers will be selected by an independent panel of judges and the names of the Top 10 will be announced at Get Connected Calgary in May.  To nominate a worthy candidate or to nominate yourself go to www.bookkeepinginfluencers.ca  to review the program's criteria and submit a nomination. You can nominate yourself. Nominations open March 1 st and close March 26 th .

If you are interested we invite you to j oin the Dentons' National Tax Group for an insightful analysis of the 2018 Federal Budget. This webinar will go beyond a mere summary of the Budget and the Department of Finance commentary. It will offer a thoughtful examination of the proposed changes, and their impact on tax planning and tax compliance. To join the webinar at 12:00 noon on March 1st 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 a 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.     
New for 2018 is our broad  curriculum of over 50 technology-focused CPD live webinars accessible from the comfort of your home or office. We invite you to explore our calendar of  Live Webinars covering a wide range of topics including Top Excel Tips and Tricks and Excel Pivot Tables for Accountants - Part 1.  
As usual, I welcome your comments at  alan@k2e.ca 
Alan Salmo n, FCPB


Excel Tips


ExcelAutoFilterHow to Display a Negative Percentage in Red        
Summary: Excel allows you to easily adjust how you want to display information in a cell. It is not obvious how to display a negative percentage in Red. Here is how to do this: 

Select the cell or cells that may contain negative percentages.
  1. Click on the Home tab. 
  2. Click on the Number Group.
  3. Click on the small icon in the lower right hand corner of the Number Group.
  4. Select Custom.
In the Type Box enter the following:

_(* 0.00%_);[RED]_(* (0.00%);_(* 0.00%_) 

      5. 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: It is easy to Hide and Unhide columns in Excel. The exception is when you hide Column A. If you later want to unhide Column A the solution can be challenging. Here is how to do this:
  1. Press the F5 function key. Excel displays the Go To dialog box.
  2. In the Reference field at the bottom of the dialog box, enter A1.
  3. Click on OK.
  4. Cell A1 is now selected, even though it is not visible on the screen.
  5. Select the Home tab on the ribbon.
  6. In the Cells group click on Format
  7. Select Hide and Unhide. 
  8. Select Unhide Columns.
Column A will now be visible.

ProtectWorkbook P rotecting Your Workbook from Changes to the Structure of the Workbook
Summary: You can protect an Excel workbook from changes to the structure of the workbook by turning on workbook level protection. This will prevent another user from inserting new worksheets, deleting a worksheet or renaming a worksheet. Here is how to do this:  
To protect your workbook, click on the  Review  tab of the ribbon and click on the  Protect Workbook  tool in the  Changes  group. Excel then will show you the  Protect Structure and Windows  dialog box.

The two check boxes in the dialog box enable you to define exactly what you want protected in the workbook. Here is what each choice does:
  • Structure. This will prevent any changes to the worksheets. A user cannot add new ones, delete existing ones, change their names or the order of any worksheets.
  • Windows. This will stop a user from moving any windows that are being used in the workbook.
At the bottom of the dialog box you can specify a password to use for this level of protection. When you click the OK button Excel asks you to repeat any password you specified. If you did not provide a password, then Excel protects your workbook directly.
If you later want to remove the protection applied to a workbook, you do so by following the same steps you used to protect it. To unprotect your workbook, click on the Review tab of the ribbon and click on theProtect Workbook tool in the Changes group. If you used a password to protect the workbook, Excel displays the Unprotect Workbook dialog box. At this point, all you need to do is enter the correct password and the workbook is unprotected.
Note that protecting a workbook without protecting the worksheets it contains provides you with little protection. Even though a user cannot delete a worksheet in a protected workbook, they can delete the information in the worksheet. Workbook protection does not protect the contents of your workbook at any level "lower" than individual worksheets.  

  Back to top  


Word Tip


WordTipChanging the Default Start-Up Directory         
Summary: The default directory where you save your files is usually your "My Documents" folder. If you would like your Word documents to always save to a different directory here is how to do this:
  • Open the Word Options dialog box by clicking on the File tab on the ribbon and then click on Options.  
  • Click on the Save option at the left side of the dialog box.
  • To the right of the Default Local File Location field click on the Browse button. 
  • Select the directory you want as the start-up directory for your documents.
  • After you have selected that directory click on the OK button.
  • Close the Word Options dialog box by clicking on the OK button.
  • Exit and restart Word. 
Now that directory will be the default folder when you open or save a file.
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.
Alan Salmon
K2E Canada Inc.