Excel Hack

Excel column width shortcut

One of the most common formatting options in Excel is to change the width of a column. When you enter long letters or numbers in a single cell, some of them may extend beyond the cell borders. On the other hand, if the cell is too wide, the column width must be reduced to make the data easier to read. The width of the columns can be adjusted using the mouse or shortcuts. Here are some shortcuts to change the column width to improve your work efficiency.

Column width shortcut

Set the value for the column width

Windows
Access Key: Alt + H + O + W or Alt + O + C + W

Mac
None

Copy only the column width to another column

Windows
Ctrl + Alt + V
Access Key: Alt + H + V + S

Mac
None

Set the value for the column width

For information on how to set the column width value using shortcut keys, see the following.

Total Time: 1 minute

Select a cell

Select a cell

Select one of the cells in the column where you want to change the column width.

Select an entire column

Selecting an entire column

Press Ctrl + Space to select the entire column. Press Alt + H + O + W.

Set the column width value

Setting the column width value

The Column Width dialog box will appear. Enter the Column width that you want to change, and press the Enter.
ex) 27

Complete the Column width setting

Completing the column width setting

The column width setting is now complete.

Copy only the column width to another column

Select a cell

Select one cell in the column where you want to copy the column width.

Copying a cell

Press Ctrl + C to copy the selected cells.

Press the shortcut to copy a column

Select the cell in the column where you want to copy the column width.

Press Ctrl + Alt + V or Alt + H + V + S.

Press W and press Enter

Paste Special dialog box will appear.

Press W, and press Enter.

The column width has been copied

Copying only the column widths has been completed.

Articles related to Column & Shortcut & Width