MS WORD & MS EXCEL SHORTCUT KEYS

MS WORD AND MS EXCEL

WORD

Alt + F + A Save As.

Alt + F + X Exit Word.

Alt + Left Arrow Go back one page.

Alt + Right Arrow Go forward one page.

Alt + S + T + I Insert Table of Contents.

Alt + S + T + R Remove Table of Contents.

Alt + W + F Full Screen Reading – View > Document Views > Full Screen Reading.

Alt + W + R Ruler. View > Show/Hide > Ruler.

Ctrl + = Apply subscript formatting (automatic spacing).

Ctrl + B Applies or removes bold formatting.

Ctrl + C Copy selected text or graphics to the Office Clipboard.

Ctrl + I Applies or removes italic formatting.

Ctrl + K Insert a hyperlink.

Ctrl + P Print a document.

Ctrl + S Save a document.

Ctrl + Shift + A Format all letters as capitals.

Ctrl + V Paste the most recent addition to the Office Clipboard.

Ctrl + W Close the active window / document.

Ctrl + Y Redo the last action or repeat an action.

Ctrl + Z Undo an action.

Ctrl+[ Decrease font size 1 point

Ctrl+] Increase font size 1 point

Ctrl+A Select all

Ctrl+B Bold

Ctrl+C Copy

Ctrl+E Center text

Ctrl+I Italic

Ctrl+L Left align text

Ctrl+O Open

Ctrl+R Right align text

Ctrl+S Save

Ctrl+U Underline

Ctrl+V Paste

Ctrl+W Close

Ctrl+X Cut

Ctrl+Y Re-do

Ctrl+Z Undo

Esc Cancel

EXCEL

Alt+H  go to the Home tab

Alt+H+ A+ C  centre align cell contents

Alt+H+ B  add borders

Alt+H+ H  choose a fill color

Alt+H+D+C  delete column

Alt+N  go to Insert tab

Alt+M  go to Formula tab

Alt+P  go to Page Layout tab

Alt+W  go to View tab

Altd+A  go to Data tab

Ctrl+0  hide the selected columns

Ctrl+9  hide the selected rows

Ctrl+B  bold

Ctrl+C  copy

Ctrl+O  open a spreadsheet

Ctrl+S  save a spreadsheet

Ctrl+v  paste

Ctrl+X  cut

Ctrl+Z  undo


Ctrl+W  close a spreadsheet