In this Excel video tutorial, we gonna see one of the most useful Excel shortcut keys to help us on a daily basis and to automate tasks. These shortcuts can significantly speed up your workflow in Excel by allowing quick navigation, selection, and manipulation of data.
00:00 Subscribe!
00:12 Like the video!
00:23 Ctrl Arrows
02:00 Shift Arrows
02:44 Ctrl Shift Arrows
06:40 Ctrl Space Bar
06:51 Shift Space Bar
08:40 Ctrl -
10:15 Ctrl +
11:48 Ctrl Shift L
14:20 Ctrl T
14:40 Alt =
17:01 Alt Enter
19:31 Ctrl A
21:20 Alt F1
22:09 Ctrl E
Ctrl Arrows, Move to the edge of the data region (left, right, up, or down) in a worksheet. For example, pressing Ctrl + Right Arrow will move the cursor to the last cell in the current row that contains data.
Shift Arrows, Select cells. Extends the selection of cells by one cell in the direction of the arrow key.
Ctrl Shift Arrows, Select a range of cells from the current position to the edge of the data region in the specified direction.
Ctrl Space Bar, Select the entire column of the active cell.
Shift Space Bar, Select the entire row of the active cell.
Ctrl +, Insert cells, rows, or columns. Opens the Insert dialog box, allowing you to insert cells, rows, or columns.
Ctrl -, Delete cells, rows, or columns. Opens the Delete dialog box, allowing you to delete cells, rows, or columns.
Ctrl Shift L, Toggle AutoFilter. Adds or removes filters in the selected range or entire worksheet if no specific range is selected.
Ctrl T, Create a table from the selected range. Converts the selected range into an Excel table, which includes features like sorting and filtering.
Alt =, Insert the AutoSum formula. Automatically inserts a SUM function to sum the values above or to the left of the current cell.
Alt Enter, Insert a line break within a cell. Allows you to add multiple lines of text within a single cell.
Ctrl A, Select all cells in a table, data set or the entire worksheet or even select all the elements such as images, icons, shapes etc. If the cursor is within a data range, it selects the entire range; pressing it again will select the entire worksheet.
Alt F1, Create a chart. Inserts a default chart (usually a column chart) using the data in the current range.
Ctrl E, Flash Fill. Automatically fills values in the selected column by recognizing patterns in the data. For example, if you have a column of first names and another of last names, you can use Flash Fill to combine them into a single column of full names.
#JopaExcel #Dashboard #Excel
1 июл 2024
