Tuesday, October 20, 2009

Excel Time Saving Shortcuts


  1. Move to next cell in row – Tab
  2. Move to previous cell in row - Shift + Tab
  3. Up one screen - Page Up
  4. Down one screen - Page Down
  5. Move to next worksheet - Ctrl + Page Down
  6. Move to previous worksheet - Ctrl + Page Up
  7. Go to first cell in data region - Ctrl + Home
  8. Go to last cell in data region - Ctrl + End
  9. Bold toggle for selection - Ctrl + B
  10. Italic toggle for selection - Ctrl + I
  11. Underline toggle for selection - Ctrl + U
  12. Strikethrough for selection - Ctrl + 5
  13. Change the font - Ctrl + Shift + F
  14. Change the font size - Ctrl + Shift + P
  15. Apply outline borders - Ctrl + Shift + 7
  16. Remove all borders - Ctrl + Shift + Underline
  17. Wrap text in same cell - Alt + Enter
  18. Format cells - Ctrl + 1
  19. Select font - Ctrl + Shift + F
  20. Select point size - Ctrl + Shift + P
  21. Format as currency - Ctrl + Shift + 4
  22. Format as general - Ctrl + Shift + # (hash sign)
  23. Format as percentage - Ctrl + Shift + 5
  24. Format as number - Ctrl + Shift + 1
  25. Autosum a range of cells - Alt + Equals Sign
  26. Insert the date - Ctrl +; (semi-colon)
  27. Insert the time - Ctrl + Shift +; (semi-colon)
  28. Insert columns/rows - Ctrl + Shift + + (plus sign)
  29. Insert a new worksheet - Shift + F11
  30. Read Monitor Cell One - Alt + Shift + 1
  31. Read Monitor Cell Two - Alt + Shift + 2
  32. Read Monitor Cell Three - Alt + Shift + 3
  33. Read Monitor Cell Four - Alt + Shift + 4
  34. List Visible Cells With Data - Ctrl + Shift + D
  35. Lists Data In Current Column - Ctrl + Shift + C
  36. List Data In Current Row - Ctrl + Shift + R
  37. Select Hyperlink - Ctrl + Shift + H
  38. Move To Worksheet Listbox - Ctrl + Shift + S
  39. Move To Monitor Cell - Ctrl + Shift + M
  40. Select Worksheet Objects - Ctrl + Shift + O

0 comments:

Post a Comment

 

Easy Tutorial's | Copyright 2009 Tüm Haklar? Sakl?d?r | Blogger Templates by GoogleBoy