Ad - leaderboard

Wednesday, April 07, 2010

THE Shortcuts for Excel


ActionShortcut
Insert a new line within a cell[Alt] [Enter]
Enable editing within a cell[F2]
Add a comment to a cell[Shift] [F2]
Open Print Preview[Ctrl] [F2]
Fill selected cells with an entry you typed in one cell[Ctrl] [Enter]
Fill data down or to the right through selected cells[Ctrl] D or [Ctrl ] R
Create a name[Ctrl [F3]
Insert the current date or timeCtrl] and ; (semicolon) or Ctrl and : (colon)
Create a chart from a range of data[F11]
Toggle the display of formulas[Ctrl] ~
Source: TechRepublic.com