Excel Shortcuts and Tips you should know

I am not very good at using MS Excel, recently when I was working on an Excel sheet, I learnt a couple of keyboard shortcuts with the help of a friend, I though sharing it with you all, I have tried to put together the ones which I thought are not very usual, hope you find them useful.

General Shortcuts to make you more productive with MS Excel –

Operation Shortcut

  • Multiselect Cells      Alt+Left Click
  • Del Row/Col             Ctrl+K
  • Select Range            Ctrl+*
  • Go to Corner            Ctrl+.
  • Edit Selected            Ctrl+Enter
  • Fill Down                    Ctrl+D
  • Fill Right                     Ctrl+R
  • Copy Prev Formula   Ctrl+’
  • Copy Above Val         Ctrl+”
  • Sum                            Alt+=
  • Go to First Cell          Ctrl+Home       Go to Last Cell
  • Ctrl+End        Start of Row    Home
  • Next Sheet                Ctrl+Page Down
  • Next Workbook       Ctrl+F6
  • Prev Workbook        Ctrl+Shift+F6
  • Prev Sheet                 Ctrl+Page Up
  • Go to                            F5
  • Set Currency            Shift+Ctrl+$
  • Set Percent               Shift+Ctrl+%
  • Set Number             Ctrl+Shift+~
  • Set Date                     Ctrl+Shift+#
  • Insert Line Br          Alt+Enter
  • Repeat Action          F4
  • Format Cell                Ctrl+1
  • Insert Date                Ctrl+; Insert Time   Ctrl+:
  • Remove Border       Ctrl+Shift+_  Border Cells    Ctrl+Shift+&
  • Select Cell Group     Shift+Cursors

Some Functions and their Results

  • FUNCTION                                         RESULT
  1. today()                                                      Today’s date
  2. now()                                                          Date and Time
  3. sum()                                                          Total of values
  4. average()                                                   Average of values
  5. min()                                                           Lowest value
  6. max()                                                          Highest value
  7. count()                                                        Number of values
  8. counta()                                                     Count non-blank
  9. countif()                                                     Count matches
  10. if(this,then,else)and() / or()              Return value if condition met
  11. rand()                                                          Random number
  12. round()                                                       Round the value
  13. ceiling()                                                      Round up
  14. floor()                                                          Round down
  15. sqrt()                                                           Square root

Hope you found them useful, if yes, feel free to print it out and keep it on the wall at you workplace.