Microsoft Office Tutorials and References
In Depth Information
• Chart sheets
• MS Excel 4.0 macro sheets (obsolete, but still supported)
• MS Excel 5.0 dialog sheets (obsolete, but still supported)
You can open or create as many workbooks as you want (each in its own window), but only one workbook is
the active workbook at any given time. Similarly, only one sheet in a workbook is the active sheet. To activate a
different sheet, click its corresponding tab at the bottom of the window, or press Ctrl+PgUp (for the previous
sheet) or Ctrl+PgDn (for the next sheet). To change a sheet's name, double-click its Sheet tab and type the new
text for the name. Right-clicking a tab brings up a shortcut menu with some additional sheet-manipulation op-
You can also hide the window that contains a workbook by using the View ⇒ Window ⇒ Hide command. A hid-
den workbook window remains open but not visible. Use the View ⇒ Window ⇒ Unhide command to make the
window visible again. A single workbook can display in multiple windows (choose View ⇒ Window ⇒ New Win-
dow). Each window can display a different sheet or a different area of the same sheet.
The most common type of sheet is a worksheet — which you normally think of when you think of a spread-
sheet. Excel 2013 worksheets have 16,384 columns and 1,048,576 rows.
How big is a worksheet?
It's interesting to stop and think about the actual size of a worksheet. Do the arithmetic (16,384 × 1,048,576), and
you'll see that a worksheet has 17,179,869,184 cells. Remember that this is in just one worksheet. A single work-
book can hold more than one worksheet.
If you're using a 1920 x 1200 video mode with the default row heights and column widths, you can see 29
columns and 47 rows (or 1,363 cells) at a time — which is about .0000079 percent of the entire worksheet. In oth-
er words, more than 12.6 million screens of information reside within a single worksheet.
If you entered a single digit into each cell at the relatively rapid clip of one cell per second, it would take you more
than 500 years, nonstop, to fill up a worksheet. To print the results of your efforts would require more than 36 milli-
on sheets of paper — a stack about 12,000 feet high (that's 10 Empire State Buildings stacked on top of each oth-
Versions prior to Excel 2007 support only 256 columns and 65,536 rows. If you open
such a file, Excel enters compatibility mode to work with the smaller worksheet grid. To
work with the larger grid, you must save the file in one of the newer Excel formats
(XLSX or XLSM). Then close the workbook and reopen it. XLSM files can contain mac-
ros; XLSX files cannot.