Can`t change page to landscape

rdrum · Apr 11th, 2002, 10:20 PM

I have 3 portrait pages on a sheet, I`m trying to start a 4th sheet landscape. When I change to landscape, all my pages on the sheet change to landscape, Help!!!

Brian from Maui · Apr 12th, 2002, 09:18 AM

Quote:

On 2002-04-11 21:20, rdrum wrote:
I have 3 portrait pages on a sheet, I`m trying to start a 4th sheet landscape. When I change to landscape, all my pages on the sheet change to landscape, Help!!!

How are you adding the 4th sheet. If it's Edit/Move or Copy sheet, the page setup will be what you copied. Try Insert/Worksheet. In any event all the worksheets shouldn't be changing to landscape. What version of Excel do you have?

rdrum · Apr 12th, 2002, 10:07 AM

Maybe I`m saying this wrong. I don`t want my new page on a separate sheet, I want it one page portrait and one page landscape on the same sheet.

AJ · Apr 12th, 2002, 10:11 AM

Sorry mate, almost positive that you can't do that. You'll have to have the pages on separate sheets.
Unless of course you had a macro to print the sheet which first set the page as portrait and printed a certain print area, and then changed it to landscape and printed that print area.

Brian from Maui · Apr 12th, 2002, 10:15 AM

Quote:

On 2002-04-12 09:07, rdrum wrote:
Maybe I`m saying this wrong. I don`t want my new page on a separate sheet, I want it one page portrait and one page landscape on the same sheet.

Just curious, why would you want that?

rguevara · Apr 12th, 2002, 10:22 AM

I have a list with 20 names but there are only 4 names that are repeated several times.
I Want to count only the names that arent repeated. How can I do that????
Sorry my english i dont speak very well.

Brian from Maui · Apr 12th, 2002, 10:26 AM

Quote:

On 2002-04-12 09:22, rguevara wrote:
I have a list with 20 names but there are only 4 names that are repeated several times.
I Want to count only the names that arent repeated. How can I do that????
Sorry my english i dont speak very well.

rguevara

Click on New Topic and start a new thread for your question.

rdrum · Apr 12th, 2002, 10:26 AM

Thanks for the answers, it is a daily business form, one is info and the other one is a graph. If they were on one sheet, I could simply add a new sheet each day and change only the info that has changed.

Brian from Maui · Apr 12th, 2002, 10:40 AM

Quote:

On 2002-04-12 09:26, rdrum wrote:
Thanks for the answers, it is a daily business form, one is info and the other one is a graph. If they were on one sheet, I could simply add a new sheet each day and change only the info that has changed.

Are you printing this form? If not, it shouldn't matter whether the worksheet is portrait or landscape.

Ian Mac · Apr 12th, 2002, 10:45 AM

Quote:

On 2002-04-12 09:40, Brian from Maui wrote:

Quote:

On 2002-04-12 09:26, rdrum wrote:
Thanks for the answers, it is a daily business form, one is info and the other one is a graph. If they were on one sheet, I could simply add a new sheet each day and change only the info that has changed.

Are you printing this form? If not, it shouldn't matter whether the worksheet is portrait or landscape.

It has already been pointed out that he is printing it! that's the question isn't it?

As far an answer goes, you'll have to do it with VB, I'm affraid I'm not the person to do this.

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-04-12 09:46 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 10:20 PM	#1
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	I have 3 portrait pages on a sheet, I`m trying to start a 4th sheet landscape. When I change to landscape, all my pages on the sheet change to landscape, Help!!!

Apr 12th, 2002, 10:07 AM	#3
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	Maybe I`m saying this wrong. I don`t want my new page on a separate sheet, I want it one page portrait and one page landscape on the same sheet.

Apr 12th, 2002, 10:11 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Sorry mate, almost positive that you can't do that. You'll have to have the pages on separate sheets. Unless of course you had a macro to print the sheet which first set the page as portrait and printed a certain print area, and then changed it to landscape and printed that print area.

Apr 12th, 2002, 10:22 AM	#6
rguevara New Member Join Date: Apr 2002 Posts: 8	I have a list with 20 names but there are only 4 names that are repeated several times. I Want to count only the names that arent repeated. How can I do that???? Sorry my english i dont speak very well.

Apr 12th, 2002, 10:26 AM	#8
rdrum New Member Join Date: Mar 2002 Location: Yuba City, Ca. Posts: 16	Thanks for the answers, it is a daily business form, one is info and the other one is a graph. If they were on one sheet, I could simply add a new sheet each day and change only the info that has changed.