Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

You can use the horizontal scroll bar in Microsoft Office Excel 2007 to scroll left and right in a worksheet and the vertical scroll bar to scroll up and down. The horizontal scroll bar appears at the bottom of the Worksheet area, while the vertical scroll bar appears to the right of the Worksheet area. Here are some scrolling techniques for navigating in an Excel worksheet:

  • To scroll one column or row at a time in a particular direction, click the appropriate scroll arrow at the ends of the scroll bar. For example, to scroll right one column, click the arrow on the right side of the horizontal scroll bar.

  • To move up or down an entire screen, click in the area above or below the scroll box in the vertical scroll bar. Click in the area to the left or right of the scroll box in the horizontal scroll bar to move left or right an entire screen.

  • If your mouse has a wheel, you can use it to scroll directly through the columns and rows of the worksheet without using the horizontal or vertical scroll bars. Simply position the white-cross mouse pointer in the center of the Worksheet area and then either hold down the wheel button of the mouse or press it once. When the mouse pointer changes to a four-pointed arrow, drag the mouse pointer in the appropriate direction until the desired column or row comes into view in the Worksheet area. Release the wheel button (or press it once) to stop scrolling.

    Use the scroll bars to navigate to unseen parts of an Excel 2007 worksheet.
    Use the scroll bars to navigate to unseen parts of an Excel 2007 worksheet.

You can resize the horizontal scroll bar — making it wider or narrower — by dragging the button that appears to the immediate left of its left scroll arrow. Just keep in mind that you could end up hiding some of the workbook’s sheet tabs if your workbook contains a whole bunch of worksheets.

The scroll bars bring only new sections of the worksheet into view — they don’t actually change the position of the cell cursor. If you want to start making entries in the cells in a new area of the worksheet, you still have to remember to select the cell (by clicking it) or the group of cells (by dragging through them) where you want the data to appear before you begin entering the data.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: