worksheet options
By default, one Workbook contains three Worksheets, which are referee to as Sheet 1, Sheet 2 and Sheet 3 and are shown at the bottom of the screen as sheet tabs:
The active sheet (i.e. the sheet on which you are currently working) is shown with a white tab and its name appears in bold text, while the inactive sheets are shown in grey.
The arrows to the left of Sheet 1 enable you to move quickly through the tabs in a Workbook that contains many sheets, i.e. in Workbooks where there are more sheets than can be seen on the screen at the same time.
Changing the number of default Worksheets within a Workbook
It is possible to change the number of default sheets by clicking on the Tools menu, then selecting Options. Click on the General tab, then change the Sheets in New Workbook option by clicking on the up arrow to increase the number of sheets or the down arrow to decrease the number of sheets:
Moving between Worksheets
To move between sheets, click onto the relevant sheet tab.
Renaming Worksheets
To rename a Worksheet so that the name is more meaningful, EITHER:
Right click on the relevant sheet tab, select the Rename option from the menu then type in the new name. Press Enter to save.
OR
Double click on the sheet tab and type in the new name. Press Enter to save.
As can be seen above, the right click menu can also be used to:
- Insert more sheets
- Delete sheets
- Move or Copy sheets
- Select all sheets
Inserting Sheets
To insert a new Worksheet, either use the right click menu as above or:
Click on the insert menu
Select Insert Worksheet
MS Excel will insert the new Worksheet to the left of the active sheet. If its in the wrong place, the sheet can be easily moved by clicking and dragging on the sheet tab until the black arrow points to the desired location, then the mouse button can be released.
