Excel Macro Toolkit

A collection of VBA macros that streamline common Excel formatting and editing tasks through keyboard shortcuts.

Features

• Alt + Shift + . — Move the decimal point one place to the right
• Alt + Shift + , — Move the decimal point one place to the left
• Ctrl + Alt + A — Automatically apply font colors
• Ctrl + Alt + S — Toggle positive and negative signs
• Ctrl + Alt + 4 — Apply currency formatting
• Ctrl + Alt + 5 — Apply percentage formatting
• Ctrl + Alt + 6 — Apply multiples ("x") formatting
• Ctrl + Alt + 7 — Apply standard number formatting
• Ctrl + Alt + Q — Paste while skipping blank cells
• Ctrl + Alt + [ — Decrease decimal places
• Ctrl + Alt + ] — Increase decimal places
• Ctrl + Alt + 8 — Display zero values as "-" while preserving the existing number format

Installation

1. Open Excel.
2. Press Alt + F11 to open the VBA Editor.
3. Import excel_macro_toolkit.bas into your PERSONAL.XLSB or another workbook.
4. Run the macro that assigns the keyboard shortcuts.
5. Save the workbook.

Files

• excel_macro_toolkit.bas – VBA macro library
• Excel_Macro_Cheat_Sheet.pdf – Keyboard shortcut reference

Requirements

• Microsoft Excel (Windows)
• VBA enabled

License

MIT License