Share via

Copying formula down a filtered column

Anonymous
2021-10-11T13:39:32+00:00

How can I copy a formula down a filtered column so that only those cells showing are affected?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2021-10-11T14:05:45+00:00

If your data is formatted as table, undo the automatic fill down:

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-10-14T09:46:07+00:00

    Hi SJW_1956:

    May I know whether there are any updates to your question? If you have any questions, please feel free to contact us.

    Tin

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-10-11T14:09:36+00:00

    Thank you Andreas.

    Was this answer helpful?

    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2021-10-11T14:00:36+00:00

    Use the Autofilter and filter the rows, fill the formula down as usual:

    Andreas.

    Was this answer helpful?

    0 comments