List of Tabs in Workbook
- Having tabs in an Excel workbook streamlines your work and makes it easier to use. It is particularly useful for work that needs to be detailed monthly or categorized by title. Creating tabs is easy to do and not only aids in speed of retrieving information but also looks effective.
- Click on "Start" then "Microsoft Office" then "Microsoft Excel." A blank spreadsheet will appear. Alternatively, open an existing Excel document by clicking on "Start," then "Documents" and then the folder containing your spreadsheet and finally the document itself.
- View tabs at the bottom of the page, which will be marked "Sheet 1, 2 and 3." On an existing document "Sheet 1" may have been replaced by a title.
- Right-click on the words "Sheet 1" (or 2 if one is already named) and a menu will appear. Click on "Rename" and type in the name for that worksheet, for example, "July," and press "Enter." Repeat this for Sheets 2 and 3.
- Click on the folder that is visible next to the now newly named third sheet. It will automatically insert a worksheet with a new tab that you can name as detailed above. To remove a worksheet and tab, right-click on the tab and a menu will appear. Click on "Delete." Remember, this will not only remove the tab but the worksheet attached to it.
- View all named tabs listed in a row at the bottom of your document. Click on each individual tab to enter that worksheet. When saving, click on "Save As" and it will save the whole workbook containing all the new listed tabbed and named worksheets.