General Description Shortcut Key New file Ctrl + N Open file Ctrl + O Save file Ctrl + S Move between open workbooks Ctrl + F6 Close file Ctrl + F4 Save as F12 Display the print menu Ctrl + P Select whole spreadsheet Ctrl + A Select column Ctrl + Space Select row Shift + Space Undo last action Ctrl + Z Redo last action Ctrl + Y
General Description Shortcut Key New file Ctrl + N Open file Ctrl + O Save file Ctrl + S Move between open workbooks Ctrl + F6 Close file Ctrl + F4 Save as F12 Display the print menu Ctrl + P Select whole spreadsheet Ctrl + A Select column Ctrl + Space Select row Shift + Space Undo last action Ctrl + Z Redo last action Ctrl + Y
Formatting Text In Worksheet Description Shortcut Key Bold toggle for selection Ctrl + B Italic toggle for selection Ctrl + I Underline toggle for selection Ctrl + U Strikethrough for selection Ctrl + 5 Change the font Ctrl + Shift + F Change the font size 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 Shortcut Key Select entire worksheet Ctrl + A Select entire row Shift + Spacebar Select entire column Ctrl + Spacebar Manual select Hold Shift + with Left, Right, Up, Down Arrow Key, Copying and Moving Text Description Shortcut Key Cut Ctrl + X Copy Ctrl + C Paste Ctrl + V,
Inserting Text Automatically
Description Shortcut Key
Autosum a range of cells Alt + Equals Sign
Insert the date Ctrl + ; (semi-colon)
Insert the time Ctrl + Shift + ; (semi-colon)
Insert columns/rows Ctrl + Shift + + (plus sign)
Misc Description Shortcut Key Find text Ctrl + F Replace text dialog Ctrl + H Create a chart automatically on new sheet F11 Edit a cell comment Shift + F2
Main Jaws Keystrokes In Excel Description Shortcut Key Say Version of Excel Ctrl + Shift + V Move to Next Sheet Ctrl + Page Down Move to Prior Sheet Ctrl + Page Up Go to a cell command Ctrl + G Collapse Selection To Active Cell Shift + Backspace Say Active Cell Coordinates Insert + C AutoSum Alt + Equals Formula Mode Equals Sign Insert Date In Current Cell Ctrl + ; (semicolon)