Working with Sheets

Working with Sheets

Depending on which version of Excel you use, when creating a new workbook, there will usually be either one or three blank sheets (or Tabs) entertainingly named Sheet1, Sheet2 & Sheet3. These can be added to, deleted, renamed & coloured as necessary

Adding a new Sheet (Tab)

By far the quickest & easiest way is to click on the large “+” button to the right of the last sheet in your workbook – whether you have one or ten (or more) it will always be there to add more (there used to be a maximum of 256, however with the latest versions of Excel, the maximum is limited by the memory of your computer & arguably, if you have too many sheets, your workbook will begin to become unmanageable, anyway)

Deleting a sheet

Again, there are a number of ways of doing this but there are two quick ways…

The first is to click with your righthand mouse button on the Sheet Tab that you’re wanting to delete & then select Delete from the menu that appears

The second is to select Delete Sheet from the dropdown arrow underneath the Delete button which you’ll find over to the right on the Home Tab of Excel

Irrespective of which method you choose to use, if there is data on the sheet that you are about to delete, Excel will prompt you with a warning…

If you click delete & then realise that you didn’t mean to (as some of your formulas on other sheets are now showing #REF! errors), it’s too late as the Undo button will not help!

So, before you decide to delete the sheet, I would always recommend that you save a copy of your spreadsheet & then, having deleted the sheet, just check to see that all of your formulas are working. If not, close down your spreadsheet without saving changes & then re-open it from the saved copy that you created.

Renaming a sheet

In most cases, names such as Sheet1, Sheet2, etc are not really useful – especially if you are linking formulas from one sheet to another – so it may be that you want to rename your sheets to something a little more useful such as “Input Data” for the sheet where you enter the raw data or “Static Data” to hold information that never, or rarely, changes (for example price lists or equipment & serial numbers)

As ever, there are a number of ways that this can be done – the one that I use is to simply double click on the sheet name (which highlights it), type in the new name & then press enter

An alternative is to right click on the sheet name & select Rename from the menu that pops up. This will cause the sheet name to be highlighted as before; obviously the simple double click avoids a step & is therefore quicker!

Changing the Tab colour

Once you right click on the tab, one of the options that becomes available is Tab Color (American spelling!) with a right hand pointing arrow. You can then select the colour that you want by clicking it with your mouse pointer

Moving Sheets

When we create a new sheet, it’s not always in the correct place; for example, the new sheet may be for your static data which you’d prefer to be on the far left of all of the sheets in your workbook.

To quickly move the sheet, Œ select the sheet & hold down your left-hand mouse button. As you move the mouse to where you’d like the sheet to be, you’ll notice that 
a little “page” icon appears attached to the mouse pointer. An arrow Ž
will appear to indicate where the sheet will end up

Copying sheets

To create an exact copy of a sheet (including column widths and row heights), do exactly the same as above, but this time holding down the Control (or CTRL) button at the same time. You’ll usually find this button as the very bottom, right-hand button on your keyboard.