Guest Author - Chris Curtis
© Elusive Creations
A new Excel workbook opens with 3 worksheets by default. You can add up to 255 worksheets in a single workbook, as needed. Sheets are numerically labeled Sheet 1, Sheet 2, Sheet 3, etc. In the lower left hand corner of the worksheet, you will see a set of 4 arrow buttons. The outer two buttons jump to the first and last worksheets (left and right); the inner two buttons move one worksheet at a time in the direction of the arrow. Use these buttons to navigate between the worksheets.
You are able to customize your worksheets to suit your needs. You can add, copy, delete, move and rename (change the label) the worksheet tabs. When you copy a worksheet, you gain the advantage of retaining all the formatting it contains. Deleting a worksheet is a permanent deletion. You cannot undo a worksheet deletion, so caution is recommended.
Renaming a Worksheet
When you double click on the worksheet tab, you will see the label becomes selected, type the new worksheet label to replace the old label. You should rename your worksheets to identify its content.
Adding a New Worksheet
To add a new worksheet, select Insert/Worksheet from the menu bar. The new worksheet will be labeled with the next available Sheet # and be placed to the left of the active worksheet.
Copying a Worksheet
When you copy a worksheet, it is an exact copy including formats. The label on the copy worksheet will be the same label as the original worksheet with a (2). Rename the worksheet to identify its content. During the copy process, you choose where in the worksheet sequence you want to place the copy.
Copy a Worksheet
· Right click on the “Copy” worksheet tab
· Select Move or Copy from the shortcut menu
· Click in check box next to “Create a Copy” (at the bottom of the dialog box)
· Select the sheet that you want your copy to be placed before
· Click on OK
Deleting a Worksheet
Deleting a worksheet is a permanent deletion. You cannot undo a worksheet deletion. You will receive a warning that you are about to effect a permanent deletion. Click on OK to delete. Click on Cancel to cancel the process. Realize that if you delete a worksheet that formulas on other worksheets reference, the formulas will produce an error.
· Right click on the worksheet tab you want to delete
· Select Delete from the shortcut menu
· Click on OK at the warning prompt
Move a Worksheet
· Click and hold your mouse key down on the sheet you want to move
· Drag the sheet to the position you want
When you drag a sheet to a new position, you will see a “ghost” of the sheet. The black arrow will guide you where the sheet will be relocated.
Navigating the Worksheets
When you use the Worksheet navigation arrows. The arrows will scroll to the left or right but you need to click on the worksheet tab of your choice to make it active. Using the CTRL + PAGE UP or PAGE DOWN, you will “jump” the active sheet to the next worksheet.
When you right click on the worksheet navigation arrows, a list of worksheets in the current workbook will be displayed. Select the worksheet you want to “jump-to”.
Please contact your host with any questions. Please also feel free to make any suggestions or contribute a “Unique Technique” Suggestions should be accompanied by your name and title so that I may give the contributor credit.
Want to improve your MS Office skills, click here to find out how Elusive Creations can help you with your learning needs.
