Tagged: Spreadsheet Setup

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...

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...

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...

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...

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...

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...