Removing filtered Blanks Cells

  • Thread starter Thread starter renu98
  • Start date Start date
If you delete blank cells (not rows), you risk damaging the data. For
example if you have a block of data, and one of the rows contains a
blank cell, and you try to delete that cell, the cells will either
shift up or left/right, making all of the cells below or to the left/
right shift out of place with the rest of the data.

--JP
 
If you delete blank cells (not rows), you risk damaging the data. For
example if you have a block of data, and one of the rows contains a
blank cell, and you try to delete that cell, the cells will either
shift up or left/right, making all of the cells below or to the left/
right shift out of place with the rest of the data.

--JP

Thanks for Giving the valuable Tips

Hardeep Kanwar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete blanks cells 1
combine sheets 3
Merge and Centre 1
How to Replace ? With Space 3
Restrict Duplicates using Data Validation 4
Sites for PowerPoint 2003 2
Pivot Table Sites 1
Short Cut keys 2

Back
Top