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