Microsoft Office Tutorials and References
In Depth Information
Switching Between Normal View, Page Break Preview, and Page Layout View Modes
Figure 3.36. The status bar shows the sum, average, and count of the selec-
The status bar shows the sum, average, and count of the selec-
If you need to quickly add the contents of several cells, you can select the
cells and look for the total in the status bar. This feature has been in Excel
for a decade, yet very few people realized it was there. In legacy versions of
Excel, only the sum would appear, but you could right-click the sum to see
other values, such as the average, count, minimum, and maximum.
You can customize which statistics are shown in the status bar. Right-click
the status bar and choose any or all of Min, Max, Numerical Count, Count,
Sum, and Average.
Note that the panel might show values for items that you have recently un-
selected. These figures will be wrong if the selection has changed.
Layout View Modes
Three shortcut icons to the left of the zoom slider enable you to quickly
switch between three view modes:
• Normal view
Normal view — This mode shows worksheet cells as normal.
• Page Break preview
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.