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 database, and the second sheet where you addd calculations based on the data you have entered in your database. Adopting such as system early on will help you to navigate your workbook as it grows.

To add a new worksheet to your file, go to the bottom of your Excel screen. Next to the existing sheet(s) you will find a little plus symbol. If you hover over it with your mouse cursor, the text “New sheet” will become visible. This is a hint Microsoft has added as a feature; you do not need to wait to see this hint to be able to press the plus symbol.

Once you have clicked the button, your new sheet will automatically show up in the sheet tab bar. By default, Excel will use a sequential number in its name. In the example screenshots I have provided, Sheet1 was already taken, so the new sheet was automatically named Sheet2.

It is good practise to rename worksheets to something more useful. Now, while keeping the name Sheet1 is ok if it is the only worksheet in the workbook, now that there are several worksheets in this workbook, renaming the worksheets becomes more important. This will help you (and others, if the file is used by several people) to navigate the file more easily and quickly find what you are looking for. In my post Renaming Worksheets you can find out how to do this.