Below is a listing of all the major shortcut keys in Microsoft Excel. See the computer shortcut page if you are looking for other shortcut keys used in other programs.
ShortcutDescription
- ShortcutDescriptionF2Edit the selected cell.F5Go to a specific cell. For example, C6.F7Spell check selected text 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 or 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 cellsCtrl + '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.
0 comments:
Post a Comment
Thank You ! For Your Comment.