By default, NExS creates columns that are twelve (12) positions wide. As mentioned earlier in this chapter, you can use the Sheet Defaults dialog box to change this default for the spreadsheet, creating a uniform set of columns of some user-specified width. You can also set individual columns to be wider or narrower than the default by using the Column Width option under the Format menu or by simply dragging the column border with the mouse.
To change the default column width:
To explicitly set the width of selected columns:
To restore the original default column width to selected columns:
NExS provides a snap-to mechanism which forces the column height to best fit the cell contents. This provides a dependable mechanism to ensure no text is being truncated and that wasted space is minimized.
To snap column width to best fit cell contents:
Figure 8.7: Column Width Dialog Box
You may change the column width dynamically, by dragging the right column border to the desired width.
When the column width of a cell is too narrow such that it cannot display a numeric value completely, NExS alerts you to this condition by showing a bold cell border in the truncated cell. If truncation occurs to the left, the left cell border is highlighted. If the truncation occurs to the right, the right cell border is highlighted. (Cell justification determines whether the truncation occurs on the left or the right.)