Hi,
Once upon a time... I was very happy to learn about the "copy only visible cells" when I've filtered down a filter. Now Excel copies that way by default everytime I copy multiple rows when I've filtered. But NOW I want to copy everything that is hidden between the filter as well, i.e. how it did it before.
How can I tell Excel to do that?
Thank you!!
Emma
hi Emma. not sure if there's a faster way. but you could CTRL + C to copy -> CTRL + V to paste -> CTRL + Z to undo -> CTRL + V to paste again. so it's 2 steps extra. it's an unusual situation for people to do that though
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi!
Hmm yea that works. Which is weird. What makes Excel paste is right the second time...? And yea, that's a long process to perform if you want to copy like that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks