Excel tools to demonstrate

Basic Spreadsheet Tasks

This section illustrates a number of ways to make you more efficient: how to select ranges, how to copy and paste, how to deal with absolute and relative addresses, how to insert and delete rows or columns, and a few others. Most Excel users know how to do these things, but they often do them inefficiently. So even though this material might seem elementary, read on—you might just pick up a few tricks you weren’t aware of.

Moving to the Top of the Sheet

Often you want to reorient yourself by going back to the “home” position on the worksheet.

To go to the top left of the sheet (cell A1):

Press Ctrl-Home (both keys at once).

Try it!