Insert a Screenshot in an MS Office document
I recently had someone email me with a question about one of the Weekly Tips. Helpfully, they included a screenshot so I could see what they were talking about. I …
Quickly jump to a distant worksheet in Excel
If you have an Excel workbook with many worksheets, here’s a handy tip. If you want to quickly jump to a distant worksheet in the workbook, rather than scrolling through …
Calendars from Office Online
With 2018 upon us you may be looking for a calendar to use this year. Rather than creating one yourself, I suggest having a look at the free calendars available …
My favourite tips of 2017
As this will be the last tip of the year I thought I’d highlight some of my favourite tips from 2017. If you joined the list part way through the …
Many uses for Page Up and Page Down in Excel
If you want to scroll up or down in a worksheet you likely know you can use the Page Up and Page Down keys instead of the scroll bar. But …
How to enter Chris in Excel if the column already contains Christine
When you are entering rows of data in a workbook, Excel has a handy feature that saves you keystrokes. If you enter sufficient characters to uniquely match an existing entry …
How do you email only the people you have added to an Outlook meeting?
Subscriber Danielle C. asks “How do I add attendees to a meeting that already exists without sending updates to the whole group?” If you add attendees to a meeting you …
Use the Prt Scr key to copy only the active window
As you work on your PC, you might occasionally get an unexpected error message popping up on the screen. In these instances, you probably want to capture the message so …
After searching for an Outlook email, how do you find which folder it’s in?
Sometimes I go looking for an email and it’s not in the folder where I thought it would be. Maybe I’ve accidentally filed it in some other folder. I do …
Optimize your Windows taskbar by using small icons
As you open more and more programs on your system, the Taskbar can get quite cluttered. If you turn on the Small Icons feature in Windows you’ll be able to …