Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Excel
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
«Formatting a Worksheet Developing a Workbook Printing »

Format Worksheet Tab
You can rename a worksheet or change the color of the tabs to meet your needs.
To rename a worksheet:

  • Open the sheet to be renamed
  • Click the Format button on the Home tab
  • Click Rename sheet
  • Type in a new name
  • Press Enter

Rename Sheet Drop Down

To change the color of a worksheet tab:

  • Open the sheet to be renamed
  • Click the Format button on the Home tab
  • Click Tab Color
  • Click the color

Tab Color Drop Down Menu

Reposition Worksheets in a Workbook
To move worksheets in a workbook:

  • Open the workbook that contains the sheets you want to rearrange
  • Click and hold the worksheet tab that will be moved until an arrow appears in the left corner of the sheet
  • Drag the worksheet to the desired location

Move Worksheet

Insert and Delete Worksheets
To insert a worksheet

  • Open the workbook
  • Click the Insert button on the Cells group of the Home tab
  • Click Insert Sheet

Insert Sheet Drop Down Menu

To delete a worksheet

  • Open the workbook
  • Click the Delete button on the Cells group of the Home tab
  • Click Delete Sheet

Delete Worksheet Drop Down Menu

Copy and Paste Worksheets:
To copy and paste a worksheet:

  • Click the tab of the worksheet to be copied
  • Right click and choose Move or Copy
  • Choose the desired position of the sheet
  • Click the check box next to Create a Copy
  • Click OK

Move or Copy Right-Click Menu

<
«Formatting a Worksheet Developing a Workbook Printing »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory