Inserting and deleting cells, rows, and columns
You can insert cells, rows, or columns anywhere in a spreadsheet. When you insert an item, existing data is pushed down, to the right, or to the back of the notebook to make room for the new item.
You can also copy and insert data and cells. When you copy and insert data and cells, Quattro Pro inserts the correct number of cells for the copied data and pastes the data in the spreadsheet. For more information about copying cells, see “Copying and moving cells, rows, and columns.”
When data is no longer useful, you can easily delete cells, rows, columns, or multiple rows and columns.
You can prevent other users from adding rows and columns to a spreadsheet by entering data in the last cell of the spreadsheet. Since this cell can’t be pushed down or to the right, no extra cells can be added to the spreadsheet.
To insert a cell |  |
|
1.
|
|
Select a cell in the location where you want to insert a new cell.
|
|
2.
|
|
Click Insert
 Insert cells. |
|
3.
|
|
Enable the Partial option in the Span area.
|
|
4.
|
|
Enable one of the following options in the Dimension area:
|
|
•
|
Rows — the selected cell will shift down and out of the way
|
|
•
|
Columns — the selected cell will shift to the right
|
|
•
|
Sheets — the selected cell will shift to the next spreadsheet
|
To insert a row | |
|
1.
|
|
Select the row heading just below where you want the row inserted.
|
|
2.
|
|
Click Insert
Insert row. |
|
•
|
|
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 also insert the correct number of cells for a row of data that you copy. For more information, see “To copy and insert data and cells.”
|
|
•
|
|
You can insert multiple rows by selecting multiple row headings, and 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 copy and insert data and cells | |
|
1.
|
|
Select the row, column, or block of cells that contains the data you want to copy.
|
|
2.
|
|
Click Edit
Copy. |
|
3.
|
|
Select the upper left-most cell where you want to insert the copied data and cells.
|
|
4.
|
|
Right-click, and click QuickPaste.
|
|
5.
|
|
In the Dimension area, enable one of the following options:
|
|
•
|
Rows — to shift cells down and out of the way
|
|
•
|
Columns — to shift cells to the right
|
|
6.
|
|
In the Span area, enable one of the following options:
|
|
•
|
Entire — to insert an entire row or column
|
|
•
|
Span — to insert the required cells in a row or 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, and 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.
|