Set defaults for the appearance of datasheets

1. On the Tools menu, click Options.
2. Click the Datasheet tab.
3. Click the options you want.

Note  These options only affect new datasheets. If you want existing datasheets to have the same format also, you must make the changes in the specific datasheets using the Format menu commands or remove the saved properties using Microsoft Visual Basic code.