Having applied a filter to the spreadsheet, and set up the print format
with headers and footers, Excel produces a nice print-ready document.

Is there an easy way to save this format so I can email the document
produced? All I seem to be able to save (or attach to an email) is the
entire spreadsheet.


--
Tim3057
------------------------------------------------------------------------
Tim3057's Profile: http://www.excelforum.com/member.php...o&userid=30403
View this thread: http://www.excelforum.com/showthread...hreadid=501619

Select all the cells you want copied,
copy and paste them to a second single sheet workbook and send that.

When you copy cells with filtered data, only the visible rows are copied.

--
Regards,
Tom Ogilvy

"Tim3057" wrote in
message ...

Having applied a filter to the spreadsheet, and set up the print format
with headers and footers, Excel produces a nice print-ready document.

Is there an easy way to save this format so I can email the document
produced? All I seem to be able to save (or attach to an email) is the
entire spreadsheet.


--
Tim3057
------------------------------------------------------------------------
Tim3057's Profile:
http://www.excelforum.com/member.php...o&userid=30403
View this thread: http://www.excelforum.com/showthread...hreadid=501619