Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Custom Views Col Widths (2000 & 2002)

    According to the MicroSoft Help when you create a custom view one of the features is to includes the Column Widths and Row Heights.
    I have tried several times to save custom views with different column widths and or row heights and it did not work. I tried this on Excel 2000 and 2002 version and have the same results. Does anyone know more about this matter?

    Regards,
    TD

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Views Col Widths (2000 & 2002)

    AFAIK, only the Excel 2000 help claims that row heights and column widths are saved in a custom view, and this is incorrect - they aren't. I couldn't find such a claim in the Excel 2002 help. Also see this newsgroup thread.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Custom Views Col Widths (2000 & 2002)

    Hans: Thank you for confirming my observation.

    On my version of Excel 2002 if you View > Custom Views and then click the question mark (help) and select the Add button; Microsoft once again declares that rows and columns are part of view, however as you have stated this is not true.


    Regards,

    TD

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Views Col Widths (2000 & 2002)

    In Excel 2002, the Add dialog for custom views has a check box to include the settings for hidden rows and columns and for filters. That is correct: the hidden status for rows and columns is saved in custom views, and restored if you activate them. But otherwise, row heights and column widths are left as they are.

Posting Permissions

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