Colour alternating rows in an Excel worksheet – Option 1
In a large spreadsheet that has many columns of data it can be difficult following a specific row as you scroll to the right. This is especially true if you …
Using AutoCorrect to save keystrokes for common phrases
You can use AutoCorrect to save keystrokes for phrases you commonly use. I often talk about step-by-step instructions in my proposals and emails. My typing skills or OK but words …
How to create recurring Outlook appointments with an irregular pattern
Let’s say you set up a recurring appointment or meeting and one of the occurrences falls on a stat holiday. You want to move that one occurrence to the next …
Format only some of the text in an Excel cell
One of the first things most Excel users quickly discover is how to change the font, font size and colour of text in cell. However, you may not have discovered …
How to quickly create the cent symbol in Word
Want to use the cent symbol in a Word document and don’t want to search for it in the symbols? Just use the keyboard shortcut: Ctrl+/, c.
How to paste Excel cells as a picture
You might occasionally have data in Excel that you want to include in an email, PowerPoint presentation or Word document. When you paste the cells into the email, presentation or …
How to Pin and Mute browser tabs
Web browsers have a couple of handy features that you may not have run across. Pin a tab. I have a few sites that I always open whenever I open …
Keyboard shortcut to bookmark a web page
Surfing the web and run across a page you want to bookmark so you can come back to it later? What’s the quickest way to bookmark the page? Press Ctrl+D. …
Using Google’s Calculator
Google is the most popular search engine and I am sure many of you use it for your searches. What you may not know is that Google has a built-in …
Useful MS Office function key shortcuts
These work in all the MS Office programs: F4 – Repeat the last command. Useful if you are doing repetitive formatting in a file F7 – Run the Spellcheck F12 …