Microsoft Excel Shortcuts Keys

Microsoft Excel Shortcuts Keys

Below is a Listing of all the major shortcut keys usable in Microsoft Excel.See the computer shortcut page if user are looking for shortcut keys used in other programs.

SHORTCUTSDESCRIPTION
F2Edit the selected cell.
F3Aftera name has been created,F3 wil paste names.
F4Repeat last action.For example,C6.
F5Go to specific cell.For example ,C6
F7Spell check selected data.
F11Create chart from selected data.
Ctrl+Shift+:Enter the current time.
Ctrl+:Enter the current date
Alt+EnterWhile typing text in a cell,pressing Alt+Enter will move to the next line,allowing for multiple lines of text in one cell.
Shift+F3Open the Excel formulla window.
Shift+F5Bring up search box.
Ctrl+1Open the Format Cells
Ctrl+ASelected all contents of the worksheet
Ctrl+BBold highlighted selectection.
Ctrl+IItalic Highlighted selection
Ctrl+K Insert link
Ctrl+SSave the open worksheet .
Ctrl+UUnderline highlighted selection .
Ctrl+PBring up the print dsialog box to begin the printing the printing process.
Ctrl+ZUndo last action.
Ctrl+F3Open Excel Name Manager.
Ctrl+F9Minimize current window.
Ctrl+F10Maximize current window.
Ctrl+Page up Move between work sheets in the same document.
Ctrl+Page downMove between work sheets in the same document.
Ctrl+TabMove between Two or more open Excel files.
Alt+=Create a formula to sum all of the above cells.
Ctrl'Insert thae value of the above cell into the cell currently selected.
Ctrl+Arrow keyMove to next section of text.
Ctrl+SpaceSelect Entire coloumn
Ctrl+SpaceSelect entire row.
Ctrl+-Delete the selected column or row.
Ctrl+Shift+=Insert a new column or row.
Ctrl+HomeMove to cell A1

 

Get more important gk topic
in your mailbox

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Leave a Reply