Fit column width to text shortcut?

Question

I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?

Jawa · Accepted Answer · 2015-02-19 07:30:09Z

7

Select all by pressing Ctrl+A. Then press Alt+H, O, I.

Jawa

3,61913 gold badges32 silver badges36 bronze badges

answered Feb 19, 2015 at 6:32

Abhishek Gehlot

2163 silver badges2 bronze badges

1

This answer is the better one now because it doesn't come with a warning that your shortcut is old, and it shows you where the new menu items actually are.
– Noumenon
May 9, 2017 at 16:55

Add a comment |

Mr Alpha · Accepted Answer · 2011-05-26 21:13:41Z

12

Alt + O, C, A one after the other.

answered May 26, 2011 at 21:13

Mr Alpha

6,6782 gold badges24 silver badges26 bronze badges

2

Ctrl + Spacebar first.
– snitzr
May 27, 2011 at 17:56
3

If you don't have the correct cell selected you can select the whole row with Ctrl + Spacebar as snitzr mentioned.
– Mr Alpha
May 30, 2011 at 15:07

Add a comment |

2 Answers 2