Share via

Paste only on visible cells on a table column is not working!

Anonymous
2024-05-09T11:41:51+00:00

Hello there! I am having issues with pasting on a filtered column (only on the visible cells). I am using excel for mac. I have used control+G then selected only on visible cells and finally command+V but nothing is working. Every time is pasting consecutively instead of the visible cells. Any suggestions for why this might happen???? I am using Excel Version 16.84

Microsoft 365 and Office | Excel | For home | MacOS

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

Anonymous
2024-05-09T12:07:02+00:00

If you want to copy data from discontinuous range to continuous range. It will work.

If you want to copy data from discontinuous range to discontinuous range. It will not work.

Result

Workaround:

  1. Filter destinate range.

  1. Put any value to another cell and copy that value to the visible range.

  1. Unfilter all the data and sort the column B

4 Now you can copy discontinuous range to continuous range like this one.

  1. Sort the column A to get final result.

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2024-05-09T12:59:42+00:00

Both windows and mac have same limitation.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-09T12:53:03+00:00

    The workaround worked! thank you for helping out!
    Just seems like a long winded process and i am surprised that there is no other alternative? Is this issue only for macs?

    Was this answer helpful?

    0 comments