K2 Office Tips Header
Volume 11, Number 11 

November , 2016
Both Nancy and I are glad to see November come to an end as we have both been sick with the flu during the month. That's the bad news. The good news is that we have almost all our Christmas shopping done, so December should be a less stressful month.

I did a keynote at the recent Intuit Thrive Conference and it was sure great to meet so many old friends. Our only stress was getting to the Royal York Hotel right in the middle of the Santa Claus parade. We finally made it and my session went well.

Our latest venture is a series of FREE 1 hour mini webinars that are held once a month. The first two have been a great success with both sessions sold out and and we had a good number of bookkeepers and accountants sign up to be view the recorded video.

The next webinar is scheduled for December 12th at 12:00 PM EST and is entitled "K2's Excel Magic Part III and Accelerating Your Practice with VohCom Page". It lasts for an hour and features 25 minutes of my Excel Magic tips  and then switches over to VohCom where you will see how to accelerate workflow in your office by eliminating your paper files and streamlining your processes with VohCom Page.

The session will be recorded, so if you can't join us for the live session, register and you can view the webinar on your time. You will receive 1 CPD for attending.  CLICK HERE to register for this free event.

Since this will be the last newsletter before Christmas, Nancy and I would like to wish you and yours a wonderful holiday season.
As usual, I would welcome your comments at   [email protected] .

Alan Salmo n

Excel Tips

ExcelTopCopying Conditional Formatting
Summary:  Conditional formatting is part of the regular formatting of a cell. If you want to copy the conditional format to a range of cells you need to do the following:
In Excel, conditional formatting is considered part of the regular formatting of a cell. If you want to copy conditional formatting from one cell to another, you can do so by simply copying the cell and pasting it (or its format) to another cell. If you want to copy a conditional format to a range of cells (and only the conditional format), the easiest way to do so is by following these general steps:
  1. Select the cell that contains the conditional format you want copied.
  2. Display the Home tab of the ribbon.
  3. In the Styles section, click Conditional Formatting. Excel displays various options related to conditional formatting.
  4. Click Manage Rules. Excel displays the Conditional Formatting Rules Manager. The format you want copied should already be filled in. Select whatever appears in the Applies To box.
  5. Using the mouse, click and drag to select the range of cells to which the conditional format should be applied.
That's it. Excel does the rest and copies the conditional formatting, as you desired.
ExcelTip2Quickly Moving to a Specific Cell or a Named Range
Summary: In large worksheets you often need to jump to a specific cell or a named range. Here is how to do this:   
Excel allows you to do this very quickly. If you want to select a named range, simply use the Name Box pull-down list (just above Column A) to choose the named range you want selected.
You can also use the Go To dialog box. Press F5 and the Go To dialog box appears. Select a range in the list displayed, or enter a specific cell reference (or range reference) to which you want to jump. When you click on OK, the specified region is selected.

Excel gives you complete control over how it prints your worksheets. If upi want, you can print more than one copy of your workshee. Here are the steps to print multiple copies:
  1. Display the Print dialog box (Excel 2007) or the print options (later versions of Excel). The easiest way to do this is to just press Ctrl+P.
  2. In the Copies box, indicate the number of copies you want to print.
  3. Set any other printing parameters you want, such as what you want printed and whether it should be collated or not.
  4. Click on OK.
  Back to top


Word Tip


Summary: There are several types of underlines that you can use in a Word document. Here is an explanation of your available choices'
Underlining of characters is handled from the Font dialog box, which is most easily displayed by pressing Ctrl+D. The dialog box allows you to select from a variety of underline types. The following are the major types available:

Underline Type
Removes any underlining from the selected text
Adds a single underline, the entire length of the selected text
Words Only
Underlines only the words (not spaces or tabs) in the selected text
Adds a double-line underline, the entire length of the selected text
Same as Single, but uses a line of dots instead
Same as Dots, but uses dashes instead of dots

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

[email protected]   with "Subscribe to newsletter" in the Subject.  
Your information is always kept secure and never shared.
Alan Salmon
Managing Director
K2E Canada Inc.