Excel Managing Workbooks

A worksheet, sometimes called a spreadsheet, is a collection of cells that can have more than 1 million rows down and more than 16,000 rows across. Each cell of each sheet can contain more than 32,000 characters.

Secondly, a workbook is a collection of worksheets. By default, each time you create a new Excel workbook, it contains three worksheets. Each workbook however, can have an almost unlimited number of worksheets, limited only by your computer memory. The resulting possible number of cells in a single workbook is too huge to even dream about, but the fact remains you could create a single huge workbook. Realistically, however, you'll probably have a number of different workbooks, each with a number of worksheets.

Working with documents is critical to using any software. Microsoft Excel documents are known as workbooks. This part covers the procedures that you need to know to manage workbook documents efficiently.

Excel makes it easy to work with multiple worksheets. You can maneuver between the sheets by clicking a sheet tab. It even provides navigation buttons for situations when you have a lot of tabs. This chapter is primarily about working with multiple sheets. You discover how to insert, delete, move, and copy worksheets, rename the tabs that reference them, and create formulas that reference other worksheets or workbooks and learn how to create hyperlinks to jump to Web sites, other cells, or workbooks and how to create an instant e-mail.