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

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

{{tag>excel}}

~~LINKBACK~~
~~DISCUSSION~~