PDA

View Full Version : Pasting a filtered spreadsheet into Word



griff
12-20-2000, 11:12 AM
This was originally (inadvertently) posted to the hardware troubleshooting forum. Ooops...

This may be the quintessential newbie question... I've got data in an Excell 2000 spreadsheet, which I've filtered using autofilter. I want to copy the filtered sheet into Word, and keep the pagination and formatting. So far every attempt either puts the entire sheet (incl the stuff I want filtered out) in the document, or inserts the sheet like a picture. I've tried paste, paste special, insert file, insert object... no joy! Is there an easy way to get the result I want, or is this another case of the software knowing better than I what I want to do?

TNX for the help!
Griff

Paleo Pete
12-21-2000, 07:21 AM
Since you have replies there, I'll leave it, and lock this one. That way folks will only be trying to answer in one place.

------------------
Soon as I come up with all the answers...they change the questions!!

Computer Information Links (http://www.geocities.com/paleopete/)