If you want to display or print only certain columns for your datasheet, you can hide the columns that you don't want displayed. For example, if you are working with a database of contact information, you may want to see only the full name and e-mail address for each contact. You can create this view by hiding all other columns.
Hide columns
-
Click the heading for the column that you want to hide.
To select adjacent columns, hold down SHIFT and click additional column headers.
Note: You cannot select nonadjacent columns. Select any additional columns and hide those separately.
-
Right-click the column header, and then click Hide Fields on the shortcut menu.
Show columns
-
Right-click any column header, and then click Unhide Fields on the shortcut menu.
-
In the Unhide Columns dialog box, select the check box next to each column that you want to show, and then click Close.
