Total Hits

Sunday 21 February 2016

MS Excel Shortcut keys

F2Edit the selected cell
F3After a name has been created F3 will paste names
F5Go to a specific cell. For example, C6
F7Spell check selected text or document
F11Create chart from selected data
Ctrl + Shift + ;Enter the current time
Ctrl + ;Enter the current date
Alt + Shift + F1Insert new worksheet
Shift + F3Open the Excel formula window
Shift + F5Bring up search box
Ctrl + ASelect all contents of the worksheet
Ctrl + BBold highlighted section
Ctrl + IItalic highlighted section
Ctrl + KInsert link
Ctrl + UUnderline highlighted section
Ctrl + 1Change the format of selected cells
Ctrl + 5Strike through highlighted section
Ctrl + PBring up the print dialogue box to begin printing
Ctrl + ZUndo last action
Ctrl + F3Open Excel Name Manager
Ctrl + F9Minimize current window
Ctrl + F10Maximize currently selected window
Ctrl + F6Switch between open work books or windows
Ctrl + Page upMove between Excel work sheets in the same Excel document
Ctrl + page downMove between Excel worksheets in the same Excel document
Ctrl + TabMove between two or more open Excel document
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 keyMove to the next selection on text
Ctrl + SpaceSelect entire column
Shift + SpaceSelect entire row
Ctrl + –Delete the selected column or row
Ctrl + shift + =Insert a new column or row
Ctrl + HomeMove to cell A1
Ctrl + ~Switch between showing Excel formulas or their values in cells

No comments:

Post a Comment

Post a Comment