This is an old revision of the document!

11 very useful excel keyboard shortcuts you may not know

F4 - During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
ctrl key+; - Inserts current date
ctrl key+ - Copies value from cell above to current cell
shift+F2 - Edits a cell comment
alt+F8 - Opens macro dialog box
alt+= - Auto sum selected cells and places value in cell beneath
ctrl+shift+$ - Currency formats current cell
ctrl+shift+& - Applies outline border to selected cells
ctrl+shift+! - Comma formats current cell
shift+ctrl+f - Activates font drop down list
shift+ctrl+p - Activates font point size drop down list

~~LINKBACK~~

Discussion

Real name:

E-Mail:

Enter your comment. Wiki syntax is allowed:

Please fill all the letters into the box to prove you're human.

   __   ____    ___    ___    ____
  / /  / __ \  / _ \  / _ \  /  _/
 / /__/ /_/ / / , _/ / // / _/ /  
/____/\___\_\/_/|_| /____/ /___/

Please keep this field empty:

Subscribe to comments