![]() In order to remove the blank rows from the selected filter area. ![]() So it will be better if you manually select the data in which you want to apply the Excel filter function. This can also result in selection up to the first empty column or rows excluding the data present after the blanks. If you don’t choose the area then Excel applies the filter on the complete one. Or if you only want to filter out only the specific range then choose the section which you want to filter prior to turning on the Filter. If your spreadsheet contains empty rows or columns. Reason 2# Make Proper Selection Of The Data
0 Comments
Leave a Reply. |