Copy filter to multiple sheets in excel.

By mick28mx ·
Hello group,
I have the following question:

I have a workbook in excel 2010 with 3 worksheets. On each one I have data in five columns that I need to filter with some criteria.

At this time, on each sheet I put the same filter on each worksheet. This is, I did the same three times.

Is there any way to copy the same filter from worksheet 1 to the other two, without typing on each one?

I know that I can copy all the data in one sheet and do the filtering thing once. But, due to the number of records this can??t be done.

Thank you in advance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Re: Copy filter to multiple sheets in excel.

by saffagirl In reply to Copy filter to multiple s ...

Hi Mick28mx,

If I am reading your original question correctly, you should be able to just copy the cells, columns or rows containing your filter and paste it into the new worksheet. Alternatively you could just make a copy of the worksheet and remove the rows you no longer need thereby leaving the filter in place.

Saffa Girl

Related Discussions

Related Forums