Pages

Wednesday, December 2, 2009

Using Tab Scrolling Buttons in MS Excel

 

Tab Scrolling Button are nothing but the sheet navigation buttons and are used to to scroll through the available worksheets in a Microsoft Excel Workbook. When you start the MS Excel application you see three worksheets by default. However, if your workbook includes several worksheets, you would be forced to use the Sheet Navigation Button for viewing the hidden worksheets. The sheet navigation button is located at bottom left of the Excel application interface as shown Figure 1 below.

image

Figure 1

The Tab Scrolling Buttons are used to scroll through the list of available sheets in an Excel Workbook File. If you are able to see all worksheets in current view then clicking it will have no visual change in current view.

The Tab Scrolling buttons can also be used to jump to a particular worksheet without scrolling through all the sheets. In order to jump to a sheet directly right click on any of the Sheet Navigation Buttons. A list of available sheets in the Workbook is displayed in Figure 2 below.

image

Figure 2

You can click on a sheet to directly jump to that. This tip becomes handy when working on an excel workbook with several worksheets.

I hope you found the information useful and Thank you for reading.

No comments:

Post a Comment