Copy only visible cells

K

Ken Wright

Select the range you can see and do Edit / Go To / Visible Cells only, then do Edit / Copy and
then Edit / Paste wherever you like.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Visio shape text disappears upon copy paste 1
Visible cells 1
Need Help with a VBA subroutine 0
Paste to excel from word - auto format problem 1
Merging from an Excel file with graphics 1

Top