copy and paste

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Boy did they SCREW UP the copy paste
in the new office
if you try to copy every third row in excel
then paste to notepad
you get everything between the first row to the last row
picked

GREAT JOB MS
 
That's the way xl2002 works, too.

(I don't recall how xl97/xl2k behave.)

But maybe you could hide the rows in between--manually or via autofilter and
then copy those visible cells.

If your discontiguous range is created via data|subtotals, select your range
with the details hidden, then Edit|Goto|Special and check Visible cells.

Copy and then 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 & past row to column 4
Copy and paste to the last row 3
pasting content copied from nonadajacent cells 1
Copy & Paste Macro 0
Copy & Paste 2
copy/paste row with one formula 6
how to copy and paste a row inverted 2
Copying data to the next blank row 0

Back
Top