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?

2 Answers 2


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

  • 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

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

  • 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .