Share via

Copy/Paste only visible selected cells - Excel for Mac

Anonymous
2020-08-11T20:42:59+00:00

How can I make this work? When i select only visible cells, copy and paste, it pastes the unhidden cells. Super frustrating and I can't find any fixes online. Surely there is a way?

Microsoft 365 and Office | Excel | For home | 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
  1. Bob Jones AKA CyberTaz MVP 430.5K Reputation points
    2020-08-11T22:10:46+00:00

    Once you select the range go to Edit> Find> Go To - Special & select the Visible Cells Only option then copy. [Note: If you need to do this frequently a keyboard shortcut can be assigned to the Select Visible Cells command which also can be added to the Ribbon as well as to the QAT.

    23 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2020-08-12T18:10:49+00:00

    This is a standard warning that I give whenever I see a thread had a message from a support scammer. You may have not seen the message (it was deleted from the forum), but if you had subscribed to the thread you would have received an email with the scam message. Just in case, here's my warning:

    Do NOT respond to replies asking you to contact Microsoft Support, Executive, agent, tech, MVP, advisor or anyone else.

    No legitimate person or entity will ever ask you to call or contact them. Do not call phone numbers. Do not reply to email messages. Do not click links to phony agents in your web browser.

    Questions and comments are answered in the forums themselves, not elsewhere.

    A request asking you to contact someone is fake. It is an attempt to take over your computer, steal your data, your money and your identity.

    Protect yourself from phishing schemes and other forms of online fraud - Office Support

    0 comments