VBA Shortcuts Download
How to use
Demo
Original Post
Re: [請益] 事務所工作準備(Excel快捷鍵整理 & VBA快捷鍵)
Custom Shortcuts
The 22 commands below are those I oftenly used when I made working papers, so I made them become my Excel default shortcuts.
I personally recommend the last one command - Switch Between Sheets(Shift + Tab), give it a try, I bet you'll love it!
| # | Key | Description |
|---|---|---|
| 1. | Shift + A | Arial 10 |
| 2. | Shift + Y | Fill Yellow |
| 3. | Shift + G | Fill Green |
| 4. | Shift + N | No Fill |
| 5. | Shift + R | Align Right |
| 6. | Shift + E | Align Center |
| 7. | Shift + W | Align Left |
| 8. | Shift + Q | Arial 10 + Red + Bold |
| 9. | Shift + B | Top and Double Bottom Border |
| 10. | Shift + V | All Borders |
| 11. | Shift + D | No Border |
| 12. | Shift + T | Comma Style With No Decimals |
| 13. | Shift + S | Format Painter |
| 14. | Shift + X | Conclusion: |
| 15. | Shift + Z | Note: |
| 16. | Ctrl + Q | New Sheet |
| 17. | Ctrl + 2 | Insert Row |
| 18. | Ctrl + 3 | Insert Column |
| 19. | Ctrl + 4 | Insert Narrow Column |
| 20. | Shift + Plus(+) | Increase Decimal |
| 21. | Shift + Minus(-) | Decrease Decimal |
| 22. | Shift + TAB | Switch between Last Used Sheet and Current Sheet |