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 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 -- undo the last action repeated
- 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 the formula to sum all of the above cells.
- Ctrl + -- Insert the value of above cell nto the 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 + (Right arrow) -- Move to next section of text.
- Ctrl + Space -- Select entire column.
- Shift + Space -- Select entire row.
- Ctrl + W -- Close document.
- F8 for the selection
- Crl+Shift+Space close workbook
- F4 last action repeated
- Shift+F11 insert new worksheet
- F9 calculate the sum
- Alt+V+Z dialog box for the zoom
- Crl+F1 hide ribbon/ show ribbon
- Crl+shift+U expand formula bar
No comments:
Post a Comment