Excel Shortcut Keys : A look

• [Ctrl][Shift]A: Use this combination after typing a function name, and it will automatically enter the parentheses and the argument names for the function you typed.
• [Alt][F8]: Displays the Macro dialog box.
• [Alt][F11]: Opens the VBA Editor or switches to it if it's already open.
• [Ctrl]1: Displays the Format Cells dialog box.
• [Ctrl][Shift][~]: Applies the General format.
• [Ctrl][Shift][$]: Formats the current cells as Currency.
• [Ctrl][Shift][#]: Applies the Date format.
• [Shift][F10]: Displays the shortcut menu that applies to the selection.
• [F6]: Moves to the next pane in a split worksheet.
• [Shift][F6]: Moves to the previous pane.
• [Ctrl][F6]: Moves to the next workbook window.
• [Ctrl][Shift][F6]: Moves back to the last workbook window.
• [F3]: Opens a dialog box to paste a Named Range into a formula.
• [Ctrl][F3]: Opens the Define Name dialog box.
• [Ctrl][Shift][F3]: Automatically creates Named Ranges from the headers for the selected table of data with row or column headers.
• [Shift][F3]: Inserts an equal sign (=) and opens the Paste Function dialog box to help you pick a formula.
• [Alt][=]: Inserts the AutoSum function.
• [Ctrl][;]: Inserts the current date.


Comments

Author: Gaurav Aroraa02 Feb 2009 Member Level: Gold   Points : 0

Hi,

Good one.

Keep posting.

Author: Kusum10 Feb 2009 Member Level: Bronze   Points : 0

hi

Realy good aproach

Thx a lot

Author: Kusum10 Feb 2009 Member Level: Bronze   Points : 0

hi

Realy good aproach

Thx a lot



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: