Navigation: CADSiteTools-Reports > Spreadsheet Editor > How to... > Workbook fundamentals >

Change workbook display options

 

 

 

 

 

 

1.      Select View > Workbook Explorer or press F6 to display the Workbook Explorer.

2.      Expand the corresponding workbook node and select the worksheet node. To expand a node, select the plus symbol to the left of the node name.

3.      Check or uncheck display window options as needed.

 

 

 

Window options:

 

1.      Formulas. If checked, formulas in cells will be displayed instead of the resulting value.

2.      Zero values. Shows or hides cells with zero values.

3.      Outline symbols. Shows or hides the outline symbols of grouped rows and columns.

4.      Row & column headers. Shows or hides row and column headers.

5.      Gridlines. Shows or hides the corresponding worksheet gridlines.

6.      Zoom. Modifies worksheet view extents. Values between 25 and 400% can be specified.

7.      Gridline color. Displays the color selection list where color to be applied to gridlines can be selected.

 

 

 

 

 


Copyright © 2003-2012 CadSite Software

http://www.cadsitetools.com