When you first open an Excel spreadsheet, you’ll see that the sheet tabs are automatically named Sheet1, Sheet2, Sheet3 etc along the bottom of the screen…

You can change the name of these sheets so they’re relevant to the information contained within each spreadsheet. For example, you could have a sheet called “Sales” which contains all of your sales invoicing data, another one could be called “Purchases” which obviously contains all of your expenses, and so on.

To rename the individual sheets, all you have to do is right click on the name to bring up a menu, and select Rename.  You can also use this menu for deleting the sheet, changing the tab colour, hiding the sheet etc…

This will highlight the “Sheet1” ready for you to overtype with your required name, press return once you’ve finished. Then just repeat with the rest of the sheets…

Another (quicker) way of renaming sheets is to double-click the sheet name, so the name becomes highlighted, type in the required name and press return.

If you find you’ve run out of worksheets and want to add more to the file, just click on the last sheet tab which has an icon on it…

*TIP*  You could also use the keyboard shortcut, Shift+F11 to insert a new sheet 🙂