My favourite tips of 2018
As this will be the last tip of the year I thought I’d highlight some of my favourite tips from 2018. If you joined the list part way through the …
How to lock column & row headings in place in Excel
In a large Excel worksheet with many rows and columns, when you scroll down or across the column and row headings disappear and it can be difficult knowing what the …
Reopen a recently closed tab in your browser
I sometimes end up with lots of tabs open in my browser so decide to declutter and close a few of them. When doing this I sometimes accidentally close a …
Going nowhere when you press Enter in Excel
When I enter a formula in Excel, I often want to finish up the data entry and stay on the same cell so I can see formula in the cell …
Spice up your Word documents with Page Borders
Developing a one-page document in Word to put up on a notice board? Want to spice it up and make it more visually interesting and fun? Then use Page Borders. …
Convert bullets on a PowerPoint slide to a SmartArt diagram
You can use SmartArt in PowerPoint to make your slides more visually interesting. If you have a slide with fairly short lines of bulleted text, say four to six words, …
Mark a file Read Only
On occasion you may have a file that you want to open and use but you want to be sure you don’t accidentally save any changes. Maybe it is the …
Keyboard shortcut to display your Home Page in your browser
When using your browser, you may occasionally want to return to your Home Page and I am sure you have found the Home button on the toolbar. Yet if your …
Quickly go to a page in Word
When you are working with a large Word document you might sometimes what to quickly get to a specific page in the document. Maybe there is a table on the …
Colour alternating rows in an Excel worksheet – Option 2
In last week’s tip we looked at how you can use conditional formatting to colour alternate rows in an Excel workbook. Another way of doing this is to use a …