Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

The Status bar appears at the bottom of the Microsoft Office Excel 2007 window and keeps you informed of Excel’s current mode and any special keys you engage. In addition, you can use the status bar to select a new worksheet view and to zoom in and out on the worksheet.

The Status bar contains the following areas:

  • Mode button that indicates the current state of the Excel program (Ready, Edit, and so on) as well as any special keys that are engaged (Caps Lock, Num Lock, and Scroll Lock)

  • Macro Recording button (small worksheet icon with a red dot) that opens the Record Macro dialog box, where you can set the parameters for a new macro and begin recording it

  • AutoCalculate indicator that displays the Average and Sum of all the numerical entries in the current selection along with the Count of every cell in the selection

  • Layout selector that enables you to select between three layouts for the worksheet area:

    • Normal: Default view that shows the worksheet cells with the column and row headings

    • Page Layout: View that displays rulers, page margins, headers and footers, and shows page breaks for the worksheet

    • Page Break Preview: Enables you to adjust the paging of a report

  • Zoom slider that enables you to zoom in and out on the cells in the worksheet area by dragging the slider to the right or left, respectively

    View and change settings (such as Zoom and the worksheet view) in the Status bar.
    View and change settings (such as Zoom and the worksheet view) in the Status bar.

You can customize the display of certain options on the Status bar. Right-click the Status bar and select an option to enable the feature. Options that appear with a check mark are already active.

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: