Shortcuts


SUBMITTED BY: nhnaveed

DATE: Jan. 11, 2017, 10:19 p.m.

FORMAT: Text only

SIZE: 904 Bytes

HITS: 17090

  1. Create new workbook : CtrlN
  2. Open workbook : CtrlO
  3. Save workbook : CtrlS
  4. Save as : F12
  5. Print file : CtrlP
  6. Open print preview window : CtrlF2
  7. Close current workbook : CtrlF4
  8. Close Excel : AltF4
  9. Expand or collapse ribbon : CtrlF1
  10. Alt : Move to next ribbon control
  11. Get help on selected control : F1
  12. Undo last action : CtrlZ
  13. Redo last action :CtrlY
  14. Copy selected cells : CtrlC
  15. Repeat last action : F4
  16. Cut selected cells : CtrlX
  17. Paste content from clipboard : CtrlV
  18. Display the Paste Special dialog box : CtrlAltV
  19. Display find and replace :CtrlF
  20. replace selected :CtrlH
  21. Find previous match : CtrlShiftF4
  22. Find next match : ShiftF4
  23. Create embedded chart : AltF1
  24. Create chart in new worksheet : F11
  25. Toggle Autofilter : CtrlShiftL
  26. Activate filter : Alt↓
  27. Insert table : CtrlT
  28. Select table row : ShiftSpace
  29. Select table column : CtrlSpace
  30. Select table : CtrlA

comments powered by Disqus