K2E Canada Office Tips August 2018


Excel Tips

How to Print an Excel Workbook
Without Opening It

Summary: There are times when you need to print an Excel workbook without opening it. Here is an easy way to do this.

If you just want to print a copy of a workbook you do not need to open the file. To do this follow these steps:
  1. Use Explorer to select the workbook that you want to print.
  2. Right-click on the file.
  3. Windows will display a Context menu.
  4. Select the Print option from the Context menu.
  5. Excel will then open and load the workbook.
  6. The workbook will print.
  7. The workbook will then be closed.

Moving Around the Corners of a Range

Summary: There are times when you need to quickly move to a corner of a selected range. This is very easy to do and here's how:

Here are the steps:
  1. Select the range
  2. Hold down the Ctrl key and press the period key.
  3. Each time you press "Ctrl +." Excel moves you to the next corner of the range
  4. You can also move from the top left corner of the selection to the bottom right corner by pressing Shift+Tab
  5. To move back to the top left corner, you press the Tab key.

Word Tip

Inserting One File into Another

Summary: There are times when you want to insert another Word file into your document. Here's how to do this:

To add a file to the document you are working on:
  1. Position the insertion point where you want the file inserted
  2. Click on the Insert Tab on the Ribbon
  3. In the Text group, click the down-arrow to the right of the Object tool
  4. Select Text from the File option.
  5. Browse to the File you want to Insert
  6. Click on OK. The file will now be inserted below your insertion point
Vertical Divider
We hope that you are enjoying our monthly newsletter featuring tips that will help you to be more effective using Microsoft Office products.

More Ways to
Earn Verified CPD


Access the many courses from the leader in providing CPD to professionals throughout North America.
Catalogue of upcoming webinars

Excellence with Excel webinar series

Excellence with PowerPoint and Word webinar series

Video Tip

Excel's Watch Window

Summary: When you are working with large workbooks it is useful to be able to see key metrics change regardless of where you are in a worksheet. Excel has a great tool that lets you do this.

Check out the Watch Window in our video tip from the webinar
K2's Road to Excellence with Excel - Part 12 and Adagio