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.