Excel is a commonly used office software for all of us, so do you know what the shortcut keys are for Excel? Then the editor will bring you a complete list of Excel shortcut keys. Friends in need can take a look.
Commonly used shortcut keys:
[Ctrl+N] Create a new blank workbook
【Ctrl+O】 Open
【Ctrl+S】 Save
【Ctrl+P】 Print
[Ctrl+C/V] Copy or paste
[Ctrl+F/H] Find or replace
[Ctrl+A] Select all or pop up the function parameter window (enter the function, shortcut key to pop up the function window)
【Ctrl+X】 Cut
【Ctrl+Z】 Undo the previous operation
[Ctrl+Y]/[F4] Repeat the previous step
[Ctrl+G]/[F5] Positioning (Go to)
【Ctrl+1】 Set cell format
【Ctrl+↓↑←→】 Quick arrival
【Ctrl+Shift+↓↑←→】 Quick selection
[Ctrl+Shift+L] Filter or cancel filtering
【Ctrl+Enter】 Batch input content
[Ctrl+K] Insert hyperlink
[Ctrl+T/L] Create table/list
【F4】 Switch cell address reference
【F12】Save as
【Ctrl+Tab】 Switch workbook
【Ctrl+Page Up】/【Ctrl+Page Down】switch worksheet
Alt shortcut keys:
[Alt+;] Locate visible cells
[Alt+=] Automatic summation
【Alt+F1】Create embedded chart
[Alt+F2] Save as
[Alt+F4] Exit the Excel program
[Alt+F8] Open the "Macro" dialog box
[Alt+F11] Enter the VBA editing environment
[Alt+Enter] Force a line break within the cell
【Alt+↓】Expand the drop-down list
[Alt->D->P] PivotTable Wizard
[Alt+PgUp/PgDn] Move one screen left or right
Ctrl shortcut key:
【Ctrl+`】 Switch to display formula/results
[Ctrl+6] Hide or show objects
[Ctrl+8] Hide or show ratings
[Ctrl+9] Hide selected rows
[Ctrl+0] Hide selected columns
[Ctrl+Shift+~] General format (set cell content)
[Ctrl+Shift+!] Currency format (set cell content)
[Ctrl+Shift+@] Time format (set cell content)
[Ctrl+Shift+#] Date format (set cell content)
[Ctrl+Shift+:] Enter the current system time
【Ctrl+;】 Enter the current date of the system
[Ctrl+-] Delete cells/ranges/rows/columns
【Ctrl++】 Insert cell/range/row/column
[Ctrl+F1] Minimize or maximize the ribbon
【Ctrl+F3】 Name manager
[Ctrl+Alt+V] Paste Special
[Ctrl+D/R] Fill with format downward or right
Shift shortcut key:
【Shift+F2】Insert comment
[Shift+F3] Call up the function parameter window
【Shift+F11】Insert a new worksheet
F function key shortcut keys:
【F1】View Excel help system
【F2】Enter editing state
[F3] Bring up the paste name window (it can also be said to bring up the set drop-down menu content window)
【F9】Recalculate or convert the formula into a numerical value
【F11】Create an independent chart
The above is the list of Excel shortcut keys brought by the editor, I hope it can help everyone.
