The Different Areas of a Spreadsheet
There are 3 main areas to each spreadsheet, which is something all spreadsheet applications have in common: Columns Columns go vertically across the screen from top to bottom. On the top you’ll see the column...
Blog Most Recent Post
Explore Colour and other Design Options
In all Microsoft Office applications, there’s a colour palette with 10 different colours in different shades. Whenever you wish to change any colour in your document (for example for fonts or backgrounds) you can select...
Delete Copy and Move Worksheets
Now that we have covered How To Add Worksheets and How to Hide Worksheets (and how to make them visible again), let’s talk about copying and moving worksheets. Both can be done within the same...
How to Hide Worksheets (and how to make them visible again)
Hiding worksheets is another great way to keep your workbook organised. There can be plenty of reasons why you might wish to hide a worksheet. For example, if you have a worksheet that contains ‘helper...
Colouring in the Worksheet Tabs
If you would like to customise the worksheet tab bar further, you can assign a background colour to your worksheet tabs. This will change the background of the worksheet name, not the worksheet itself. Step...
Renaming Worksheets
In a new Excel file, one worksheet is created by default and named Sheet1. As mentioned in my previous post, it is good practise to rename worksheets to something more useful. While keeping the name...
How To Add Worksheets
Sheets are a great way to keep your workbook organised and therefore by many considered good practise to divide up your workbook’s content into several sheets. For example: You could have one worksheet as your...
What is a Worksheet?
The Oxford English Dictionary defines a worksheet as: ‘A single matrix of cells within a spreadsheet program, which may be grouped with others in a particular workbook.’ This ‘matrix of cells’ is that notable grid...