Many of us know how to use this software. Yes, so far I have been talking about MS Excel shortcut key. Many of us may know how to use it but it is very important to know some techniques and shortcuts to speed up our work and time. Let’s speed up you

MS Excel Shortcut:

  1. Go to Next / Previous Worksheet> Ctrl + PgDn, Ctrl + PgUp
  2. Go to Next / Previous Workbook> Ctrl + tab, Ctrl + shift + tab
  3. Ribbon Expansion / Compression> Ctrl + F1
  4. Use autofilter> Ctrl + shift + L
  5. Select multiple columns or rows> Shift + Ctrl + Arrow key (left, right, up, down)
  6. Place the cursor or cell point in the first and last cell of the worksheet> Ctrl + Home, Ctrl + End
  7. Move the cursor inside the data range> Ctrl + Arrow key (left, right, up, down)
  8. Finding and Replacing> Ctrl + F, Ctrl + H
  9. Select column and row> Ctrl + Spacebar, Shift + Spacebar
  10. View Active Cells in Worksheet> Ctrl + Backspace
  11. Go to Display Box> Ctrl + G
  12. Create a new line in the same cell> Alt + Enter
  13. Input the same value in multiple cells> Ctrl + Enter
  14. Add time and date to worksheet> Ctrl + for time; Ctrl + Shift + for the date:
  15. Use Bold / Italic / Underline> Ctrl + B, Ctrl + I, Ctrl + U
  16. Edit in any format> Ctrl + 1
  17. Automatically drop the selected cell> Alt + =
  18. Show and hide the formula in the cell> Ctrl +
  19. Automatically attach Excel function> Tab
  20. Attaching Function Arguments> Ctrl + Shift + A
  21. Insert one or more columns / rows> Ctrl + Shift + +
  22. Delete one or more columns / rows> Ctrl + –
  23. Show and hide one or more columns> Ctrl + Shift + 0
  24. Show and hide one or more rows> Ctrl + 9 (hidden), Ctrl + Shift + 9 (show)
  25. Adding a Chart to the Current Sheet> Alt + F1

You may also like to Learn about MS office formula

Useful Tags :