Practice Shortcut keys MS Office

-Advertisement-
Practice Shortcut keys about MS Office
✪ Create a new workbook
✪ Ctrl+N

✪ Open an existing workbook
✪ Ctrl+O

✪ Save a workbook
✪ Ctrl+S

✪ Open the Save As dialog box
✪ F12

✪ Close a workbook
✪ Ctrl+W

✪ Close Excel
✪ Ctrl+F4

✪ Insert a new worksheet
✪ Shift+F11

✪ Undo an action
✪ Ctrl+Z

✪ Redo an action
✪ Ctrl+Y

✪ Switch to Print Preview
✪ Ctrl+F2

✪ Open the Help panel
✪ F1

✪ Go to the “Tell me what you want to do” box
✪ Alt+Q

✪ Check spelling
✪ F7

✪ Calculate all worksheets in all open workbooks
✪ F9

✪ Calculate active worksheets
✪ Shift+F9

✪ Turn key tips on or off
✪ Alt or F10

✪ Show or hide the ribbon
✪ Ctrl+F1

✪ Expand or collapse the formula bar
✪ Ctrl+Shift+U

✪ Minimize the workbook window
✪ Ctrl+F9

✪ Create a bar chart based on selected data (on a separate sheet)
✪ F11:

✪Create an embedded bar chart based on select data (same sheet)
✪ Alt+F1

✪ Search in a spreadsheet, or use Find and Replace
✪ Ctrl+F

✪ Open the File tab menu
✪ Alt+F

✪ Go to the Home tab
✪ Alt+H

✪ Open the Insert tab
✪ Alt+N

✪ Go to the Page Layout tab
✪ Alt+P

✪ Go to the Formulas tab
✪ Alt+M

✪ Go to the Data tab
✪ Alt+A

✪ Go to the Review tab
✪ Alt+R

✪ Go to the View tab
✪ Alt+W

✪ Go to the Add-ins tab
✪ Alt+X

✪ Go to the Help tab
✪ Alt+Y

✪ Switch between open workbooks
✪ Ctrl+Tab

✪ Insert a function
✪ Shift+F3

✪ Create, run, edit, or delete a macro
✪ Alt+F8

Post a Comment

Hello Thanks for comment. we will resolve your doubt / question as soon as possible.

Previous Post Next Post

Contact Form