+ Reply to Thread
Results 1 to 4 of 4

Combine cells for user input/print friendly output

  1. #1
    Registered User
    Join Date
    09-25-2009
    Location
    Kansas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combine cells for user input/print friendly output

    Go easy on me, I'm new here and I'm not really sure how to ask this so it's clear...

    I need to have cells that are varying width that won't effect the width of the cells in the row below them, so: A1 may be 20 pixels wide, B1 may be 40px wide, C1 - 30px wide. THEN A2 - 40px, B2 - 30px, C2 - 20px.

    Yes, I'm trying to create something that would be better suited for a design package, but I need the data functionality of Excel, then be able to print a nice looking result.

    Is this possible?

    Thanks in advance.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combine cells for user input/print friendly output

    Welcome to the forum.

    I need to have cells that are varying width that won't effect the width of the cells in the row below them
    Not in Excel. Columns are the same width throughout the column, rows are the same height throughout the row.

    Someone will suggest creating narrow columns and merging cells to achieve the appearance. Don't do it if there are any downstream dependencies on the contents. There are hundred of threads in the forum from people trying to solve problems caused by merged cells, and the answer is universal: don't.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-25-2009
    Location
    Kansas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Combine cells for user input/print friendly output

    Thanks for the reply, shg.

    What would you consider a downstream dependency?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combine cells for user input/print friendly output

    Any formula or code that references one of those cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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