Loading...

Microsoft Excel Shortcut keys

Microsoft Excel Shortcut keys   Shortcut Keys Description F2 Edit the selected cell. F5 Go to a specific cell. For example, C6. F7 Spell che...


Microsoft Excel Shortcut keys

 

Shortcut KeysDescription
F2Edit the selected cell.
F5Go to a specific cell. For example, C6.
F7Spell check selected text and/or document.

F11Create chart.
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 selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 5Strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize currently selected window.
Ctrl + F6Switch between open workbooks / windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove 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 keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.
MS-Excel Tips 2958280685315134389

Post a Comment

Home item

Recent

Popular Posts

Archives

ADS

Labels

Random Posts