Bernhard Brunner's Blog

User Tools

Site Tools

You are here: start » blog » 11_very_useful_excel_keyboard_shortcuts_you_may_not_know
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

Enter your comment. Wiki syntax is allowed: 
   __ __ ______   ____  ____   ____ 
  / // //_  __/  /  _/ / __ \ / __ \
 / _  /  / /    _/ /  / /_/ // /_/ /
/_//_/  /_/    /___/  \___\_\\___\_\
 
blog/11_very_useful_excel_keyboard_shortcuts_you_may_not_know.txt · Last modified: 2009-06-14 08:58 by brb