As we can see in the above image, there are a lot of keyboard shortcuts available in the filter menu.Įxample #3 – Select Menu Items Using Arrow keys. As we can see that every cell contains drop down an icon like the image then, Press the ALT + down arrow key on the keyboard to open the filter menu like the below screenshot. Once the filter has enabled on your data, you can use the drop-down menus on each of the column headers. Refer to the below screenshot.Įxample #2 – Opening the Drop-down Filter Menu in Excel Once applying the filter, the drop-down filter menus will appear in the header row of your data. We also can use the Keyboard Shortcut CTRL+SHIFT+L for turning On/Off the filters. Go to the DATA tab then, click on the Filter option under the Sort Filter section. First, select a cell in your data range if the data range contains any blank columns or rows, then better to select the entire range of cells. Pressing Ctrl+A to select the data range leaves the active cell unchanged.We have given below sales data region wise. There is another difference between Ctrl+* and Ctrl+A: Pressing Ctrl+* not only selects the data range, it also makes the top-left cell in that data range the active cell. Press it a third time (or press it a single time if you have a cell outside of a data range selected) and Excel selects the entire worksheet. If you press Ctrl+A a second time, then Excel expands the selection to include any headers. If you have a cell selected within a data range, pressing Ctrl+A once will function almost the same as Ctrl+*, meaning that it selects the data range, minus any headers. 
In most Windows-based programs, Ctrl+A stands for "select all," meaning everything in whatever file the program is working on. There is another keyboard shortcut that will also select a data range: Ctrl+A. Again, the selection doesn't extend to column A because column B is blank. (The other data range isn't selected because column B is blank.) If you start with cell D12 selected and press Ctrl+Shift+8, then the range C1:E190 is selected. If you start with cell A7 selected and then press Ctrl+Shift+8, then A1:A325 is selected. To see how the shortcut works, suppose you have data in the range A1:A325, and more data in the range C1:E190.
The shortcut also results in the upper-left cell of the range being the active cell. The selection stops when a blank row or a blank column is reached. (This is the same as Ctrl+*.) This selects, using the currently selected cell as the starting point, the contiguous cells that contain data. The quickest way to select a range of data on your worksheet is to use Ctrl+Shift+8.
0 kommentar(er)
