Single worksheet, multiple pages?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a single excel worksheet, and due to area's of the sheet I do not
want to have printed, (the data is to be printed onto pre printed forms),
have used the set print area option to exclude those area's.

The problem is now I have multiple pages inside a single worksheet. Each
page prints seperatly, so I end up with 5 pages with only a small amount of
the full worksheet on each.

Thanks in advance
Peter
 
Hi peter

i'm not sure what you're problem is - sounds like you've set it up and got
it working like you want - how would you like it to be different?

cheers
JulieD
 
Peter

My guess........

Hide the blocks of rows you don't want printed?


Gord Dibben Excel MVP
 
Hi, Peter;
If your worksheet already has the data you want to print in the right
positions for your pre-printed forms,try something like this: copy the
contents of that sheet and Paste Special> Formats into a new sheet. Then copy
and Paste Special> Paste Link from only the cells you want to print into the
matching cells on your new sheet. Then use that one for printing.
Regards,
IanRoy.
 
Hello again, and thankyou for the replies so far.
I wish it was as simple as just being able to hide the rows I don't need to
print, problem is 99% of the people about to use what I am doing have zero
computer skills..anything other then filling in a text box is out of the
scope for them.

Julie, I do have the page setup as it needs to be, it's just the printing
part that has me baffled. After I select the cells that need to be printed,
(in diffrent area's on the page) it breaks the single page into five small
pages. Using the Page break preview shows exactly that.

What I really need to be able to do, is select the cells required, and have
them all print to the same page in their current position. I was hoping there
was a macro or similar to allow this. I have tried everything I can think
of...

Regards
Peter
 
Thanks for the info Ron, it's just what I have been looking for.

Now another week to figure out the best way of implementing it all and i'm
set.

Regards
Peter
 
Hi Peter

sounds like Ron's solution worked - however, please feel free to post back
if you have any further queries.

Cheers
JulieD
 
You could also explore "Custom Views".

This feature allows you to save individual sections of a WB, hiding and even
changing some formats, and *also* saving individual print areas and
settings.
You could also place a window on the toolbar, displaying exactly which view
is "in force", and allowing navigation between views with a single click of
the mouse, therefore easily enabling a different print area setting.
 
Thanks for the tip Ragdyer.
And thankyou again to all who replied.
I hope this post will help someone else with a similar problem down the track.

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print preview/page set-up is printing 100's of blank pages 2
Printing single pages from multiple worksheets in a single print job 2
Print correct Page X of Y when printing single worksheet 3
Duplex Printing of Workbook with multiple worksheets 2
Page numbers on copies of a single page worksheet 1
Print worksheet 2 on back of worksheet 1, etc.... 1
How can I set some cells to not print w/o changing print layout? 1
Print area only works on my PC! 1

Back
Top