Search notes:

Excel: View -> Show

The Menu View -> Show can be used to show or some elements on the GUI. The right column shows how these elements can be manipulated with Excel's object model:
Comments Object model
Ruler Only applicable in Page Layout mode ?
Formula Bar application.displayFormulaBar
Gridlines worksheetView.displayGridlines
Headings Show/hide column numbers and row letters worksheetView.displayHeadings
Note: Ruler, Gridlines and Headings change the setting for the active window only while Formula Bar sets it «globally».

Index