Author Topic: Microsoft Excel shortcut keys  (Read 1988 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1827
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Excel shortcut keys
« on: September 04, 2012, 05:00:40 PM »
Shortcut Keys   Description
F2   Edit the selected cell.
F5   Go to a specific cell. For example, C6.
F7   Spell check selected text or document.
F11   Create chart.
Ctrl + Shift + ;   Enter the current time.
Ctrl + ;   Enter the current date.
Alt + Shift + F1   Insert New Worksheet.
Shift + F3   Open the Excel formula window.
Shift + F5   Bring up search box.
Ctrl + A   Select all contents of the worksheet.
Ctrl + B   Bold highlighted selection.
Ctrl + I   Italic highlighted selection.
Ctrl + K   Insert link.
Ctrl + U   Underline highlighted selection.
Ctrl + 5   Strikethrough highlighted selection.
Ctrl + P   Bring up the print dialog box to begin printing.
Ctrl + Z   Undo last action.
Ctrl + F9   Minimize current window.
Ctrl + F10   Maximize currently selected window.
Ctrl + F6   Switch between open workbooks or windows.
Ctrl + Page up   Move between Excel work sheets in the same Excel document.
Ctrl + Page down   Move between Excel work sheets in the same Excel document.
Ctrl + Tab   Move between Two or more open Excel files.
Alt + =   Create a formula to sum all of the above cells
Ctrl + '   Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !   Format number in comma format.
Ctrl + Shift + $   Format number in currency format.
Ctrl + Shift + #   Format number in date format.
Ctrl + Shift + %   Format number in percentage format.
Ctrl + Shift + ^   Format number in scientific format.
Ctrl + Shift + @   Format number in time format.
Ctrl + Arrow key   Move to next section of text.
Ctrl + Space   Select entire column.
Shift + Space   Select entire row.
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection