Saturday 28 December 2019

EXCEL SHORTCUT KEYS

F2   Edit the selected cell
F5   Go to a specific cell
F7   Spell check selected text and/or document
F11   Create chart
Ctrl + Shift + ;   Enter the current time
Ctrl + ;   Enter the current date
Alt + Shift + F1   Insert new worksheet
Shift + F3   Open the Excel formula window
Shift + F5   Bring up search box
Ctrl + A   Select all contents of 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   Strikethrough highlighted selection
Ctrl + O   Open options
Ctrl + N   Open new document
Ctrl + P   Open print dialog box
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 in the same document
Ctrl + Tab   Move between two or more open Excel files
Alt + =   Create formula to sum all of above cells
Ctrl + ‘   Insert value of above cell into current 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 + g   Move to next section of text
Ctrl + Space   Select entire column
Shift + Space   Select entire row
Ctrl + W   Close document

No comments: