This is an old revision of the document!

11 very useful excel keyboard shortcuts you may not know

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

Source: http://chandoo.org/wp/2008/07/29/excel-keyboard-shortcuts/

~~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