Practice Shortcut keys MS Office
by
SCHOOLS VISION
Practice Shortcut keys about MS Office
✪ Create a new workbook
✪ Ctrl+N
✪ Ctrl+N
✪ Open an existing workbook
✪ Ctrl+O
✪ Ctrl+O
✪ Save a workbook
✪ Ctrl+S
✪ Ctrl+S
✪ Open the Save As dialog box
✪ F12
✪ F12
✪ Close a workbook
✪ Ctrl+W
✪ Ctrl+W
✪ Close Excel
✪ Ctrl+F4
✪ Ctrl+F4
✪ Insert a new worksheet
✪ Shift+F11
✪ Shift+F11
✪ Undo an action
✪ Ctrl+Z
✪ Ctrl+Z
✪ Redo an action
✪ Ctrl+Y
✪ Ctrl+Y
✪ Switch to Print Preview
✪ Ctrl+F2
✪ Ctrl+F2
✪ Open the Help panel
✪ F1
✪ F1
✪ Go to the “Tell me what you want to do” box
✪ Alt+Q
✪ Alt+Q
✪ Check spelling
✪ F7
✪ F7
✪ Calculate all worksheets in all open workbooks
✪ F9
✪ F9
✪ Calculate active worksheets
✪ Shift+F9
✪ Shift+F9
✪ Turn key tips on or off
✪ Alt or F10
✪ Alt or F10
✪ Show or hide the ribbon
✪ Ctrl+F1
✪ Ctrl+F1
✪ Expand or collapse the formula bar
✪ Ctrl+Shift+U
✪ Ctrl+Shift+U
✪ Minimize the workbook window
✪ Ctrl+F9
✪ Ctrl+F9
✪ Create a bar chart based on selected data (on a separate sheet)
✪ F11:
✪ F11:
✪Create an embedded bar chart based on select data (same sheet)
✪ Alt+F1
✪ Alt+F1
✪ Search in a spreadsheet, or use Find and Replace
✪ Ctrl+F
✪ Ctrl+F
✪ Open the File tab menu
✪ Alt+F
✪ Alt+F
✪ Go to the Home tab
✪ Alt+H
✪ Alt+H
✪ Open the Insert tab
✪ Alt+N
✪ Alt+N
✪ Go to the Page Layout tab
✪ Alt+P
✪ Alt+P
✪ Go to the Formulas tab
✪ Alt+M
✪ Alt+M
✪ Go to the Data tab
✪ Alt+A
✪ Alt+A
✪ Go to the Review tab
✪ Alt+R
✪ Alt+R
✪ Go to the View tab
✪ Alt+W
✪ Alt+W
✪ Go to the Add-ins tab
✪ Alt+X
✪ Alt+X
✪ Go to the Help tab
✪ Alt+Y
✪ Alt+Y
✪ Switch between open workbooks
✪ Ctrl+Tab
✪ Ctrl+Tab
✪ Insert a function
✪ Shift+F3
✪ Shift+F3
✪ Create, run, edit, or delete a macro
✪ Alt+F8
✪ Alt+F8
Hello Thanks for comment. we will resolve your doubt / question as soon as possible.
Comments