Microsoft Office Tutorials and References
In Depth Information
Entering the Data in Datasheet View
Another way to handle the problem of not being able to identify where data
is supposed to be entered is to hide columns in the datasheet. To perform
this trick, select the columns you want to hide by dragging the pointer
across their names; then right-click the column heading and choose Hide
Fields on the shortcut menu. To see the columns again, right-click any
column heading and choose Unhide Fields on the shortcut menu. You see
the Unhide Columns dialog box. Select the fields that you want to see on the
The fastest way to hide a column is to drag the border between it and the
next column to the left until the column disappears.
Changing the appearance of the datasheet
To make the datasheet a little less cluttered and unwieldy, try experimenting
with its appearance. Access offers a few handy shortcuts for doing just that:
✦ Rearranging columns: To move a column to a different location, click its
name at the top of the datasheet and drag it to the left or right.
✦ Resizing columns: Move the pointer between column names at the
top of the datasheet, and when you see the double-headed arrow, click
and start dragging. To make a column just large enough to fit its widest
entry, move the pointer between column names and double-click when
you see the double-headed arrow.
✦ Changing fonts: The default font for a datasheet is Calibri 11-point, but
the Home tab offers commands for changing fonts and font sizes. Look
for these commands in the Text Formatting group.
✦ Changing the look of gridlines: On the Home tab, open the drop-down
list on the Gridlines button and choose options to change the number
and thickness of gridlines.
✦ Alternate row colors: Open the drop-down list on the Alternate Row
Color button and choose a color for alternating rows on the datasheet.
To experiment all at one time with the many options for changing a
datasheet’s appearance, go to the Home tab and click the Text Formatting group
button. You see the Datasheet Formatting dialog box, as shown in Figure 3-2.
If you want a customized look for all the datasheets you work on, visit the
File tab and select Options. Then go to the Datasheet category in the Options
dialog box and go to town.