filmov
tv
22 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!
Shortcuts:
# 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