When you want to filter the data by using custom criteria, you can use a custom filter box.
This option was first introduced in the Microsoft Excel 2007. After that, all rows of your data will be displayed.įor this, you also can use the Excel ribbon Excel Ribbon The ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs it is available at the top of the excel sheet. It will clear all the filters in all the columns. Press shortcut key ALT+Down Arrow+C to clear all the filters in the current filtered range. read more submenuĮxample #5 – Clear All Filters in the Current Filtered Range in Excel T – Sort by Color Sort By Color When a column or a data range in excel is formatted with colors either by using the conditional formatting or manually, when we use filter on the data excel provides us with an option to sort the data by color, there is also an option for advanced sort where user can enter different levels of color for sorting.You must first press the ALT+ Down Arrow key to display the drop-down menu. Press the Spacebar Key to check and uncheck the checkbox.Įxample #4 – Drop Down Menu Keyboard Shortcut for Filter in Excel.Press the Up and Down arrow keys to select a command.Use Enter and Spacebar key to select and apply to filter. Once the excel filter is enabled, we can use arrow keys to navigate the filter menu. 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.Select multiple line or paragraphs then use Alt + Shift + up/down to move the entire selection.Īny partial paragraph selection will be extended to include that entire paragraph in the move.We have given below sales data region wise.
Usually no selection is required but the shortcut works for selections larger than a paragraph. The entire line/paragraph is automatically selected when you use the shortcut. If part of a line or paragraph is selected, Alt+Shift+up/down will still move the entire paragraph, ignoring the selection. No selection neededĪlt + Shift + up/down works without selecting the text first, which is real time saver. Use this trick to reorder lists or entire paragraphs. Put the cursor anywhere in a line then press Alt + Shift + up or down arrows. Word has a simple shortcut to that move the current line or paragraph up or down without selecting it first There’s a faster shortcut for moving a line or paragraph around a Word document which isn’t in the usual lists of Word keyboard shortcuts. Don’t bother using cut / paste to manually sorting or adjusting a list.