Optimizing the use of Excel will have no secrets with these 23 basic keyboard shortcuts to get more out of it
If a few hours ago we saw the best key combinations to be able to take advantage of the time we spend using Microsoft Word, now it's time to do the same with Excel, the utility dedicated to preparing spreadsheets that is integrated into the Microsoft office suite.
These are 23 keyboard shortcuts, some of the most useful that can be found in Excel for Windows, designed to speed up as much as possible your work. In this way we avoid having to divert our attention looking to place the mouse pointer on the necessary option at all times.
- Close a book :Ctrl+R
- Open a book :Ctrl+A
- Go to the Home tab :ALT+O
- Save a book :Ctrl+G
- Copy :Ctrl+C
- Paste :Ctrl+V
- Undo :Ctrl+Z
- Remove cell contents :Delete key
- Choose a fill color :ALT+O, S, O
- Cut :Ctrl+X
- Go to Insert Tab :ALT+B
- Bold :Ctrl+N
- Center cell contents :Alt+H, A, C
- Go to Page Layout tab :Alt+C
- Go to Data tab :Alt+D
- Go to View Tab :Alt+N
- Open a context menu :Shift+F10 or context key
- Add Borders :ALT+O, B, B
- Delete Column :Alt+H, D, C
- Go to Formulas tab :Alt+U
- Hide selected rows :Ctrl+9
- Hide selected columns :Ctrl+0
Along with these 23 key combinations, there are also a series of shortcuts thanks to the function keys that we have on our equipment. They are in total 12 complementary functions to improve our performance using Excel:
- F1 key: Displays Excel Help
- F2 key: Enter edit mode for the active cell "
- F3 Key: If there is a defined name, displays the Paste Name dialog box"
- F4 key: Repeat the last action
- F5 key: Go to
- F6 key: You move between the panels of a divided book
- F7 key: Spell check
- F8 key: Activates the Expand selection mode
- F9 key: Solve the formulas that you have in the sheets of your open books
- F10 key: Activates the menu bar
- F11 Key: Create a chart sheet with the selected cell range F12 Save As