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.
1 comment:
When you get to the point where you want to assign "owners" to individual worksheets within a workbook, you have 2 choices: flagging the file as "Shared" followed by posting the file on a shared server drive or you can look at Distributed Spreadsheet, an add-in for Excel that removes the need for real-time access.
Either way, Excel becomes very powerful when multiple people participate.
Post a Comment