Which Excel feature is used to automatically adjust the width of a column to fit its contents?
Correct answer: Auto Fit. AutoFit Column Width adjusts the column to fit the longest entry.
Background: You can also double-click the right edge of a column header to AutoFit.
- Auto Sum: AutoSum adds up numbers.
- Auto Format: AutoFormat applies a preset format to cells.
- Auto correct: AutoCorrect fixes spelling mistakes.
Did you know? AutoFit Row Height does the same for rows.
Memory trick: AutoFit = fits the content.