Resizing Rows, Columns And Cells
The Data View is very flexible, and can be resized to suit your needs. The Data View features resizable rows, series columns, and label cells. Resizing operations are done with the mouse, which changes to the appropriate cursor when positioned over a resize "handle". Resize handles are not visible in the normal sense of graphic handles or selection knobs. Instead, resize handles are defined by dividing lines in the Data View.
The resizing descriptions found below can be used as a reference to clarify resizing behavior. Remember that the cursor will change to one of the resize cursors only when the Data View Window is the key window.
Resizing Rows and Series Columns
Resizing Rows
To change the height of a row or a set of rows, use the resizing handles which are the horizontal lines between row labels .
Resizing Series Columns
To change the width of a series column or a set of series columns, use one of the resizing handles which are the vertical lines between the series column headers.
When resizing rows or series columns, you may select a set of rows or a set of series columns and resize all of them by dragging one of the resize handles in the selection set. Doing this distributes the total amount of expansion or contraction equally over all of the selected rows or series columns.
Resizing Rows or Series Columns to be the Same Size
The resizing behavior can be modified so that resizing a group of rows or series columns forces all of the rows or columns to be the same size. To do this, press down the alternate key before resizing a set of rows or columns, and then resize the set as described above. A different set of cursors appear during equivalent resizing.
Resizing the Whole Data View
You may also resize all of the rows, or all of the series columns regardless of the current selection, by using the Data View resize handles. The Data View handles are the lines at the far right and the bottom of the Data View, and are only as long as the data cell area . Resizing from the Data View handles distributes the total amount of expansion or contraction equally over all of the rows or series columns in the Data View. This action also resets the default row and column sizes for any added rows or series columns.
Resizing Row and Series Column Labels
The label resizing handles are limited to the vertical line between the upper left corner block and the series column headers, and between the upper left corner block and the row label column. Dragging the vertical line will resize the width of the row labels. Dragging the horizontal line will resize the height of the series column labels.
Size To Fit
The components of the Data VIew can each be separately sized to fit their contents. Simply make a selection, then from the Data View submenu, click Size_To_Fit. This menu item is only enabled when the selection can be sized to fit. If series columns are selected, then the width of the selected series columns is resized. If rows are selected, then the height of the selected rows is resized. If row labels are selected, then the width of the row labels is resized. If series column labels are selected, then the height of the series column labels is resized. And finally, if all data cells are selected, then all row heights and column widths are resized.