Type the letter "C" to clear the filter.Ħ.Select a cell in the header row and press Alt + down arrow to display the Filter menu for the column.Press Ctrl + Shift + L to turn filtering on again. ![]() You can also press Ctrl + Shift + L t turn filtering off which will remove the filters. To clear all filters for all fields in the current filtered range, select a cell in the range and press Alt > A > C.ĭon't press Shift and don't press these keys at the same time as they access the Ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |