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?
Asked
Active
Viewed 4.1k times
2 Answers
12
Alt + O, C, A one after the other.
Mr Alpha
- 6,668
- 2
- 24
- 26
-
2Ctrl + Spacebar first. – snitzr May 27 '11 at 17:56
-
3If you don't have the correct cell selected you can select the whole row with Ctrl + Spacebar as snitzr mentioned. – Mr Alpha May 30 '11 at 15:07
7
Select all by pressing Ctrl+A. Then press Alt+H, O, I.
Jawa
- 3,619
- 13
- 31
- 36
Abhishek Gehlot
- 216
- 3
- 2
-
1This 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 09 '17 at 16:55