-
Step 1
Open a blank or existing Excel file and click on a worksheet tab on the bottom of your Excel worksheet.
-
Step 2
Add a worksheet tab by right-clicking on one of the tabs and choosing "Insert." To move your worksheet, drag it to the location you want it to appear.
-
Step 3
Delete a worksheet by right-clicking on the worksheet tab and selecting "Delete."
-
Step 4
Copy and move your worksheet tab by right-clicking on the worksheet tab you want to move/copy. Then place a checkmark by "Create a Copy" and choose the location where you'd like the worksheet copied and moved to.
-
Step 5
Rename a worksheet tab by double-clicking on its name and typing a new one.
-
Step 6
Change the color of your Excel worksheet tab by right-clicking on it. Select the tab color you'd like to use.
-
Step 7
Apply changes to all the worksheets in your Excel workbook by right-clicking on your worksheet tab and choosing “Select All Sheets.” Any additions or updates you make within a worksheet will apply to every selected worksheet in the workbook.
Comments
cobrakai said
on 11/20/2009 I need to use Excel for my ehow tracking. Great article. 5* and recommended
ruf1950 said
on 9/25/2009 Great job with this video-article on how to create and work with Excel Worksheet tabs. 5*****
femwriter said
on 9/6/2009 The steps of this article is truly informative. Thanks for writing this one!