User Tools

Site Tools


blog:11_very_useful_excel_keyboard_shortcuts_you_may_not_know

11 Very useful Excel keyboard shortcuts you may not know

These shortcuts will save you many trips the excels menu

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

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

~~LINKBACK~~ ~~DISCUSSION~~

blog/11_very_useful_excel_keyboard_shortcuts_you_may_not_know.txt · Last modified: 2009/06/14 08:58 by brb