Underneath is a listing of all the foremost shortcut keys in Microsoft Excel. See the computer shortcut page if you are looking for other shortcut keys utilised in other programs.
Shortcut
|
Description
|
F2
|
Edit the selected cell.
|
F3
|
After a name has been created F3 will paste names.
|
F4
|
Repeat last action. For example, if you changed the color of text in
another cell pressing F4 will change the text in cell to the same color.
|
F5
|
Go to a specific cell. For example, C6.
|
F7
|
Spell check selected text or document.
|
F11
|
Create chart from selected data.
|
Ctrl + Shift + ;
|
Enter the current time.
|
Ctrl + ;
|
Enter the current date.
|
Alt + Shift + F1
|
Insert New Worksheet.
|
Alt + Enter
|
While typing text in a cell pressing Alt + Enter will move to the
next line allowing for multiple lines of text in one cell.
|
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 + 1
|
Change the format of selected cells.
|
Ctrl + 5
|
Strikethrough highlighted selection.
|
Ctrl + P
|
Bring up the print dialog box to begin printing.
|
Ctrl + Z
|
Undo last action.
|
Ctrl + F3
|
Open Excel Name Manager.
|
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.
|
Ctrl + -
|
Delete the slected column or row.
|
Ctrl + Shift + =
|
Insert a new column or row.
|
Ctrl + Home
|
Move to cell A1.
|
Ctrl + ~
|
Switch between showing Excel formulas or their values in cells.
|
Hi. I’m Designer of Blog Magic. I’m CEO/Founder of ThemeXpose. I’m Creative Art Director, Web Designer, UI/UX Designer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.
Blogger Comment
Facebook Comment