use the filter and write its shortcut command
Answers
Answered by
4
Answer:
There is another way to create filter icons using keyboard shortcuts: Ctrl + Shift + L.With these keys, you can, just like in the previous method, create filter icons. This time, you need to have headers in the columns.Our example has headers, so we can use this method.Click any cell inside the data and use the shortcut. It will add filter icons, the same way as when we were creating a table, but this time we won’t be asked whether our columns have headers, and it doesn’t format our cells visually.To turn off filter icons use Ctrl + Shift + L again.
Similar questions