Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Can`t change page to landscape

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Yuba City, Ca.
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Yuba City, Ca.
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  5. #5
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    Yuba City, Ca.
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  9. #9
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 09:40, Brian from Maui wrote:
    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •