![]() Since our example data set consists of headers, we can use the shortcut Ctrl + Shift + L. The only advantage of using this shortcut to create filters is that we can also turn off the filters using the same shortcut. Apart from this, this shortcut (Ctrl + Shift + L) does not format the data. Instead, it automatically considers that we have headers in our data. Unlike the previous shortcut, this particular shortcut requires headers in columns because it does not allow us to choose whether we have headers or not. It looks like this:Īnother shortcut to create filters in Excel involves the use of shortcut Ctrl + Shift + L. After clicking the OK button, we get the filter icons next to the text (names) of the headers. Since we have the headers, we select the checkmark. When we select a cell A2, and we press the shortcut key Ctrl + T, we get the dialogue box: By doing this, Excel will transform the data into a table and enable filters.įor example, let us take the following data set where we have headers (First Name, Last Name): Once we have selected the options, we need to click the OK button. After pressing the shortcut, Excel will display a dialogue box asking us whether our data includes headers or not. We need to select a cell inside our data range and then use the keyboard shortcut Ctrl + T or Ctrl + L. The keyboard shortcuts are best and the most effective for manipulating the data using filters in Excel.įollowing are some frequently used filtering options with keyboard shortcuts:Ĭreating a filter is the first step of filtering the data. Let us now discuss each method in detail: By using the keyboard shortcut keysĮxcel supports an extensive range of keyboard shortcuts to help us cut the working time and increase the speed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |