Worksheets In Excel
Spreadsheets in Excel are referred to as worksheets. Individual worksheets in excel is stored together in a workbook. When you save your work in Excel you do not save individual worksheets; rather, you save the workbook. Data entered in one worksheet can be entered into other worksheets at the same time. Data can be passed between worksheets. Data can also be imported into worksheets from other workbooks or other sources.
A workbook can consist of one or more worksheets. The tabs for these worksheets appear at the bottom left-hand corner of the screen. Clicking a sheet tab makes that sheet the current worksheet. The current tab can be easily identified because its tab text is bolded and has a thick line below the text.
In addition to adding and formatting data, following are some of the ways to manipulate worksheets:
• Rename them
• Add or Remove them
• Hide and Unhide them
• Reorder them
• Copy them to the same workbook
• Copy or Move them to another workbook
Naming Worksheets in Excel
If you add a second worksheet it would be named Sheet2 by default. If you add a third worksheet it would be named Sheet3 by default, and so on. These names are not helpful because they don’t provide any clue as to what is on the worksheet, but fortunately, you can rename them to something more meaningful.
There are two ways to rename a worksheet:
• Right-click a sheet tab and select Rename. This will highlight the tab you right-clicked
(see Figure a) and put the tab text in edit mode in which you can type over the current text.(see Figure b).
• Double-clicking a sheet tab will also put the tab text in edit mode.
Adding and Removing Worksheets
You can add new worksheets to your workbooks or remove them.
Worksheets can be added by doing one of the following.
• Clicking the New Sheet button.⊕ Clicking the New Sheet button adds the new worksheet after the currently selected worksheet.
• Right-click a worksheet tab and select Insert, which displays the Insert dialog box
(See image below). Select Worksheet and click OK to add a blank worksheet.
You also can use add a prebuilt worksheet known as a template. Click Spreadsheet Solutions to see the available templates (See image below). There are some very nice templates available on the Spreadsheets Solution tab. There is a Blood Pressure Tracker, a Personal Monthly Budget template, a Loan Amortization template, and so on. Click a template to view it in the Preview area. Double-clicking one of these templates add it as a worksheet in your workbook.
- A worksheet can be removed by right-clicking its tab and selecting Delete.
Changing a Worksheet Tab Color You can make the different tabs easily distinguishable by making them different colors. You can change the background color of each tab by right-clicking a tab, selecting Tab Color, and then selecting a color. (See image below)
Selecting Multiple Worksheets
You can select multiple worksheets by holding the down Ctrl key while you click the worksheet tabs. You can select multiple adjacent worksheets by clicking the first worksheet tab you want to use and then holding down the Shift key and clicking the last worksheet tab you want to use.
Hiding and Unhiding Worksheets
You can hide a worksheet by right-clicking its tab and selecting Hide from the menu. Hiding doesn’t delete the worksheet or change it in any way. You can bring back any worksheets you have hidden by right-clicking any of the worksheet tabs and selecting Unhide… The Unhide dialog box displays all of the worksheets you have hidden. To Unhide a worksheet just selects the worksheet you want to redisplay and click the OK button. (See image below)
Reordering and Copying Worksheets
You can change the order of the worksheets by dragging and dropping their tabs to where you want them placed. When you drag a worksheet tab the cursor displays as a document. A down arrow moves as you drag indicating where the worksheet will be placed when you let go of the mouse button. (See image below)
Another way to change the order of the worksheets is to right-click the tab of the worksheet you wish to move and then select Move or Copy from the context menu. The Move or Copy dialog box displays all of the sheets in your workbook. You can either select which sheet you want to place it before or you can select (move to end) to make it the last worksheet in your workbook. (See image below)
The Move or Copy dialog box has a checkbox option for creating a copy of the worksheet. Selecting this option will make a duplicate worksheet of the one you right-clicked and it will place the new copy in the location you specify in the Before sheet: area of the dialog box. Excel names the new copy the name of the original sheet plus it adds a number of the copy in parentheses.(Figure-I) shows that a copy of Sheet1 was moved to the end and named Sheet1 (2). If another copy was made of Sheet1 it would be named Sheet1 (3). You can also rename the copied worksheets to something more meaningful.
Using Tab Buttons to Move Through the Worksheets
If there are dots to the left of the worksheet tabs this means that there are more worksheets to the left of those currently showing. These dots are called ellipsis. If there is an ellipsis to the right of the worksheet tabs this means that there are more worksheets to the right of those currently showing. (See image below)
Clicking the Next worksheet button displays the tab for the next worksheet giving the result as shown in image below: