Sick of merging a cell, aligning it to top, left, and then turning on word wrap in Excel (2003)? Me too, let's make a macro for it.
- Fire up Excel
- Tools > Macro > Record New Macro
- Title it: MergeWrap, Store in: Personal Macro Workbook, Hit OKey Dokey (a little macro box will pop up that is now recording whatever you do!)
- Highlight a few a block of cells (a 2x2 block will do)
- Right click > Format Cells...
- Alignment Tab
- Horizontal: Left (indent), Vertical: Top, then check the boxes for Wrap Text and Merge Cells
- Hit Okey Dokey
- The little macro window that is in the center of your screen has a stop button (square...) press it.
- Right click on your toolbar (the thing at the top with all the buttons ,P) and go to Customize...
- Make sure you are in the Commands tab then scroll down to Macros in the Categories pane (left side).
- Drag and drop "Custom menu item" onto the toolbar, where you would like our merge-wordwrap icon to go
- Do Not OK Out of the window yet!
- Right click on your newly created icon, at the bottom you will see "Assign Macro..." click it
- Select MergeWrap and hit OK
- Right click on our icon and click on edit button image. Now you get to draw in an image you like, I went with one long line across the top and a small downward arrow and a few short lines at the bottom. Note: I only used black, the rest is automatically transparent. Hit ok when you are done.
- Right click on our icon, Change the name to "Merge Wrap"
- Right click on our icon, click on Text Only (in Menus)
- Celbrate good times, come on!
No comments:
Post a Comment