Jul10

Tagged in:Using Microsoft Excel, How To Use Excel Comments:2 comments

How To Use An Excel Workbook Basics

The workbook concept is similar to that of the old ledger. The ledger being the workbook. You can have as many sheets (or worksheets) in the workbook that you desire, but the virtual worksheets are much more mobile and flexible than their physical counterparts.

It's Like A Book!

You can move, copy, rearrange the worksheets within the same workbook or "ledger" or add, copy, trade or manipulate sheets into another workbook. Microsoft refers to this as "3-ring-binder" concept. Moving sheets at will between workbooks and/or copying within the same workbook or moving that information to a new workbook.

Workbook Basics

To open a workbook, click on File then Open on the upper menubar or just click the open button. This will open your directory interface. Navigate to the file that you want to open, click on it and then click the "open" button.

If you want a new workbook, click on File then New from the menubar or just click the "New" button.

The workbook will open in the Excel window. You'll notice at the bottom of the window that there are a series of tabs. These are your sheets or worksheets.

Each worksheet is a intersecting grid of rows and columns forming cells that makes up each worksheet and multiple worksheets make up your Excel workbook.

Microsoft Excel Workbook Definition And History