Use worksheets to list and analyze data. You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets. When you create a chart, you can place the chart on the worksheet with its related data or on a separate chart sheet.

The names of the sheets appear on tabs at the bottom of the workbook window. To move from sheet to sheet, click the sheet tabs. The name of the active sheet is bold.

 Note If you open a workbook created in earlier versions of Microsoft Excel, Microsoft Excel 97 preserves macro sheets and dialog sheets and converts module sheets into modules in the workbook's Visual Basic project. You can run and modify your Microsoft Excel version 4.0 macros and Microsoft Excel version 5.0 and 7.0 dialog sheets in Microsoft Excel 97, and you can add new macro sheets and dialog sheets by right-clicking a sheet tab and then clicking Insert on the shortcut menu. However, it's recommended that you create new macros and dialog boxes in the Visual Basic Editor. To view and modify converted Visual Basic module sheets or to create new macros and dialog boxes, point to Macro on the Tools menu, and then click Visual Basic Editor.

Insert a new worksheet

• To add a single worksheet, click Worksheet on the Insert menu.

To add multiple worksheets, hold down SHIFT, and then click the number of worksheet tabs you want to add in the open workbook. Then click Worksheet on the Insert menu.

Insert a new sheet that's based on a custom template

You must have already created a custom sheet template.

1. Right-click a sheet tab, and then click Insert.
2. Double-click the template for the type of sheet you want.

 Create a sheet template for new worksheets

• Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.
• On the File menu, click Save As.
• In the Save as type box, click Template (*.xlt).
• In the Save in box, select the folder where you want to store the template.

To create the default worksheet template, select either the XLStart folder in the Microsoft Excel folder or the alternate startup folder. To create a custom sheet template, select the Templates folder in your Office folder or your Microsoft Excel folder.

• n the File name box, type sheet to create a template for default worksheets.

To create a custom sheet template, type any valid file name.

• Click Save, and then click Close on the File menu.

Hide all or part of a workbook

You can hide workbooks and sheets to reduce the number of windows and sheets on the screen and to prevent unwanted changes. For example, you can hide sheets that contain sensitive data. The hidden workbook or sheet remains open, and other documents can use their information. You can also hide selected rows and columns of data that you aren't using or that you don't want others to see.

To prevent others from displaying hidden sheets, rows, or columns, you can protect the workbook or sheet with a password.

 Select data, cells, chart items, or objects by using shortcut keys

Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys

Scroll and zoom on a Microsoft Excel sheet by using the Microsoft IntelliMouse pointing device

You can move around and zoom on your worksheet or chart sheet by using the Microsoft IntelliMouse pointing device. For information about changing options and viewing troubleshooting tips for the Microsoft IntelliMouse, see the IntelliPoint Online User's Guide. (Click the Windows Start button, point to Programs, point to Microsoft Input Devices, and then point to Mouse.)

Tips

·    To jump to a different location on the worksheet, zoom out, click the new location, and then zoom in.
·    If you use the Microsoft IntelliMouse pointing device to zoom more often than you use it to scroll on a sheet, you can set the wheel button to zoom instead of scroll. On the Tools menu, click Options, click the General tab, and then select the Zoom on roll with IntelliMouse check box.

Display hidden rows or columns

• To display hidden rows, select cells in the row above and in the row below the hidden rows.
  To display hidden columns, select cells in the column to the left and in the column to the right of the hidden columns
• On the Format menu, point to either Row or Column, and then click Unhide.
  

Tip:  If the first row or column of a worksheet is hidden, click Go To on the Edit menu. Type A1 in the Reference box, and click OK. Point to Row or Column on the Format menu, and then click Unhide.

Create a sheet template for new worksheets

• Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.
• On the File menu, click Save As.
• In the Save as type box, click Template (*.xlt).
• In the Save in box, select the folder where you want to store the template.

To create the default worksheet template, select either the XLStart folder in the Microsoft Excel folder or the alternate startup folder.

To create a custom sheet template, select the Templates folder in your Office folder or your Microsoft Excel folder.

• In the File name box, type sheet to create a template for default worksheets.

To create a custom sheet template, type any valid file name.

• Click Save, and then click Close on the File menu.