K2 Office Tips Header
Volume 11, Number 6 

June, 2016
It is summer time in Brampton. Our garden is coming along nicely and I get to admire it every day when Nancy and I have a coffee break on our deck.
June was family month. Within the space of 10 days my youngest daughter was married; this was followed by Father's Day; and then a birthday milestone for me. At the end both Nancy and I were exhausted but feeling blessed with wonderful families
This September we will be announcing a new relationship with the CPA community that will provide you with a catalog of webinars and recorded videos that are excellent and will qualify for full CPD credits.
We opened registrations for the 2016 Accounting Technology Seminar series on May 1st and we already have over 400 registrations. Cities sell out quickly so don't delay registering. We are excited about this year's program which features a revised schedule with two new excellent partners. You can register at www.k2e.ca.
As usual, I would welcome your comments at [email protected].

Alan Salmon

Excel Tips

ExcelTopUsing AutoFill to Just Select Workdays
Summary: AutoFill is a great time saving tool. Here is how to use AutoFill to just select workdays:  
The AutoFill feature of Excel allows you to quickly fill cells with all sorts of information, based on the content of cells you select. For example, if you fill two adjacent cells with the words "Monday" and "Tuesday," and then select those cells, you can drag the AutoFill handle to fill other cells with other days of the week. 
However let us us suppose that only want to fill cells with the workdays, Monday through Friday? To do this involves one small change to how you use the AutoFill handle. Instead of clicking and dragging it with the left mouse button, click and drag with the right mouse button.
As soon as you release the button, a Context menu will appear. Two of the options on the menu are "Fill Days" and "Fill Weekdays." If you choose Fill Days, then the range is filled with the names of the seven days of the week, the same as if you had used the left mouse button to do the AutoFill. The other option, Fill Weekdays, fills the range with the names of only the five days of the week, Monday through Friday.
Excel2AChanging the Default Font in Excel
Summary: If you do not like Calibra 11 as your default font when you open a new Excel workbook here is how you change it to your favorite font. 
To change to a different default font involves the following steps:
  1. Display the Excel Options dialog box. 
  2. In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.
  3. Click on Popular (Excel 2007) or General (Excel 2010, 2013 and Excel 2016) at the left side of the screen.
  4. Change the Use this Font drop-down list (Excel 2007 and Excel 2010) or the Use This As the Default Font drop-down list (Excel 2013 and 2016) to the font that want to use as your default.
  5. Click on the Font Size drop-down list to pick the size of font you want Excel to use.
  6. Click OK.
  7. Restart Excel.
Now every time you create a new workbook, Excel will use these settings as the default. The only times it won't is if you base a new workbook on a template or store a template named Book.xltx or Book.xltm in the XLStart folder. (In this second case, you've overridden how Excel formats a new workbook by whatever is set within the Book.xltx or Book.xltm template file.)

These steps won't change the font in any previously created workbooks; those stay as they were when you saved them.

Excel3Using the Shadow Style Tool

By using this tool you can add a drop shadow behind an object. This can help add more depth to your graphics, so that they will look like they are raised off the surface of the Excel worksheet.

  1.  Start by selecting the object. 
  2. The Format tab of the ribbon should be visible. 
  3. In the Shape Styles group, click the Shape Effects tool. 
  4. Excel displays a drop-down list from which you should select Shadow
  5. The resulting options indicate the different types of drop shadows you can apply to the shape. 
  6. You can also modify the shadow, once placed, by choosing Shadow Settings (Excel 2007) or Shadow Options (later versions of Excel). 


Word Tip


WordTip2Deleting the Blank Pages at the End of a Document
Summary: Sometimes when you print a Word document you end up with one or two blank pages at the end. Here is how to get rid of those pages: 

Why that happens is usually the fact that you have a bunch of empty paragraphs at the end of your document. Even though you can't see them on the screen (normally), they are there and take up extra space.


To delete the empty paragraphs do the following: 

  1. Press Ctrl+End to go to the end of your document. 
  2. Then press the Backspace key until you have deleted all the non-printing characters (such as empty paragraphs). 
  3. When you are done the insertion point should be located next to the last character you want printed in your document. 
To display the empty paragraphs that are at the end of your document do the following before you delete them:
  1. Click the Show/Hide tool on the Home tab of the ribbon; it looks like a backwards P. 
  2. When the tool is selected, you can see all the spaces, paragraphs, tabs, and other characters in your document. These are all the characters that normally don't show up on your screen. 

This can be very helpful for figuring out why something doesn't look quite right in your document.


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.

K2E Canada Inc. | Unit 10 - 8550 Torbram Road | Suite 121 | Brampton | Ontario | L6S 6H4 | Canada