MS EXCEL Shortcuts:-

MS EXCEL Shortcuts:-

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                     = Strike-through 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 / 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.

MS EXCEL Shortcuts:-
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 / 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.

Note: For Sharing Our any Tricks or Post Contact us Directly via Comments Feel Free To Contact with us Thanks for Visiting