Results 1 to 3 of 3

Thread: Set fixed no. of columns in Excel

  1. Apr 4th, 2006, 01:00 AM #1
    LouvGeek
    LouvGeek is offline

    Thread Starter
    New Member
    Join Date
    Feb 2006
    Posts
    10

    Set fixed no. of columns in Excel

    When I open my Excel at one PC, there are 9 columns within the sheet (A to I). at another PC, my sheet shows 8 columns (A to H). Thus, the alignment of my report is messed up. Is there a way to set a fixed number of columns in an Excel sheet?
    Reply With Quote Reply With Quote
  2. Apr 4th, 2006, 08:01 AM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Set fixed no. of columns in Excel

    No, it all depends on screen resolution. E.g. on my 30 inch flat panel I can see 28 rows (A to AB)
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. Apr 4th, 2006, 09:06 AM #3
    Webtest
    Webtest is offline
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: Set fixed no. of columns in Excel

    You can set the View Zoom % or hide columns or both. Does this help?
    Code:
    ActiveWindow.Zoom = 50  'View Zoom 50%
Columns("J:IV").EntireColumn.Hidden = True
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width