Developing a Workbook
Format Worksheet TabYou can rename a worksheet or change the color ofthe 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
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
Reposition Worksheets in a Workbook
To move worksheets in aworkbook:
§ 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
Insert and Delete Worksheets
To insert a worksheet
§ Open the workbook
§ Click the Insert button on the Cells group of theHome tab
§ Click Insert Sheet
§ Open the workbook
§ Click the Delete button on the Cells group of the Home tab
§ Click Delete Sheet
Copy and Paste Worksheets:
To copy and paste aworksheet:
§ Click the tab of theworksheet 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
Post a Comment