Categories
How To Microsoft Excel Tips & Tricks

Excel: Automatically set width and height

If I’ve been there once, I’ve been there a thousand times; I’ve got a spreadsheet in excel with varying widths and heights that don’t fit the data. Now, sure, you could go in and correct it manually – but that’s not only boring, it’s a pain it the behind. Luckily, there are keyboard shortcuts to accomplish it. Here’s how:

  • To automatically set the width, use the keyboard shortcut Alt+H, followed by O, followed by I
  • To automatically set the height, use the keyboard shortcut Alt+H, followed by O, followed by A

Those should see you sorted in short order.

By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.