Copy visible cells only

G

Guest

Using Excel 2000, I need to copy only visible cells in excel (there are
hidden rows and columns in this spreadsheet) into a Word document.

The Edit, Go To, Special, Visible cells only, then copy and paste works
fine, as long as I stay in excel (it doesn't work to paste into word
directly) for rows, except for rows that precede hidden columns. However,
the last column, which has SUM formulas, does paste!

I'm just about ready to give up and take a snapshot to paste into Word!
 
D

Dave Peterson

I just tried this in xl2003 and it worked the way you wanted.

I don't have xl2k anymore, but maybe as a workaround, you could paste into a
temporary worksheet, then just copy from there and paste into MSWord.
 

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
Paste Special Values 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Is it possible paste to visible cells only? 2
Copying and pasting to visible cells only 4
Paste to Visible Cells only 1
Pasting into a filtered sheet 3
Copy/Paste Visible cells only 1

Top