report output format

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.

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" <Tim3057.21q6by_1137411002.2183@excelforum-nospam.com> wrote in
message news:Tim3057.21q6by_1137411002.2183@excelforum-nospam.com...
>
> 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
>