Microsoft Office Tutorials and References
In Depth Information
Deleting data in a datasheet
If you have lots of records that you want to delete from a list, using a
datasheet is definitely the way to go. Here’s the drill:
A single record: Select a row by clicking the gray box to the left of the
record, and then press your Delete key.
A contiguous list of records: Select several rows by clicking the gray
box to the left of the first record, holding down the Shift key while
clicking the gray box to the left of the last record in the series, and then press
your Delete key.
Don’t forget that combining features can make your editing double-fast. For
example, if you are no longer doing business in Boston and want to delete all
your Boston contacts, you can filter the list to Boston by clicking the City
header drop-down and choosing Boston. When your Boston contacts appear,
select the first row, and then hold down your Shift key while selecting the last
row. Press the Delete key and say Bye-bye Bean Town.