Editing cell content
Quattro Pro lets you overwrite, replace, or edit cell content. Cell entries can be changed in various ways. You can replace the entire content and formatting of a cell, or you can modify only the content or the formatting. You can also clear the values in a range of cells without clearing the formulas.
Quattro Pro lets you quickly find a cell and automatically replace the data it contains. You can look for data in cell formulas or cell values. You can also set conditions for the search criteria. For example, in an expenses spreadsheet, you can look only for expenses greater than $300.
To overwrite data |
1.
|
|
Click a cell.
|
2.
|
|
Press Insert.
|
The Typeover button on the application bar appears pressed when the typeover mode is on.
|
•
|
|
You can return to inserting data by pressing Insert.
|
To replace the entire contents of a cell |
1.
|
|
Click a cell.
|
2.
|
|
Type a new entry.
|
3.
|
|
Press Enter.
|
To edit cell contents |
1.
|
|
Double-click a cell.
|
2.
|
|
Click where you want to edit.
|
3.
|
|
Edit the cell content.
|
4.
|
|
Press Enter.
|
•
|
|
You can move the insertion point within a cell by using the arrow keys.
|
To edit the contents and formatting properties of a cell |
1.
|
|
Click a cell.
|
2.
|
|
Click Edit Clear, and click one of the following:
|
•
|
Cells — lets you erase the content and the formatting of a cell
|
•
|
Values — lets you erase the content but not the formatting of a cell
|
•
|
Format — lets you erase the formatting but not the content of a cell
|
•
|
|
Clicking Edit Clear Format does not affect column width or row height.
|
•
|
|
Unnecessary cell formatting can add significantly to the size of a notebook file; clearing cell formatting reduces the size of the file.
|
•
|
|
You can also erase the content of a cell but not the formatting by selecting the cell, and clicking Delete.
|
To clear values in a range of cells without clearing formulas |
1.
|
|
Select a range of cells.
|
2.
|
|
Click Edit Cut.
|
3.
|
|
Click Edit Paste special.
|
4.
|
|
Disable the Number cells check box.
|
5.
|
|
Click Paste.
|
To find and replace data |
1.
|
|
Click Edit Find and replace.
|
2.
|
|
Type the text or value to find in the Find box.
|
3.
|
|
Type the replacement text or value in the Replace box.
|
4.
|
|
Type the cells to search in the Cell(s) box.
|
5.
|
|
In the Look in area, enable one of the following options:
|
•
|
Formula — finds data in a formula
|
•
|
Value — finds data in a value
|
•
|
Condition — compares cells in the spreadsheet with any conditions specified in the Find box
|
6.
|
|
Click one of the following buttons:
|
•
|
Find next
|
•
|
Previous
|
7.
|
|
Click Replace.
|
•
|
|
Quattro Pro makes replacements from the cursor position to the end of a document, so you must position the cursor at the beginning of a document before you search.
|
•
|
|
You can replace all occurrences of the search item with the replacement text or value by clicking Replace all.
|
•
|
|
When using conditional searches, type a question mark (?) before the search condition (e.g. ? > 300).
|