Excel shortcut keys

Excel shortcut keys:



F2 -- Edit the chosen cell.
F5 -- attend a selected cell.
F7 -- Spell check selected text and/or document.
F11 -- Create chart
Ctrl + Shift + ; -- Enter the present time.
Ctrl + ; -- Enter the present date
Alt + Shift + F1 -- Insert new worksheet.
Shift + F3 -- Open the Excel formula window.
Shift + F5 -- mention the search box
Ctrl + A -- Select all contents of a worksheet.
Ctrl + B -- Bold highlighted selection.
Ctrl + I -- Italicize highlighted selection.
Ctrl + C -- Copy selected text.
Ctrl + V -- Paste
Ctrl + D -- Fill
Ctrl + K -- Insert link
Ctrl + F -- Open find and replace options.
Ctrl + G -- Open go-to options.
Ctrl + H -- Open find and replace options.
Ctrl + U -- Underline highlighted selection.
Ctrl + Y -- Underline selected text.
Ctrl + 5 -- Strike through highlighted selection.
Ctrl + O -- Open options.
Ctrl + N -- Open new document.
Ctrl + P -- Open print panel.
Ctrl + S -- Save.
Ctrl + Z -- Undo last action.
Ctrl + F9 -- Minimize current window.
Ctrl + F10 -- Maximize currently selected window.
Ctrl + F6 -- Switch between open workbooks/windows.
Ctrl + Page up & Page Down -- Move between Excel worksheets within the same document.
Ctrl + Tab -- Move between two or more open Excel files
Alt + = -- Create the formula to sum all of the above cells.
Ctrl + -- Insert the worth of above cell into the present cell.
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 + (Right arrow) -- Move to next section of text.
Ctrl + Space -- Select entire column.
Shift + Space -- Select entire row.
Ctrl + W -- Close document.

Post a Comment

0 Comments