Data is not appear in drop dawn list in filter
Closed
Manoj
-
Feb 19, 2015 at 06:49 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 19, 2015 at 06:05 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 19, 2015 at 06:05 PM
Related:
- Data is not appear in drop dawn list in filter
- Display two columns in data validation list but return only one - Guide
- Counter strike 1.6 cheats list - Guide
- Tmobile data check - Guide
- How to forward images to broadcast list in whatsapp - WhatsApp Forum
- How to filter unread messages in messenger - Facebook Messenger Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Feb 19, 2015 at 06:05 PM
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.
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.
