Corel wordperfect office 2002 ユーザーズマニュアル
Editing and
formatting a spreadsheet
4
Quattro Pro lets you edit and format cells, rows or columns, or an entire spreadsheet. For
example, you can 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
In this section, you’ll learn about
protecting data
editing cell content
undoing actions
editing grouped data
moving selected cells by dragging
moving cells, rows, and columns
resizing rows and columns
resizing rows and columns to fit a specific cell
hiding rows and columns
using formatting tools to format a spreadsheet
wrapping text
joining cells
changing text font and appearance
working with fills, patterns, and borders
aligning data
working with numeric formats
working with page breaks
creating headers and footers
customizing margins
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
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.
Editing and formatting a spreadsheet
191