Workbooks and worksheets

Workbooks

An Excel "file" is a workbook... like a three-ring binder full of pages. Each "page" is a worksheet. When you open or save a workbook, you are opening/saving every sheet in it. We are no longer dealing with individual "spreadsheets," each saved with a different name. Imagine the workbook (or "file") name as the name of the three-ring binder.

Excel's workbooks are its documents.

Worksheets

Each worksheet can contain 256 columns and over 16,000 rows. The name of the sheet appears on the sheet's tab, just like a tab on a page of a three-ring binder. Click a worksheet's tab to select it and "pull it to the top." If necessary, use the tab scroll buttons to locate the tab you desire.

Worksheet tabs

Managing workbooks & worksheets

These procedures will help you effectively manage workbooks and worksheets.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish