Excel Problem

[Region3]

I have a problem (ish) with Excel (2007). Normally I can solve problems searching the internet, but I've not been able to this time, so I'm hoping someone on the forum might be able to help.

I have a workbook that has multiple sheets, but some are portrait and some are landscape.

I need to print multiple sheets together and turn them into a booklet, so I select all the sheets I need printing and hit the print button.

In the booklet, the portrait pages want the binding on the left margin, and the landscape pages want the binding at the top. I hope that makes sense.

Everything prints fine, but I always have to manually turn the portrait pages around before I do the binding for the booklet to come out right.

Does anybody know how I can tell Excel (or my printer) to print either the portrait pages or the landscape pages the other way round?

It doesn't take ages for me to put it right manually, but it gets a bit boring when you do it lots of times a month.

Thanks

 

[rosecott]

Gary - I think I know what you are trying to do - but I may have got the wrong end of the stick.

If you click on the arrow on the bottom right hand corner of the "Page Set-up" block on the top menu, click on "options", click on the "Page Set-up" in the middle of the top menu, you can rotate your landscape pages through 180 degrees.

Try that anyway and see if it's what you need.

P.S. If it works, it will give you a bit more time to spend on the forum during working hours.

 

[DappaDonDave]

Right click the workbook and select all.

Then go to page setup and setup as portrait or landscape and fit to whatever number of pages you need. I usually do 1 wide by 1 high unless its a massive sheet

That should then apply these settings to all sheets and print perfectly

Should've read your post...think my advice is useless lol

If you use the same names got each worksheet you could record a macro when you are spinning the sheets and then save it. Then run the macro on the spreadsheet each time.

I use that for an invoice spreadsheet we get weekly, 1 button formats the sheet, removes unwanted columns and prints

 

[zlinuk]

Might be a setting in your print driver relating to binding edge.

 

[rosecott]

I have a problem (ish) with Excel (2007). Normally I can solve problems searching the internet, but I've not been able to this time, so I'm hoping someone on the forum might be able to help.

I have a workbook that has multiple sheets, but some are portrait and some are landscape.

I need to print multiple sheets together and turn them into a booklet, so I select all the sheets I need printing and hit the print button.

In the booklet, the portrait pages want the binding on the left margin, and the landscape pages want the binding at the top. I hope that makes sense.

Everything prints fine, but I always have to manually turn the portrait pages around before I do the binding for the booklet to come out right.

Does anybody know how I can tell Excel (or my printer) to print either the portrait pages or the landscape pages the other way round?

It doesn't take ages for me to put it right manually, but it gets a bit boring when you do it lots of times a month.

Thanks

Was there a prize for the best answer? If so, who won?

 

[Region3]

Was there a prize for the best answer? If so, who won?

Sorry, very rarely look at the forum over the weekend now due to the issue that only I appear to be bothered about lol

Just going to try the suggestions out now, but it might all be moot anyway.

The customer that this is for has butchered the report and only wants about half of it printing now!

 

[Region3]

Gary - I think I know what you are trying to do - but I may have got the wrong end of the stick.

If you click on the arrow on the bottom right hand corner of the "Page Set-up" block on the top menu, click on "options", click on the "Page Set-up" in the middle of the top menu, you can rotate your landscape pages through 180 degrees.

Try that anyway and see if it's what you need.

P.S. If it works, it will give you a bit more time to spend on the forum during working hours.

I think when you click options from the Excel page layout box, it takes you to print driver software.
I had a look, but mine didn't have the feature you mentioned.
Good shout though.

 

[Region3]

Right click the workbook and select all.

Then go to page setup and setup as portrait or landscape and fit to whatever number of pages you need. I usually do 1 wide by 1 high unless its a massive sheet

That should then apply these settings to all sheets and print perfectly

Should've read your post...think my advice is useless lol

If you use the same names got each worksheet you could record a macro when you are spinning the sheets and then save it. Then run the macro on the spreadsheet each time.

I use that for an invoice spreadsheet we get weekly, 1 button formats the sheet, removes unwanted columns and prints

Yeah, useless lol. I knew what you meant though and appreciate the thought.

I can't use a macro to spin the rogue sheet(s) though because I can't even find out how to do it manually.

I use the "1 sheet wide" option a lot, but usually remove the number from the "pages long" box to let Excel fit it to however many it needs while still keeping the 1 page width.

 

[Region3]

Might be a setting in your print driver relating to binding edge.

It appears that's my only hope, but I'll be damned if I can find it!

Maybe it doesn't have the option. It would certainly fit in with my long-standing opinion of HP.

 

[stevelev]

It appears that's my only hope, but I'll be damned if I can find it!

Maybe it doesn't have the option. It would certainly fit in with my long-standing opinion of HP.

If you go to print preview, then adjust the page setup for each page as you scroll through them. That way you can set up each page with a different orientation.

 

[DappaDonDave]

Does excel not have orientation like word?

Never tried tbh! I will tomorrow though!

 

[Region3]

If you go to print preview, then adjust the page setup for each page as you scroll through them. That way you can set up each page with a different orientation.

Does excel not have orientation like word?

Never tried tbh! I will tomorrow though!

Orientation isn't a problem. I have 3 worksheets landscape and 1 worksheet portrait, and they print in the correct orientation.

Imagine you have selected all the worksheets and hit the print button. When they have finished printing you pick all the pieces of paper up and hold them with your left hand at the top of the first page, which is landscape.
Now hold the pages as if they were a book in portrait orientation, the top of the first page is on the left and the bottom of the first page is on the right.

When you flick through the pages of the 'book' as you're holding it now, the portrait pages are upside-down.

I hope that makes more sense than how I tried to describe it before.

 

[DappaDonDave]

Orientation isn't a problem. I have 3 worksheets landscape and 1 worksheet portrait, and they print in the correct orientation.

Imagine you have selected all the worksheets and hit the print button. When they have finished printing you pick all the pieces of paper up and hold them with your left hand at the top of the first page, which is landscape.
Now hold the pages as if they were a book in portrait orientation, the top of the first page is on the left and the bottom of the first page is on the right.

When you flick through the pages of the 'book' as you're holding it now, the portrait pages are upside-down.

I hope that makes more sense than how I tried to describe it before.

How's about highlight all the data in the landscape pics, rotate the text 180 and then print. Surely this should be sufficient?

Or host the file on google docs or drop box and ill have a look at what you mean, it's usually easier than explaining lol

 

[Region3]

How's about highlight all the data in the landscape pics, rotate the text 180 and then print. Surely this should be sufficient?

Or host the file on google docs or drop box and ill have a look at what you mean, it's usually easier than explaining lol

It's easy to replicate the problem (feature!) without hosting it anywhere.

Create a new workbook with 2 worksheets.
Make sheet1 Portrait and put "left" in A28.
Make sheet2 Landscape and put "top" in H1.
Now select both sheets together and hit Print.
You want the text on both pages to be in a similar position when they come out of the printer. Mine are on opposite sides of the paper.

Thanks for being persistent
Maybe you are like me and hate being beaten by anything!