K2E Canada Office Tips January 2019


Excel Tips

Moving a Worksheet from One Workbook to Another

Summary:  There are times when you want to move a worksheet from one workbook to another. Here is how to do this:

  1. Make sure both the source and target workbooks are open.
  2. Display the worksheet you want to move.
  3. Choose Move or Copy Sheet from the Format icon in the Cells group on the Home tab. This displays the Move or Copy dialog box.
  4. Using the To Book pull-down list and select the name of the target workbook. The list of worksheets in the Before Sheet list will change to reflect the workbook you selected.
  5. In the Before Sheet list, select the worksheet that should come after the worksheet you selected in step 2.
  6. Click on OK.

The worksheet is moved.

Using Keyboard Shortcuts

Summary:  If you like using keyboard shortcuts as I do, here are some little known shortcuts that I find useful:

The keyboard shortcuts for Excel allow you to access almost everything on the ribbon and Quick Access toolbar. While the Quick Access toolbar shortcuts are subject to change, the ribbon shortcuts are predictable and worth learning.
 
You can use the Alt key to access the ribbon tabs. Excel labels each tab of the ribbon with a different letter. Selecting the letters F, H, N, P, M, and A will allow you to access different tabs of the ribbon. The Quick Access toolbar shortcuts are numbers 1 through 9, and then they start using two digits from 09 down to 01. 
After pressing Alt+H, Excel draws in new shortcut keys to access all of the commands on the Home Tab. Alt+C is Copy, F+P is Format Painter, and F+O is the dialog launcher for the Clipboard group.
 
Some of these keyboard shortcuts are obvious; for example, FS stands for Font Size and FF stands for Font Face. AL is Align Left. Other keyboard shortcuts make sense in a historical context; for example, Ctrl+V has meant Paste for 25 years, so it seems natural to use V for Paste. Some of the shortcuts don't seem to have any rhyme or reason; I have no idea why H is used for fill color.

In some cases, a keyboard shortcut leads to a new flyout menu or gallery. Some items in that menu will have shortcut keys. Others might require using the arrow keys to select them.

Word Tip

Displaying the Ruler

Summary: The ruler appears at the top of each Word document window. It is highly useful when you need to adjust your formatting. There are times however the ruler is not visible. When that happens here is how to get it back:

  1. Click on the View tab of the ribbon
  2. In the Show group click on the ruler check box (shortcut key Alt-W-R)

The ruler will now be visible.
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

Video Tip

Using Categories in Outlook

Summary:  Categories allow you to easily identify and group associated items in Microsoft Outlook. Assign a category to a group of interrelated items—such as notes, contacts, appointments, and email messages—so that you can quickly track and organize them. Here's the video tip from the webinar K2's Road to Excellence with Outlook Part 1 and Wolters Kluwer