AUTO FILTER NO FURTHER A MYSTERY

By filtering your data, you are not deleting rows, you happen to be hiding them. Hidden rows is often unhidden by selecting the row above and below the concealed row, ideal-clicking on them and selecting "Unhide".Any time you filter knowledge, whole rows are hidden if values in a number of columns Do not fulfill the filtering requirements. You coul

We are able to make use of the excel shortcut keys Ctrl + Change + L to apply filters for the column headers. It is possible to click on any header to apply it all through the table or on certain headers to use it to them and push CTRL + SHIFT + L.Decide on all the info you wish to filter. Click and drag to choose all of the cells you wish to gener