+ Reply to Thread
Results 1 to 10 of 10

Issues with Views on a worksheet.

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Angry Issues with Views on a worksheet.

    Hi Guys,

    Sorry I am pulling my hair out on this one and I can't find the right verbiage to google the answer. So I have a workbook with a number of worksheets on it. Now my first worksheet comes out exactly what I am hoping to see, but the next and subsequent worksheets I am getting a page break on the right and it starting to display the next column, I just can't figure out how to set and keep the good view. If you take a quick look at the attached screenshots it should give you an idea of what I am blathering on about. Any help is greatly appreciated.

    Thanks guys and gals,
    Vik
    Attached Images Attached Images
    Last edited by vikd; 03-27-2013 at 09:53 AM.

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Maybe increasing the zoom will help?
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Seems your workbook thinks there is something in Col R (what happened to Q?). Does anything overflow into that region?
    Select Col R and CNTRL + SHIFT + RIGHT ARROW to select all columns to the right. Right click in the range and "Delete" Then save and close the workbook and reopen it. Did the view improve?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    vikd,

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    03-24-2013
    Location
    Earth
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    81

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Hi , Vikd

    look like you change page view style

    pls try following

    in excel 2007

    switch toolbar in view > change view style from page view to normal view , left side first one button .

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Careless,

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

    If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

  7. #7
    Registered User
    Join Date
    03-26-2013
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Tried that no luck there.

  8. #8
    Registered User
    Join Date
    03-26-2013
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Thanks ChemistB no luck there. Col Q is displayed on the second non working worksheet.

  9. #9
    Registered User
    Join Date
    03-26-2013
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I am doing something wrong with the views but I am not sure what I am doing wrong.

    Thanks Careless but it messes with the views further.
    normal view.jpg

  10. #10
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Issues with Views on a worksheet.

    Thanks for changing the title.
    Can you upload the spreadsheet (Go Advanced>Manage Attachments). Clear out any confidential data first.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1