FormatNice

Excel Script that I use to Format my data nicely for my day to day use.

I like to keep mine in my PERSONAL.XLSB file and assign the various sections to shortcuts.

For my setup

• Better_Merge_Center = ctrl + shift + K
• COL_Date = ctrl + shift + D
• COL_Number = ctrl + shift + N
• Format_Better = ctrl + shift + M
• Text000 = ctrl + shift + L

How to install

1. Open Excel
2. Click on the VIEW tab and then Unhide
3. Unhide the "PERSONAL.XLSB" database
4. Press "ALT + F11" Key combo to pen up VBA
5. Inside of VBA editor - Insert Module - Give it a name on the middle left side - I'm not sure how to describe this.
6. Paste in the required code
7. Save the VBA and Close
8. Save the PERSONAL.XLSB
9. Exit all excel files to test.

I hope this helps you.