K2 Office Tips Header
Volume 12, Number 1 

January , 2017
It's the beginning of a New Year and Nancy and I have much to be thankful for. 

This is the start of the 12th year that I have been publishing the K2E Canada newsletter. I took out my calculator and did a quick calculation. It is hard to believe that this is the 128th edition. I have only missed 3 issues and that was when I was in the hospital recovering from surgery. 

2016 was a great year for K2E Canada and we expect 2017 to be just as successful. In October we will mark the 25th anniversary of the Accounting Technology Seminar Series and we are already working to make it the best ever.

Our latest venture  of a FREE series of monthly 1 hour mini webinars has been hugely successful and the feedback from my Excel Magic sessions has been very positive. They have all sold out and in addition, we had a good number of bookkeepers and accountants sign up to view the recorded videos.

The next mini webinar is scheduled for January 30th and February 6th at 12:00 PM EST and is entitled "K2's Excel Magic Part V and Intuit Profile".   It will last for an hour and features 25 minutes of my Excel Magic tips and then switches over to Intuit Canada, where you will get a first look at the enhancements in ProFile that will enhance your productivity during this year's tax season. 
The January 30th session is sold out but there is still room on the February 6th webinar. The webinar will be recorded, so if you can't join us for the live session, register and you can view the webinar on your own time. You will receive 1 CPD for attending.  CLICK  HERE  to register for this free event.  
As usual, I would welcome your comments at   alan@k2e.ca .

Alan Salmo n

Excel Tips

ExcelTopDecMoving Quickly Between Worksheets
Summary: I am a big keyboard shortcut fan. I like to minimize moving my hand from the mouse to the keyboard and back again. Here is the keyboard shortcut to quickly move from sheet to sheet :

You can use Ctrl+PgUp and Ctrl+PgDown to quickly move from one worksheet to another using the keyboard.  You use Ctrl+PgUp to move toward the first worksheet in the workbook, and Ctrl+PgDown to move toward the last.  

Note: When you reach the first or last worksheet, Excel does not wrap to the opposite end of the workbook if you continue to press the same shortcut key.
ExcelSecondDec Protecting 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 the Protect 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.


Word Tip


WordDecForcing a Page Break Before a Paragraph
Summary: When you are creating a document,  there may be certain types of paragraphs that should always begin at the top of a page. For instance, you may have a certain paragraph format that you use for section headings. Your page design calls for all sections to begin at the top of a page, so you must come up with a way to ensure this always happens.  Here is how to do this:  

There are two ways you can do this. The first is to search for each section heading and manually insert a page break before each of the heads. This can be time consuming, however. It is much easier to format the paragraph so it always begins on a new page. This is done with these steps:
  1. Position the insertion point in the section head paragraph.
  2. Check to be sure the Home tab of the ribbon is selected.
  3. Click on the small icon at the bottom-right of the Paragraph group. Word will then display the Paragraph dialog box.
  4. Display the Line and Page Breaks tab.Be sure the Page Break Before check box is selected.
  5. Click on OK.
Using page breaks before your section headers is even more automatic if you use a style for all of your headers. To do this format the style so that the header will always have a page break before it. Once you do this, each time you use that heading style, Word will insert the page break.
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
Managing Director
K2E Canada Inc.