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/

Discussion

Enter your comment
If you can't read the letters on the image, download this .wav file to get them read to you.
 
blog/11_very_useful_excel_keyboard_shortcuts_you_may_not_know.txt · Last modified: 2009/06/14 08:58 by brb
Back to top
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0