Friday, December 28, 2018

Microsoft Excel shortcut keys "Functions Keys Ctrl , Shift , Alt "




Microsoft Excel shortcut keys


Shortcut
Description




Shift+F1
Opens the "What's This?" window.


Shift+F2
Allows the user to edit a cell comment.


Shift+F3
Opens the Excel formula window.


Shift+F5
Brings up a search box.


Shift+F6
Move to previous pane.


Shift+F8
Add to selection.


Shift+F9
Performs calculate function on active sheet.


Ctrl+F3
Open Excel Name Manager.


Ctrl+F4
Closes current Window.


Ctrl+F5
Restores window size.


Ctrl+F6
Next workbook.


Ctrl+Shift+F6
Previous workbook.


Ctrl+F7
Moves the window.


Ctrl+F8
Resizes the window.


Ctrl+F9
Minimize current window.


Ctrl+F10
Maximize currently selected window.


Ctrl+F11
Inserts a macro sheet.


Ctrl+F12
Opens a file.


Ctrl+Shift+F3
Creates names by using those of either row or column labels.


Ctrl+Shift+F6
Moves to the previous worksheet window.


Ctrl+Shift+F12
Prints the current worksheet.


Alt+F1
Inserts a chart.


Alt+F2
Save As option.


Alt+F4
Exits Excel.


Alt+F8
Opens the macro dialog box.


Alt+F11
Opens the Visual Basic editor.


Alt+Shift+F1
Creates a new worksheet.


Alt+Shift+F2
Saves the current worksheet.

No comments:

Post a Comment