Easily convert an older MS Office file format to the current format
A client recently sent me a word document with a list of attendees for an upcoming course. I was surprised to see the document was a .doc as this file …
How to collapse the Formula Bar in Excel
If you have formulas that reference cells in another workbook, the formulas can get quite long and a single row in the Formula Bar may not be sufficient to see …
What can you hyperlink to in a document?
As a follow-on to last week’s tip on creating a hyperlink to a web page, this week we are going to look at creating a hyperlink to another location in …
Quickly create a hyperlink in an email
If you often create hyperlinks to a web page, this week’s tip will come in useful. I use this the most in email messages but it works equally well in …
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 …