Data is not appear in drop dawn list in filter

Closed
Manoj - Feb 19, 2015 at 06:49 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Feb 19, 2015 at 06:05 PM
Hello,
i have some data rows almost 2000 there is black rows between every row. filter did not showing whole data in drop dawn so i can remove empty row or i can short data.
Please suggest me how can i remove empty rows.


1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
Feb 19, 2015 at 06:05 PM
Hello Manoj,

In the Home tab, go over to the Editing group and click on Find and Select. In the box that pops up, select Go to Special then, in the next pop up box, select Blanks and click OK. The blank rows should now be highlighted. Then, also in the Home tab, go to the Cells group and select Delete and then select "Delete Sheet Rows".

This should remove the blank rows from your sheet.

Regards,
vcoolio.
0