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.

Microsoft Excel shortcut keys Functions Keys




Microsoft Excel shortcut keys


Shortcut
Description


F1
Opens the help menu.


F2
Edits the selected cell.


F3
After a name has been created, F3 will paste names.


F4
Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.


F5
Goes to a specific cell. For example, C6.


F6
Move to the next pane.


F7
Spell check selected text or document.


F8
Enters Extend Mode.


F9
Recalculates every workbook.


F10
Activates the menu bar.


F11
Creates a chart from selected data.


F12
Save As option.

Microsoft Excel shortcut keys Enter,Backspace




Microsoft Excel shortcut keys


Shortcut
Description


Alt+Tab
Cycles through applications.


Alt+Spacebar
Opens the system menu.


Alt+Backspace
Undo.


Alt+Enter
While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.


Alt+=
Creates a formula to sum all of the above cells.


Alt+'
Allows formatting on a dialog box.