Pasting Visible Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a filtered list and I want to copy and paste only the visible cells to
a new worksheet. Help Please!!!???
 
If you're using xl97+, then just selecting those visible rows and copy|pasting
should be sufficient.

If you're using xl95, then you have to select the range first,
then edit|goto|special|visible cells only

Then copy|paste.
 
You must log in or register to reply here.

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 PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
To paste copied data in filtered/visible cells only 1
Paste Special Values 2
Pasting into a filtered sheet 3
Paste to Visible Cells only 1
How to copy and paste only visible cells from Excel using vbscript 0
drag data vertically over hidden cells.. ignore hidden cells 1
I copied Visible Cells Only, but it pastes only the first cell 1

Back
Top