Friday, January 20, 2012

How to Use the Scroll Bar in Excel


1. Open the Excel workbook that you want to navigate by double-clicking on it. If you have a different program set your default application to open Excel files, right-click on the excel file select 'Open with' and then choose 'Microsoft Office Excel.'
2. Left-click on the arrow buttons at either end of the main scroll bars to scroll down the spreadsheet one row or column at a time. The vertical scroll bar is located at the far right of the Excel window and the horizontal scroll bar is located in the bottom right-hand portion of the Excel window.
3. Left click on the position bar (the lighter colored bar segment located within either scroll bar), hold down the mouse button, and drag the bar to quickly scroll through the area of the spreadsheet that is being used.
4. Right click on any spot along a scroll bar and select 'Scroll Here' to automatically move the position bar to that spot.
5. Left click on the position bar, hold down the mouse button and the shift key and then drag the bar to quickly scroll through large numbers cells. Holding the shift key and moving the bar will scroll through thousands of cells quickly.

Blogger news