K2E Canada Office Tips January 2019
|
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:
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.
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
|
|