11 Very useful Excel keyboard shortcuts you may not know

These shortcuts will save you many trips the excels menu

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