- Start on the View tab, in the Macro group and click the Macro button.
- Select Record Macro Name it something easy, such as “RightFitSheet”.
- Assign it a using your Shift key and a letter, like R for right fit. This way the shortcut will be Ctrl+Shift+R.
- Change the “Store macro in…” field to Personal Macro Workbook. This way you can use it on any workbook. [caption id="attachment_30313" align="alignright" width="315" caption="Record macro dialog box"][/caption]
- When you click OK, you will be recording your keystrokes. It’s always a good idea to take your hands off of keyboard and mouse at this point. You will want to be very intentional about what you do next.
- Select the cornerstone on the worksheet to select all cells (Ctrl+A twice works well, too). Be sure that all cells remain selected during the next two steps.
- Double-click between two column headers. Be sure your cursor is positioned between the two letters and appears as a horizontal double arrow.
- Now, double-click between two row headers. Be sure your cursor is positioned between the two numbers and appears as a vertical double arrow. [caption id="attachment_30314" align="aligncenter" width="224" caption="Right size columns and rows"][/caption]
- Press Ctrl+Home to place your cursor in cell A1. This step is optional, but it’s always good to know where your cursor is going to end up when your macro completes.
Get weekly updates on breaking news and business advice to help you advance your career! The week's top stories and resources will be sent right to your inbox. Choose the topics you're interested in:
We value your Privacy.