Navigation: CADSiteTools-Reports > Spreadsheet Editor > How to... > Formatting worksheets >

Align, wrap and combine data in cells

 

 

 

 

 

 

1.      Click and hold the left mouse button on a cell and drag trough the range you want to format values.

2.      Select View > Range Explorer from the Spreadsheet Editor menu

3.      Select the Alignment node in the Range Explorer.

4.      Select horizontal and vertical alignment from the corresponding lists.

5.      Select text orientation

6.      Check the 'Wrap text' option if you want the text to be converted into multiple lines and wrapped within the cell

7.      If you want to combine selected cells, check the 'Merge cells' option.

 

Notes:

 

·         You can select alignment options and view the effects in the current selected range.

·         Merged cells function as a single cell on the worksheet, with the row/column reference of the cell in the top-left corner of the range.

·         If you merge cells only data in the upper leftmost cell will be kept and the rest will be discarded.

·         If you copy merged cells the destination range must be equal to the number of rows and columns in the source range or a multiple of the number of rows and columns in the source range.

 

Fig. 1: Cell text alignment options.

 

 

Fig. 2: Cell text with default general horizontal alignment a vertical top alignment.

 

Fig. 3: Cell text wrapped within the cell.

 

Fig. 4: Cell text centered horizontally across selection and centered vertical alignment.

 

 

 

 

 


Copyright © 2003-2012 CadSite Software

http://www.cadsitetools.com