Getting started in Quattro Pro
To repeat column titles on each spreadsheet of a printed
1 Click File ` Page setup.
2 Click the Options tab.
3 Type the location of the column title in the Top heading box.
You can also repeat row titles by typing the location of the row
title in the Left heading box.
Inserting and deleting cells, rows, and
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” in the online Help.
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