Excel Tips: 52 Most Useful Shortcuts for You to Learn
Want to save time and optimize your work in Excel? Take a look at the most commonly used Excel shortcuts so you can learn them, and see if taking a course is worthwhile!
O Excel It is one of the most widely used software programs in the world. It is estimated that 90% of companies use the application for general controls. payments, profit projections, production control, etc.
It's almost unrealistic to expect to work in administrative fields or deal with numbers, in general, without Excel.
There are two ways to learn how to use it. Excel. The first is self-teaching. It works best for those seeking general knowledge of the software or who will only use it for simple functions.
For those seeking more in-depth knowledge, it's important to look for Excel courses.
Specific lessons can also help you master a particular area within the application (such as, for example, a course entirely focused on business or with specific external applications, How to use Excel with VBA).
Whether seeking more general or more specific knowledge, one thing is certain: you save a lot of time by knowing. Excel shortcuts. A journey filled with many clicks and keystrokes can be shortened by three or four keystrokes.
Therefore, we've compiled 52 important shortcuts for you to know.
List of the most commonly used Excel shortcuts:
Tips for navigating and selecting cells in Excel.
- – Ctrl + arrow keys (↑, ↓, ←, →): moves quickly to the end of the data region in the chosen direction (does not go beyond empty cells);
- Ctrl + Shift + arrow key: expands the selection to the end of the data region in the chosen direction;
- Shift + spacebar: selects the entire row of the active cell;
- Ctrl + spacebar: selects the entire column of the active cell;
- Ctrl + Shift + Space: selects the entire spreadsheet.
Tips for editing and formatting cells in Excel.
- Ctrl + D: Fills the cells below the selection with the content of the cell above;
- Ctrl + R: Fills the cells to the right of the selection with the content of the cell to the left;
- – Ctrl + 1: opens the “Format Cells” window, allowing you to change number formatting, alignment, fonts, borders, etc.;
- – Ctrl + Shift + $: applies currency formatting to the selected cell;
- – Ctrl + Shift + %: applies the percentage format to the selected cell;
- – Ctrl + Shift + !: applies the number format with two decimal places and a thousands separator;
- Alt + E, S, V: opens the "Paste Special" menu, useful for pasting values, formats, or formulas in a customized way.
Tips for manipulating spreadsheets in Excel.
- Ctrl + Page Up / Page Down: switches between the spreadsheet tabs on the left or right;
- Alt + E, L: deletes the active worksheet;
- Ctrl + T: creates a table from the selected data;
- Ctrl + Shift + "+": inserts a cell, row, or column into the spreadsheet;
- Ctrl + – (hyphen): deletes a cell, row, or column from the spreadsheet.
Tips for working with formulas in Excel.
- – Ctrl + Shift + Enter: insert an array formula (when you type an array formula, such as “SUM(IF(…))”, you need to press Ctrl + Shift + Enter for the formula to be considered as such);
- – F9: evaluates the selected formula (useful for testing parts of complex formulas);
- Alt + =: automatically inserts the `SUM` function into the selected cell, adding up a range of cells;
- Ctrl + ~ (tilde): displays the formulas in the spreadsheet instead of the calculated results (formula view);
- Ctrl + Shift + U: expands or collapses the formula bar.
Tips for data analysis tools in Excel
- Alt + D + F + F: activates or deactivates automatic filters in data selection;
- – Ctrl + Shift + F3: opens the “Create Names from Selection” dialog box to create names for data ranges;
- Alt + A + T: opens the "Sort & Filter" tool in Excel;
- Alt + N + V: opens the "Pivot Table" tool to create a new summary table of the data;
- Alt + N + T: quickly inserts a chart with the selected data.
Tips for using references and links in Excel.
- – Ctrl + K: opens the “Insert Link” window, allowing you to add links to websites or other spreadsheets;
- – Ctrl + Shift + F5: opens the “Go To” window, where you can quickly jump to a specific cell or range name;
- – F4: Repeats the last action performed, useful for applying formatting or repeated functions to other cells;
Tips for other interesting Excel shortcuts
- – Ctrl + Shift + Z: performs the "Redo" operation again (an alternative to Ctrl + Y in some cases);
- Alt + H, O, I: automatically adjusts the column width to fit the content.
- Ctrl + Shift + “+” (on the numeric keypad): opens the box to insert new cells, rows, or columns;
- Ctrl + Shift + K: inserts a hyperlink in the selected cell;
- – Ctrl + Alt + F9: forces the calculation of all formulas in the spreadsheet, even if Excel is configured to calculate automatically;
Shortcut tips for controlling windows in Excel.
- – Ctrl + F6: switches between open Excel windows (useful when you have multiple spreadsheets open at the same time);
- Alt + F4: Closes Excel (or the active window);
Tips for basic Excel shortcuts
- Ctrl + C: copy;
- Ctrl + V: paste;
- Ctrl + X: cut;
- Ctrl + Z: undo;
- Ctrl + Y: redo;
- Ctrl + S: save;
- Ctrl + P: print;
- Ctrl + A: select all;
- Ctrl + F: find;
- Ctrl + H: replace;
- Ctrl + Shift + L: enable/disable filters;
- Ctrl + Shift + “+”: insert cells, rows, or columns;
- Ctrl + “-“: delete cells, rows, or columns;
- Alt + E, S, V: special collar;
- F2: edit the selected cell;
ChatGPT helped us!
Ah! The research for this material was done with the help of ChatGPT.
Generative artificial intelligence can be a great advantage when researching rankings, lists, and placements.
To understand what the doubts might be and the best way to address them all in one place, various questions were asked about what people's biggest doubts are regarding... Excel shortcuts.
O ChatGPT It can be a great ally in various professions, including developers, administrators, and marketers. The biggest secret is understanding the nuances of how it works and knowing exactly what to ask.
