Copying a filtered spreadsheet into Word

[griff]

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!
Griff