Top 10 Atalhos mais importantes do Excel 🏆 você precisa saber!

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this free Excel video lesson, we'll learn how to use the 10 best Excel shortcuts that can help you automate tasks and save time with Excel. The keyboard shortcuts we'll cover are: CTRL; CTRL+D CTRL+ENTER CTRL+ARROWS (↑, ↓, ←, →) ALT+F1 CTRL+ CTRL+- CTRL+E CTRL+U Ctrl+Page Up / Ctrl+Page Down Ctrl+Arrows (↑, ↓, ←, →): Moves the cursor to the last cell filled in a specific direction. Practical Example: Imagine you have a table with 5,000 rows of data. To quickly go from the first row (cell A1) to the last row in column A, simply select cell A1 and press Ctrl↓. The cursor will jump to the last filled cell in column A. To go to the last column in your table, from the last row, press Ctrl→. Ctrl Page Up and Ctrl Page Down: Allow you to navigate between different sheets in a file. Practical Example: If your workbook has sheets named "January," "February," and "March," use Ctrl Page Down to go from "January" to "February," and then to "March." Use Ctrl Page Up for the reverse. It's much faster than clicking tabs with the mouse. Ctrl + (Plus Sign): Inserts cells, rows, or columns. Practical Example: You realize you need to add a new row between rows 5 and 6 in your spreadsheet. Select the entire row 6 (Shift+Spacebar) and press Ctrl. A new, empty row will be inserted above row 6. Ctrl-(Minus Sign): Deletes cells, rows, or columns. Practical Example: You have a column of data you no longer need. Select the entire column (Ctrl-Spacebar) and press Ctrl-. The selected column will be removed. Ctrl-E: Flash Fill. This shortcut recognizes a pattern and automatically fills the rest of the column. Practical Example: If you have a column of full names (e.g., "Maria Silva") and want to create a new column with only the first name. In the cell next to "Maria Silva," type "Maria." Then, in the cell below, press Ctrl-E. Excel will fill the rest of the column with first names, such as "João" and "Ana," based on the pattern it identified. Ctrl-;: Inserts the current date into the cell. Practical Example: In an inventory control spreadsheet, you need to record the date a product was received. Simply select the cell and press Ctrl+D; the current date will be inserted instantly. Ctrl+D: Fills the cell below with the content and formatting of the cell above. Practical Example: If cell B2 has the value "Sold" and you want to fill the next 10 cells below with the same word, simply select cells B2 through B12 and press Ctrl+D. Ctrl+Enter: Fills multiple selected cells with the same content or formula. Practical Example: You need to write the word "Pending" in several non-adjacent cells (e.g., A5, C8, E12). Select the desired cells by holding down the Ctrl key while clicking them. Then, type "Pending" and press Ctrl+Enter. The word will be inserted in all selected cells at once. Ctrl+U: Applies an underline to the text. Practical Example: To highlight the title of a report. Select the title and use Ctrl+U to underline it, instead of clicking the formatting icon on the ribbon. Alt+F1: Creates a chart from the selected data. Practical Example: You have a table with sales and month data. Select the entire table and press Alt+F1. Excel will instantly create a column chart on the same worksheet, displaying the data visually. 0:07 - Shortcut 01 0:51 - Shortcut 02 2:21 - Shortcut 03 3:17 - Shortcut 04 4:27 - Shortcut 05 5:02 - Shortcut 06 6:09 - Shortcut 07 6:33 - Shortcut 08 8:03 - Shortcut 09 9:07 - Shortcut 10 #ExcelenteJoão #Excel #Dashboard