Microsoft Excel Keyboard Keys
Microsoft Excel Keyboard Keys Source:
General
Description New file Open file Save file Move between open workbooks Close file Save as Display the print menu Select whole spreadsheet Select column Select row Undo last action Redo last action Start a formula Exit Excel 97
Shortcut Key Ctrl + N Ctrl + O Ctrl + S Ctrl + F6 Ctrl + F4 F12 Ctrl + P Ctrl + A Ctrl + Space Shift + Space Ctrl + Z Ctrl + Y Equals Sign (eg. SUM(A1+A2) Alt + F4
Navigating
Description Move to next cell in row Move to previous cell in row Up one screen Down one screen Move to next worksheet Move to previous worksheet Go to first cell in data region Go to last cell in data region
Formatting Text In Worksheet
Description Bold toggle for selection Italic toggle for selection Underline toggle for selection Strikethrough for selection Change the font Change the font size
Shortcut Key Tab Shift + Tab Page Up Page Down Ctrl + Page Down Ctrl + Page Up Ctrl + Home Ctrl + End
Shortcut Key Ctrl + B Ctrl + I Ctrl + U Ctrl + 5 Ctrl + Shift + F Ctrl + Shift + P
Apply outline borders
Ctrl + Shift + 7
Remove all borders
Ctrl + Shift + Underline
Wrap text in same cell
Alt + Enter
Formatting Cells
Description
Shortcut Key
Format cells
Ctrl + 1
Select font
Ctrl + Shift + F
Select point size
Ctrl + Shift + P
Format as currency
Ctrl + Shift + 4
Format as general (to remove any formatting) Ctrl + Shift + # (hash sign)
Format as percentage
Ctrl + Shift + 5
Format as number
Ctrl + Shift + 1
Editing/Deleting Text
Description
Shortcut Key
Delete one character to right
Delete
Delete one character to left
Backspace
Edit active cell
F2
Cancel cell entry
Escape Key
Highlighting Cells
Description Select entire worksheet Select entire row Select entire column Manual select
Copying and Moving Text
Description Cut Copy Paste
Inserting Text Automatically
Description Autosum a range of cells Insert the date Insert the time Insert columns/rows
Shortcut Key Ctrl + A Shift + Spacebar Ctrl + Spacebar Hold Shift + with Left, Right, Up, Down Arrow Key
Shortcut Key Ctrl + X Ctrl + C Ctrl + V
Shortcut Key Alt + Equals Sign Ctrl + ; (semi-colon) Ctrl + Shift + ; (semi-colon) Ctrl + Shift + + (plus sign)
Insert a new worksheet
Misc
Description Find text Replace text dialog Create a chart automatically on new sheet Edit a cell comment
Main Jaws Keystrokes In Excel
Description Say Version of Excel Move to Next Sheet Move to Prior Sheet Go to a cell command Collapse Selection To Active Cell Say Active Cell Coordinates AutoSum Formula Mode Insert Date In Current Cell
Shift + F11
Shortcut Key Ctrl + F Ctrl + H F11 Shift + F2
Shortcut Key Ctrl + Shift + V Ctrl + Page Down Ctrl + Page Up Ctrl + G Shift + Backspace Insert + C Alt + Equals Equals Sign Ctrl + ; (semicolon)
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- microsoft excel keyboard keys
- capability analysis spc for excel
- exceljet excel shortcuts pdf
- pandas xlsxwriter charts documentation
- excel keyboard shortcuts and function keys
- 239 excel keyboard shortcuts
- data analysis business intelligence made easy with excel
- opa excel tips creating a box and whisker plot in excel
- microsoft excel cheat sheet excel courses customguide
- fourth step worksheet erik bohlin m a
Related searches
- microsoft 365 product keys 2020 for free
- microsoft 365 product keys 2019
- computer keyboard keys names
- assign keyboard keys windows 10
- keyboard keys for emoticons
- microsoft excel keyboard shortcuts pdf
- keyboard keys not working
- keyboard keys icons
- dell keyboard keys not working
- asus keyboard keys not working
- reassign keyboard keys windows 10
- configure keyboard keys windows 10