02-27-2010, 08:55 PM
Hi,
In below ways, Only data would be removed from that rows & continues to be in Used Range Rows with no data.
Right Clicking on Data table values and -->Edit-->Clear-->All
OR
Edit-->Clear-->Contents
Hence you should Delete the entire rows along with data.
Hope you are clear now
In below ways, Only data would be removed from that rows & continues to be in Used Range Rows with no data.
Right Clicking on Data table values and -->Edit-->Clear-->All
OR
Edit-->Clear-->Contents
Hence you should Delete the entire rows along with data.
Hope you are clear now