• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 13 How to Work with Worksheets

Task 13 How to Work with Worksheets

By default, Excel opens every new workbook file with three worksheets. You can add or delete worksheets as needed. You can also rename worksheets to better describe their contents. For example, you might have a quarterly sales report workbook, with sales totals for each quarter on separate worksheets. You can name each sheet with distinctive names such as Quarter 1, Quarter 2, and so on. You can even move and copy sheets within a workbook, or from workbook to workbook. In this task, you'll learn the various ways you can work with worksheets.

  1. Move from One Sheet to Another

    To move from one sheet to another, click the tab for the sheet you want to view. The selected sheet, or active sheet, is the one with the bright white-and-black sheet tab.



  2. Rename a Worksheet

    You can rename any worksheet in the workbook. Double-click a sheet tab; the current name of the worksheet is highlighted. Type a new name and press Enter.



  3. Delete a Worksheet

    Deleting a worksheet is almost too easy: Right-click the sheet tab for the worksheet you want to delete and choose Delete from the context menu. When Excel prompts you for confirmation, click Delete.



  4. Add Another Worksheet

    You can also insert a new worksheet into the workbook. Right-click any existing sheet tab and choose Insert from the context menu. On the General tab of the Insert dialog box, double-click the Worksheet icon. The new worksheet is inserted to the left of the sheet tab you initially right-clicked.



  5. Move a Worksheet

    To move a worksheet within a workbook, drag its sheet tab. While you drag, the mouse pointer acquires a sheet-of-paper symbol, and a small black triangle points to the position where the sheet will be moved. Drop the sheet tab when the triangle points to the location to which you want to move the sheet.



  6. Copy a Worksheet

    To make a copy of a worksheet within a workbook, press and hold the Ctrl key as you drag the sheet tab. While you drag, the mouse pointer acquires a sheet-of-paper symbol with a small plus sign, and a small black triangle points to the position to which the copied sheet will be inserted.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint