View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


Scudo Wrote:
On a spreadsheet due to the size of it takes 5 pages to print it off.
Currently I `set` each page as a print area then print so I have to do
this
5 times in order to print off the full spreadsheet page. Is there a way
to
press `print` and it will print off the 5 pre set `print areas` ?
without me
having to go throught the `set print area` / `print`/`clear print area`
then
reset for next section.

thanks


Hi Scudo

Try View Page Break View


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397124