K2 Office Tips Header
Volume 12, Number 7 

August , 2017
Nancy and I are certainly enjoying summer here in Brampton. The forest behind our house is now so thick that we can't see the house across the conservation area. 
Registration for the 2017 Accounting Technology seminar is now open and we already have over 900 registrations, a new record. This is the 25th year that we have traveled from coast to coast presenting this one-day update on the technology that accountants, bookkeepers and their clients use. Because it is our 25th anniversary, we will be celebrating. Each attendee will receive the 25th Anniversary webinar edition of my favorite Excel Tips. Many cities sell out quickly so CLICK HERE to register and hold your place.
Our monthly Excel Magic mini-webinars have been a great success. The next two sessions will be in August in conjunction with CCH Canada and Adagio by Softrak. Every registrant will receive the recorded webinar so sign up today to ensure that you're on the list.     

As usual, I would welcome your comments at   alan@k2e.ca

Alan Salmo n FCPB

Excel Tips

ExcelTopDecChanging the Colour of the Grid-Lines
Summary: Gridlines help you track information and quickly locate cells. The default colour for these lines is black, but it is easy to change them to some other colour. Here are the steps to do this:
Display the Excel Options dialog box. (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.)
  1. At the left of the dialog box click Advanced.
  2. Scroll down the options until you see the Show Grid-lines check box; select it. (It is in the Display Options for this Worksheet section.) 
  3. Click the Grid-line Color control and choose a colour you want to use for the grid-lines. Be sure the Show Grid-lines check box is selected.
  4. Click on OK.
You can specify different grid-line colors for each worksheet in a workbook.
Summary: It is important to check if a row or column has data before you delete it. Here is a quick way to check for a completely blank row or column: 
It is easy to delete rows or columns you think are blank, when in fact they contain data you cannot see on the screen. Here are the steps to check for data without scrolling through the gazillion rows and columns in your worksheet: 
  1. Click on the first cell of the column (A1, H1, etc.).
  2. Hold down the Ctrl key as you press the down arrow or the right arrow.
Performing these simple steps causes Excel to move to the next cell containing data. If there is no data, Excel selects the last cell in the column (at row 1,048,576) or the last cell in the row (at column XFD). You then know that the row or column is empty and you can safely delete it.
There are times when you would like to check the size of a workbook. Workbooks in Excel can become very large depending on the information it contains. Keeping track of the size of a workbook is important. Here is how to check on a workbook's size: 

Excel keeps track of various pieces of information about a file in the Properties dialog box. How you display the dialog box depends on the version of Excel you are using. If you are using Excel 2010, Excel 2013, or Excel 2016 follow these steps:
  1. Display the File tab of the ribbon.
  2. Make sure the Info option is selected at the left side of the dialog box.
  3. Click the Properties link near the right side of the dialog box and then click Advanced Properties. Excel displays the Properties dialog box for your workbook.
  4. Make sure the General tab is displayed.
If you are using Excel 2007, follow these steps instead:
  1. Click the Office button and then click Prepare | Properties. Excel displays the Document Properties pane just below the ribbon and above your worksheet.
  2. Click Document Properties and then choose Advanced Properties. Excel displays the Properties dialog box.
  3. Make sure the General tab is displayed.
In the General tab, Excel displays the size of the file.


Word Tip


WordDec Changing Headers and Footers
It is easy to change the text in a header or footer by using the Header/Footer option in the View menu. Here is how to do this: 

You can easily change the text in a header or footer by using the Header/Footer option from the View menu, in the following manner:
  1. Display the Insert tab of the ribbon.
  2. Click either the Header or Footer tool in the Header & Footer group. Word displays a list of options.
  3. Click Edit Header or Edit Footer, depending on what you selected in step 2. Word activates either the header or footer area of the page.
  4. Change the contents of the header or footer in the same manner as you edit normal text in your document. 
  5. Click on the Close Header and Footer tool (on the Design tab of the ribbon) when you are done making changes.
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 never shared.
Alan Salmon
K2E Canada Inc.