Beat the Excel with Shortcuts

Auto Adjust Column Width According to Content

As a beginner, if we want to adjust the width of a specific column, we usually drag the column left and right.

But what if we could adjust the column width with just one click so that all the text in that column is visible without excess width? For that, simply select the specific column and double-click the right edge of the column.

If you have multiple adjacent columns to adjust, you can resize them all at once. Just select all the adjacent columns that need adjustment and double-click the right edge of the rightmost selected column.

Congratulations! You have just eliminated the need to drag column edges left and right so that all the text in that column is visible without excess width.
Scroll to Top