follow me on facebook follow me on twitter Instagram

T is for Tabs: Excel

Tabs allow users to have multiple pages in an Excel file.
Each tab is called a worksheet.
The whole file is called a workbook.

The tabs are located at the bottom of the Excel window.

2013
Beginning with 2013 only one tab, called Sheet1, automatically appears at the bottom. Earlier versions had three sheets.
Only one tab is nice for those of us who always deleted the unwanted sheets to make the file look neat and tidy.









Create a tab. 
1. click on the + inside the circle to the right of the Sheet.
A new sheet is created called Sheet 2.

Note: When you Save the document all sheets are saved no matter which sheet you are currently in.
It does remember which cell and sheet you are in and will open in that sheet and cell when you reopen the file.

Right Click Contextual Menu
If you want to change the tab in someway but are not sure how to do it.
1. Right Click on the tab you want to change
    A contextual menu appears with the options for tabs.

Color tab
You can change the color of a tab.
1. Click on the tab you want to change the color.

2. Right Click on the tab.
    A contextual menu appears .

3. Select Tab Color.
    A menu appears on the right with different colors.

4. Click on the color you want.
    The color of the tab is light because it is the selected tab.
    Click on another tab and the tab color appears brighter and fills the whole tab.

Selecting tabs
You may edit more than one tab at a time but selecting the tabs you want to change before right clicking.
Consecutive tabs
1. Click on the first tab you want to select.

2. Hold down the shift key.

3. Click on the last tab you want selected.
    The first, last and all tabs in between are now selected.

4. Right click on any of the selected cells.

5. Select an item from the menu and all tabs will be effected.

Nonconsecutive tabs
1. Click on the first tab you want to select.

2. Hold down the CTRL key.

3. Click on the next tab you want selected.

4. Continue clicking on the different tabs you want.

5. When you have the last one selected, let go of the CTRL key.

6. Right click on any of the selected cells.

7. Select an item from the menu and all tabs will be effected.

No comments:

Post a Comment