- Using the Ribbon
- Using the Quick Access Toolbar
- Using the Full-Screen File Menu
- Using Other Excel Interface Improvements
- Using the New Sheet Icon to Add Worksheets
- Navigating Through Many Worksheets Using the Controls in the Lower Left
- Using the Mini Toolbar to Format Selected Text
- Expanding the Formula Bar
- Zooming In and Out on a Worksheet
- Using the Status Bar to Add Numbers
- Switching Between Normal View, Page Break Preview, and Page Layout View Modes
Switching Between Normal View, Page Break Preview, and Page Layout View Modes
Three shortcut icons to the left of the zoom slider enable you to quickly switch between three view modes:
- Normal view—This mode shows worksheet cells as normal.
- Page Break preview—This mode draws the page breaks in blue. You can actually drag the page breaks to new locations in Page Break preview. This mode has been available in several versions of Excel.
- Page Layout view—This view was introduced in Excel 2007. It combines the best of Page Break preview and Print Preview modes.
In Page Layout view mode, each page is shown, along with the margins, header, and footer. A ruler appears above the pages and to the left of the pages. You can make changes in this mode in the following ways:
- To change the margins, drag the gray boxes in the ruler.
- To change column widths, drag the borders of the column headers.
- To add a header, select Click to Add Header.