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.
|
Friday, December 28, 2018
Microsoft Excel shortcut keys "Functions Keys Ctrl , Shift , Alt "
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.
|
Subscribe to:
Posts (Atom)