Spreadsheet 156
Editing the Contents of a Cell
Typically, you will need to modify entries you make in a spreadsheet,
whether to correct an error you have made or to update the spreadsheet
to reflect new information. If it is a simple change, you can select the cell
to make it active and then type the new entry. If you want to make a
change in a complex entry, you may want to work in the Edit Bar.
"
To edit the contents of a cell:
1. Select the cell you want to change.
2. In the Edit Area, select the information you want to change, or click
where you want to insert new information.
3. Make the corrections you want.
4. To confirm your changes, click on Enter or press
ENTER
.
OR
To cancel the changes, click the Restore button (see page 140) or
press
ESC
.
"
To delete the contents of cells:
1. Select the cell or range of cells whose contents you want to delete.
2. Press
DELETE
.
Thecontents of the cell or range are permanentlydeleted.
OR
Choose
Delete
from the Edit menu.
The contents of the cell or range
are permanentlydeleted.
OR
Choose Cut from the Edit menu or press
CUT
.
The contents of the
cell or range aretransferred to the clipboard; you can use the Paste
choice on the Edit menu to copy the cell or range to another location.
Copying and Moving Information
As you work with Spreadsheet, you may find it convenient to copy and
move information. There are two ways to copy and move information in
Spreadsheet:
S
You can use the Fill choices on the Cell menu to copy the contents of
the active cell across a row or down a column.
S
You can use the Cut, Copy, and Paste choices on the Edit menu to
copy or move information to any other location in a spreadsheet. Or,
you can click the tools on the Advanced Functions tool bar, if
displayed.
S
You can use the
CUT
,
COPY
, and
PASTE
keys to copy or move
information to any other location in a spreadsheet.
You can also press
CODE+SPACEBAR to begin
editing the selected cell.
Occasionally, you may want to
delete the contents of one or
more cells. You can delete
information permanently
, or you
can transfer it to the clipboard so
you can then move it to another
location.
If you accidentally delete the wrong
information using the
DELETE key
or the Delete choice on the Edit
menu, you cannot restore the
deleted information. Y
ou may want to
delete information using the Cut
choice on the Edit menu; that way
, if
you accidentally delete the wrong
information, you can paste it back in
place.
Summary of Contents for Ensemble PDP-100J
Page 11: ......
Page 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Page 72: ......
Page 83: ......
Page 152: ......
Page 217: ...Spreadsheet 203 The following dialog box appears ...
Page 219: ......
Page 262: ......
Page 269: ......
Page 284: ......
Page 301: ......
Page 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Page 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Page 312: ......
Page 325: ......
Page 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Page 330: ......
Page 333: ......
Page 337: ...Text File Editor 314 ...
Page 338: ......
Page 345: ......
Page 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Page 350: ......
Page 379: ......
Page 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Page 396: ...Appendix 369 Print Functions Function Description Example ...
Page 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Page 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Page 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Page 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Page 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Page 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Page 414: ......
Page 418: ...Glossary 390 ...
Page 420: ...Glossary 392 0 1 1 1 ...
Page 421: ...Glossary 393 text style sheet ...
Page 422: ...Glossary 394 ...
Page 423: ......
Page 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Page 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Page 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Page 440: ......