Microsoft Office Tutorials and References
In Depth Information
Formatting a Datasheet
Click the Datasheet Formatting button to display the Datasheet Formatting
dialog box, make any changes (changes are previewed in the Sample box),
and click OK. You have the option of making the datasheet work from right
to left instead of the usual left to right — not an option that you’ll use often,
but if you need it, you can find it here.
Rearranging columns in a datasheet
You can rearrange the order of fields in the datasheet in either Datasheet or
Design view. Follow these steps to move columns in Datasheet view:
1. Select the column you want to move by clicking the field name.
You may want to select a block of columns by clicking, holding, and then
moving the mouse pointer to the last column you want to select or by
selecting the first column and then Shift+clicking the last field name in
2. Release the mouse button, click any selected field name, and drag the
column(s) to its new position.
As you move the mouse, a dark vertical line shows where the columns
will be when you release the mouse button.
If you can’t move a column, it’s probably frozen. To unfreeze it, right-click a
field name in that column and choose Unfreeze All Fields from the contextual
menu. For more information, see the aptly named section “Freezing columns,”
later in this chapter.
Changing column width
When you initially create a datasheet, all the columns have the same width.
Column widths are easy to change, however, and when you save the table,
the new column widths are saved too.
To change the width of a column, move the pointer to the bar separating the
field names at the top of the column. The mouse pointer changes to a
doubleheaded arrow (shown in the margin). Drag the bar to the appropriate width,
or double-click to size the column for the widest data in the column.
You can change the width of several adjacent columns at the same time. Start
by selecting them: Click the field name of the first column and drag to the
last field name, or click the first field name and then Shift+click the last. Then
change the width of one of the selected columns. All the selected columns
have the same (new) width.
If you prefer, use the Field Width dialog box to change column width.
Rightclick a field name and choose the Field Width option from the contextual
menu to open the dialog box; then enter the width in number of characters.