vert line

The Sheet Inspector changes items that affect the whole worksheet or all cells in the worksheet. The Tools Inspector... command opens the Inspector box, the sheet inspector is the top item in the list.

The Sheet Inspector displays and changes parameters of the currently active worksheet. When all worksheets close, the Sheet Inspector will automatically close because it has nothing to inspect.

 

Dimensions

Mesa worksheets can have up to 16,384 rows and columns. However, when a worksheet has this many cells, using the scrolls to move around the worksheet becomes very clumsy. The number of rows and columns displayed in the worksheet can be viewed and changed in the Dimensions section of the Sheet Inspector.

To change the dimensions, enter the desired number of rows or columns in the height or width boxes. Mesa worksheets also grow automatically when you move beyond the edge with the arrow keys.

NB. Demo versions of Mesa do not allow the dimensions to be changed.

The dimensions of the worksheet affect only how the information on the worksheet is displayed. A worksheet may display only 32 rows and columns, but may contain data in any cell in the worksheet. The data in cells that is not displayed is not lost and can be used in formulas and viewed by setting the worksheet dimensions to the appropriate size. There is no speed or storage size penalty associated with larger dimensions.

Recalc

Mesa always uses "natural order" recalculation so that the one answer for a given cell is returned correctly even if cell data in other parts of the worksheet are accessed. However, Mesa cannot resolve circular references in cell formulas. Circular Reference debugging is provided to track and allow you to fix circular references. To enable calculation debugging, select "Stop on Error" or "Stop on Circ." from the pop-up. To step or trace through macros, select the appropriate item from the pop-up.

By default, Mesa recalculates the entire worksheet each time data in the worksheet is changed. For large worksheets, this could take a second or two. To disable automatic recalculation, uncheck the "Automatic Recalculation" check-box. If Automatic Recalculation is disabled, remember to use the Range Recalculate command to update the worksheet after data has changed.

Grid

The "Show Grid" check box turns the worksheet's grid on and off. The color of the grid can be changed by dropping a color chip in the color well in the "Color" section of the inspector when the drop-down list is set to "Grid". You can change the background color of the entire worksheet by dropping a color chip inside the same color well when "Background" is selected from the list. Similarly, the color of protected cells can be set by the same method.

All cells that do not have background shading will display this color as their background. If the "Clear" check box is checked, the background will appear white on the screen, but if the cells are copied and pasted to another application, the background from that application will show through.

Protection

Cell Protection is used to block data entry into cells that are not specifically typed Unprotected. . To enable cell protection, check the "Enable Protection" check box.

If protection is enabled, protected cells will be skipped when tabbing through a range if "Skip Protected Cells" is selected. Protected cells will be displayed in a special color if "Show in Special Color" is selected and the worksheet is protected. The color of the protected cells can be changed by dropping a new color into the color well.

Size

This allows the default cell height and width to be changed. The current default width and height is displayed in the current measurement units. To change the width or height,type the desired size directly into the height and width boxes.

Changing the default will not change the size of rows or columns that have been resized. For more information, see "Resizing Rows and Columns" .

 

Also go to:

Index help

Contents help