Data is not appear in drop dawn list in filter
Closed
Manoj
-
19 Feb 2015 à 06:49
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 Feb 2015 à 18:05
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 Feb 2015 à 18:05
Related:
- Data is not appear in drop dawn list in filter
- Counter strike 1.6 cheats list - Guide
- Epic games free games list - Guide
- How to reset safe folder password without losing data in vivo ✓ - Android Forum
- Mint mobile data not working ✓ - Network Forum
- Wow equipment drop off ✓ - Network Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
19 Feb 2015 à 18:05
19 Feb 2015 à 18:05
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.