badpower.blogg.se

With this, we can use any one of the following: It would help if we first press the “ALT+ Down arrow” key to display the drop-down menu. Finally, we must press the “Spacebar” key to check and uncheck the checkbox.Įxample #4 – Drop Down Menu Keyboard Shortcut for Filter in Excel.Next, we must press the “Enter” key to apply the command.We must press the “Up and Down arrow” keys to select a command.First, we must use the “Enter” and “Spacebar” keys to select and apply to the filter. Once the excel filter is enabled, we can use arrow keys to navigate the “Filter” menu. We can see in the above image that there are many keyboard shortcuts available in the “Text Filters” menu.Įxample #3 – Select Menu Items Using Arrow keys.Then, press the “ALT + down arrow key” on the keyboard to open the “Filter” menu like the below screenshot. As we can see, every cell contains a drop-down icon like the image. We must first select a cell in the header row.Follow the below steps for doing the same: Once the filter has been enabled on the data, we can use the drop-down menus on each column header. For example, refer to the below screenshot.Įxample #2 – Opening the Drop-down Filter Menu in Excel On applying the filter, the drop-down filter menus may appear in the header row of the data.We can also use the keyboard shortcut “CTRL+SHIFT+L” to turn on/off the filters. Then, click on the “Filter” option under the “Sort & Filter” section. Then, if the data range contains any blank columns or rows, choose the entire range of cells. First, we must select a cell in the data range.We have given below sales data region-wise.