MS Excel 2007 - Lesson 12: Develop Workbook: Microsoft Excel

The following guide provides a clear overview of Microsoft Excel, with the most relevant background, details, and practical takeaways.

Microsoft Excel Overview

TipsMake. Com - Format Workbook tabs

You can rename a spreadsheet or change the colors of tabs if necessary. As well as moving, transferring and deleting sheets in the same workbook.

To rename the spreadsheet:

• Open the worksheet to be renamed

• Click the Format button on the Home tab

• Click Rename Sheet

• Enter a new name

• Press Enter

To change the color of the spreadsheet tab:

• Open the worksheet to change the color

• Click the Format button on the Home tab

• Click Tab Color

• Choose color

Move the spreadsheet in Workbook

To move spreadsheets in a workbook:

• Opening the workbook contains the sheets you want to reorder • Click and hold the spreadsheet tab until an arrow appears in the left corner of the worksheet

• Drag the spreadsheet to the desired location

Insert and delete spreadsheets

To insert a spreadsheet

• Open the workbook

• Click the Insert button on the Cells group of the Home tab

• Click Insert Sheet

To delete the spreadsheet

• Open the workbook

• Click the Delete button on the Cells group of the Home tab

• Click Delete Sheet

Copy and paste the spreadsheet

To copy and paste spreadsheets:

• Click on the tab of the spreadsheet to be copied

• Right-click and select Move or Copy

• Select the desired location of the sheet

• Click the check box next to Create a Copy

• Click OK.