5.5 Working with Workbooks

Till now we have been working with a worksheet. Collection of such sheets is called as workbook. By default, each new workbook is made up of 3 sheets. However, Excel provides the facility to extend the number from 3 to 255 sheets. This means to an existing workbook you can add  to a maximum of 239 additional sheets. You can have several types of sheets like worksheets, chart sheets, macro sheets etc. All this implies that workbook format allows you to store related data on separate sheets but in a single file

5.5.1 Displaying workbook sheets

Excel displays a tab for each workbook. These tabs are visible on the lower part of the worksheet i.e. just above the status bar at the bottom of the screen. These tabs are handy for moving from sheet to sheets.

Open a new file and see the tabs just above the status bar. You’ll find sheet1 active.

Okay, now lets move around in the workbook: -

5.5.1.1 Displaying Sheets

a)      Click on sheet2 tab in your workbook.

b)      Excel displays that sheet.

c)      Next click on Sheet3 tab. Excel display that sheet. 

5.5.1.2 Scrolling Tabs

A faster and easier way to move between the sheets is to use the tab scrolling buttons on the left of the tabs. The tow outer buttons take you to the beginning and end of the tab display and the two inner buttons move you one tab at a time in the direction of buttons arrow.

a)      Click on the leftmost button. Excel displays the tab starting from sheet1.

b)      Click the rightmost button. Excel displays the tab set ending at sheet3 or whichever is the last sheet in the workbook.

c)      Click on the left inner tab. You will start moving one tab at a time in the left direction.

d)      Click on the right inner tab. You will start moving one tab at a time in the right direction.

Copyright © 2001 Selfonline-Education. All rights reserved.