29
Editing and formatting spreadsheets
155
Editing and formatting
spreadsheets
Quattro Pro lets you edit and format cells, rows or columns, or an
entire spreadsheet. For example, you can check the spelling in a
spreadsheet, copy cells to different parts of a notebook, change the
color of a cell or text within the cell, change the text orientation of a
cell, and resize rows and columns. You can also create and edit
headers, footers, and margins in a spreadsheet.
In this section, you'll learn about
• protecting data
• editing cell content
• resizing rows and columns
• hiding rows and columns
• wrapping text
• joining cells
Protecting data
You can prevent users from changing any data in a spreadsheet by
protecting spreadsheet cells. You can allow users to edit only specific
cells, unlocking specific cells in a protected spreadsheet.
Protecting spreadsheet objects prevents users from moving, resizing,
editing, or deleting objects on the active spreadsheet. Protected
objects include floating charts and graphic objects, linked and
embedded objects using Dynamic Data Exchange or OLE, drawn
objects, and form controls. However, if you disable the sheet protection
for objects, Quattro Pro ignores the status of unprotected objects.
To protect all spreadsheet cells
1 Click Format ` Sheet properties.