Sunday, 7 March 2010

Excel's "Advanced" Display Options (Worksheet Focus)

Perusing Excel's "Advanced" Display Options via the Microsoft Office button demonstrates three different categories of Display Options ("Display", "Display options for this work&book", and "Display options for this work&sheet"). Keep hitting "Alt-S" until you get to the worksheet display options. Here you can make page breaks disappear and gridlines disappear also. There is also an option to show zero in cells that have a zero value. There is also an explicit page break view which you can access from the (now-familiar) view portion of the chaotic Ribbon.

No comments: