Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    2000 (cell width)

    Any way to change the width of an individual cell without changing the width of the whole column?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (cell width)

    I don't think you can do this. Maybe, you can merge the cell with the cell next to it and play with that.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 2000 (cell width)

    I feared so-thanks!

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts

    Re: 2000 (cell width)

    You have nothing to fear.
    Merged cells are exactly what you need.
    You can combine adjacent columns (and rows if required) to create a cell of any width that is different from those above and below it. This is great for 'spreadsheet forms'. The trick is to start with all columns at a 'friendly' initial width. For example, set a new sheet with all columns set to 'width 4' - then merge your cells to create required columns of multiples of 4, then within that column you can also have cells of 'different' widths.

    zeddy

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 2000 (cell width)

    Thanks, Zeddy. Care to contribute re my data consolidation problems (especially the prompts)?
    Thanks,
    Jeff

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts

    Re: 2000 (cell width)

    I've just downloaded your file and will look at it later.
    Hope to get back to you soon but I have a five-hour meeting in the local pub.

    zeddy

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 (cell width)

    Is Toontown having a Bank Holiday on May Day itself - as well as next Monday? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Gre

  8. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts

    Re: 2000 (cell width)

    Every day is a holiday here! I've just woken up.

    zeddy

Posting Permissions

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