how to copy visible cells data only.

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

Guest

i need to copy only the data that is visible and want to
ignore the hidden cells data. can any one help

thanks,

immu
 
Try ..

Press F5 > Special > Visible Cells only > OK
Then copy > paste to destination sheet
 
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

drag data vertically over hidden cells.. ignore hidden cells 1
To paste copied data in filtered/visible cells only 1
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
How to copy and paste only visible cells from Excel using vbscript 0
Copying and pasting to visible cells only 4
paste and hide cells 1
Paste to Visible Cells only 1

Back
Top