List of Tabs in Workbook

104 11
    • 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.

    Creating or Opening a Document

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

    Viewing the Document

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

    Renaming Tabs

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

    Adding and Removing tabs

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

    Moving Between Tabs and Saving Documents

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

Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time

Leave A Reply

Your email address will not be published.