Spreadsheet 143
"
To select a range that includes all cells with entries:
Press
CODE + SHIFT + / (slash)
.
Click the Smart Select button in the upper-left corner of the
spreadsheet.
Spreadsheet selects a range that includes all cells that have entries (and all
the empty cells in between).
"
To select every cell in the spreadsheet:
Choose Select All fromthe Edit menu or press
CODE + / (slash).
"
To select a cell using the keyboard:
Use any of the following keystrokes to move the highlighting to the
cell you want to select:
S
Arrow keys.
Selects the next cell in the direction of the arrow.
S
HOME.
Selects the first cell in the current row.
S
CODE + HOME.
Selects the first cell in the spreadsheet (A1).
S
END.
Selects the last filled cell in the current row.
S
CODE + END.
Selects the last filled cell in the spreadsheet's active
area.
S
CODE + RIGHT ARROW.
Selects the last filled cell to the right in
the current row, or the first filled cell to the right, or if no more
filled cells to the right, the last unfilled cell in the row.
S
CODE + LEFT ARROW.
Selects the last filled cell to the left in the
current row, or the first filled cell to the left, or if no more filled
cells to the left, the first unfilled cell in the row.
S
CODE + UP ARROW.
Selects the last filled cell above the active cell
in the current column, or the first filled cell to the right, or if there
are no more filled cells above the active cell, the first unfilled cell
in the column.
S
CODE + DOWN ARROW.
Selects the last filled cell below the active
cell in the current column, or the first filled cell to the right, or if
no filled cells appear below the active cell, the last unfilled cell in
the column.
"
To select a range of cells using the keyboard:
Hold down the
SHIFT
key while using one of the keystrokes shown in
the table above. This selects the range fromthe active cell to the
destination for the keystroke you use. For example, if C23 is the active
cell, you can press
SHIFT + CODE + HOME
to select the entire range
A1:C23.
Smart Select button
The Select All function selects all
the cells that are not locked.
If you want to perform some
action that would affect every
cell, such as changing the font for
all current and future entries, you
can select all cells in the
spreadsheet.
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: ......