Tips (ML/EC/CB/SA/EG/DC)

Because there's more than one spreadsheet package out there, we've done our best to come up with a few generic tips you can use with any software package. We've also rounded up some application-specific tips that will come in handy for Excel and AppleWorks users.

General Spreadsheet Tips

Use arrow keys to change the active cell, but use the scroll bar to change the view of the spreadsheet.

Although you can use the scroll bars to change your view of a spreadsheet, using the scroll bars does not change the active cell.

Pay attention to the mouse pointer.

Spreadsheets change the mouse pointer to provide visual clues about things you can do.

  • The mouse pointer appears as a white cross (or fat plus sign) when it's in the spreadsheet ...

Get Macintosh Bible, 8th Edition, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.