Navigation: CADSiteTools-Reports > Spreadsheet Editor > Workbook Explorer > Node settings > WorkbookSet > Workbook >

Worksheet

 

 

 

 

 

 

 

 

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.

8.      Protect sheet contents. Checking this option will mark the selected worksheet locked cells as protected. An optional password to unprotect the sheet can be specified. Locked cells can not be edited if the corresponding worksheet is protected. Cells marked as unlocked before the worksheet is protected can be edited after the worksheet is protected. By default all worksheet cells are marked as locked.

9.      Hide sheet. Hides or shows the corresponding worksheet. There must be at least one visible worksheet.

10.   Tab color. Color can be selected to fill the corresponding worksheet tab.

 

 

 

 

 


Copyright © 2003-2012 CadSite Software

http://www.cadsitetools.com