Turn on or off text wrapping for a column in Datasheet view

If text wrapping is on for a column, the cell contents in the column will be displayed in more than one line. If text wrapping is off, each cell will display only what will fit in a single line. By default, text wrapping is on for all columns.

Text wrapping applies to the following data types: single line of text, multiple lines of text, choice, multi-choice, and lookup.

• Right-click the column header for which you want to change the setting, and click Turn Wrap Text Off or Turn Wrap Text On.