Hi,
When you use filter excel only arranges the data according to the user
specified criteria whereas the original data remains the same.When you do
delete entire rows the original data gets effected and gets deleted.If you
want to delete rows given by the filter after filtering select the
hi Guys,
have similar kinda que.
sometimes when we filter on large data and simply select those rows and delete
entire rows i.e. Alt+E+D+R
data which is present in those filtered rows also get deleted. what is the
reason behind this.
From: Ms-Exl-Learner .