Workbooks

One of the most common Excel objects is a workbook. Everything that you do in Excel takes place in a workbook, which is stored in a file that, by default, has an XLSX extension. An Excel workbook can hold any number of sheets (limited only by memory). There are four types of sheets:

■ Worksheets

■ XLM macro sheets (obsolete, but still supported)

■ Dialog sheets (obsolete, but still supported)

You can open or create as many workbooks as you like (each in its own window), but at any given time, only one workbook is the active workbook. Similarly, only one sheet in a workbook is the active sheet. To activate a sheet, click its sheet tab at the bottom of the screen. To change a sheet's name, double-click the tab and enter the new text. Right-clicking a tab brings up a shortcut menu with additional options for the sheet, including changing its tab color, hiding the sheet, and so on.

You can also hide the window that contains a workbook by using the View Window1 ! Hide command. A hidden workbook window remains open, but it is not visible to the user.

0 0

Post a comment