User Guide

When you insert a row within the boundaries of a named area or a cell referenced by
a formula, the cell references expand to include the new row.
You can insert multiple rows by selecting multiple row headings, then clicking Insert
} Insert row.
To insert a column
1 Select the column heading to the right of where you want the column inserted.
2 Click Insert } Insert column.
When you insert a column within the boundaries of a named area or a cell referenced
by a formula, the cell references expand to include the new column.
You can insert multiple columns by selecting multiple columns headings, then
clicking Insert } Insert column.
To delete a cell
1 Select the cell you want to delete.
2 Click Edit } Delete cells.
3 Enable the Partial option in the Span area.
4 Enable one of the following options in the Dimension area:
 Rows — the cell below the selected cell will shift up

Columns — the cell to the right of the selected cell will shift to the left

Sheets — the corresponding cell on the next spreadsheet will shift to the current
spreadsheet
You can also delete multiple cells by first selecting a block of cells.
To delete a row or a column
1 Select the row or column heading.
2 Click Edit } Delete cells.
You can delete multiple rows or columns by selecting multiple headings, then
clicking Edit } Delete cells.
To restrict the addition of rows and columns
1 Press END, and press the DOWN ARROW.
2 Press END, and press the RIGHT ARROW.
The cursor is at the last cell in the spreadsheet.
3 Type any label or value.
4 Press HOME to get back to the first cell in the spreadsheet.
When you try to add a row or column, an out of boundary message displays.
168 Quattro Pro 10