Autofit Column Width

Resolved · High Priority · Version 2016

Tue 4 Apr 2017, 12:07 Delegate Lauren said...

Lauren has attended:
Excel Advanced course

Autofit Column Width

Hi

What is the shortcut to autofit the column width?

Many thanks

Wed 5 Apr 2017, 09:12 Trainer Sarah said...

RE: Autofit Column Width

Hi Lauren,

If you hover your cursor between two column headers you will see it change to a double headed black arrow. If you double click there, the column will jump to best fit around whatever data you have in the column.

Kind Regards,

Sarah Reid
Excel Trainer

Wed 12 Apr 2017: Automatically marked as resolved.

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Autofit Column Width

Autofit Column Width

RE: Autofit Column Width

Excel articles

Excel tip:

Screen Splitters in Excel