Microsoft Office Tutorials and References
In Depth Information
6. Celebrate when you’re finished entering data.
Okay, I know that sounds like a strange instruction, but the one thing
that’s missing from the datasheet is an OK or Save button. Just move
on to another spot in Office Live or go back to your list — your changes
I can think of few chores that are more boring than contact entry. Although
Office Live doesn’t allow for the ability to import data, you can copy the
information from a spreadsheet and paste existing information into a
datasheet. If the order of your datasheet column headings match those of the
spreadsheet, just place your cursor in the first empty row and paste away. If
your columns don’t match, you can still paste in your information one
column at a time.
You might find your information easier to edit in a datasheet than in a record
form. You can add, delete, edit, sort, and filter list items while working in a
datasheet. You’ll probably also find it easier to scroll through your
information; the inaccuracies and missing data jump right out at you.
To edit data using the datasheet, follow these steps:
1. Click Business Contact Manager from the Navigation bar on the Office
Live Home page.
The Business Contact Manager dashboard opens.
2. Click the tab that contains the list you want to enter data for.
3. Select the view you want to work with.
4. Choose Edit in Datasheet from the Actions drop-down menu.
The datasheet opens.
5. Edit the cell you want to change.
You can even select a range of cells and hit your Delete key to clear the
contents of several continuous cells.
6. (Optional) If others are making changes as well, choose Refresh Data
from the Actions drop-down menu to ensure that you’re viewing the
most current copy of the data.
Talk about things changing in front of your eyes! Often there’s no sense
changing data if someone else has already beaten you to the punch.