Go to the Home tab and to the Alignment group. Excel filter won’t count the merged rows data. The same thing happens with the merged rows.
If the column headings are being merged, then the Excel filter becomes unable to choose the items present from the merged columns. So unmerge if you have any merged cells in the spreadsheet.
In such cases, the Wrap Text function also works great in formatting the cells correctly.Īnother reason for your Excel filter not working is because of the merged cells. After that press “ALT + ENTER” option for typing in the new line of the cell. In order to get multiple lines for the heading, into the cell you just need to type the first line. Check the data which has only one row of column headings. By turning off the filter you can see the rows that are now been removed. Choose the Delete option from the listed option to delete the select blank rows. You need to select these rows first and then make a right-click over the anyone of the blue color row number. For easy identification, the row number of each blank row appears in blue color. After this only, the blank rows will clearly appear on your screen. Choose the ‘(Blanks)’ option and tap to the OK. Now remove the check sign across the ‘(Select All)’ after then shift right on the bottom of the filter list. First of all turn on the filter and then click on the drop-down arrow present in any columns to show the filter list. 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
Preview the repaired files and click Save File to save the files at desired location. Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process. Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
0 kommentar(er)
