+ Reply to Thread
Results 1 to 8 of 8

Columns & widths

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Columns & widths

    So here is my dilemma, attempting to use excel to make a nice printable check-in form for new arriving personnel. *I like excel for formatting purposes, but may need to resort back to word and insert multiple tables instead... but before I accept defeat, one last resort with a little Q&A

    I have default columns A-G with set widths for rows 1-14. *Now here's the problem...

    *I'd like to have rows 16-25 different column widths without affecting my widths for 1-14 (I don't want to merge and manipulate). *Is there a way to enter a new grid of columns into a single sheet? *Ideally, it would be perfect if I could to insert 3, 4 or even 5 new column grids for altering cell sizes without changing cell sizes "above" the new inserted column... fairly basic what I'm asking, but confusing on how to word.

    Anyways, if this makes somewhat sense and you have a solution, thank you!!

  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: Columns & widths

    I have default columns A-G with set widths for rows 1-14.
    Columns have width; rows have height.

    Not sure what you're asking, but rows are the same height across the width of a sheet, and columns the same width all the way down.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Columns & widths

    If you don't merge, then I don't believe so.
    ~~LaffyAffy13~~

    If I have helped you solve your problem, please be sure to click at the bottom left of my post.

    Thanks.

  4. #4
    Registered User
    Join Date
    07-31-2013
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Columns & widths

    Thank you, same page as you... I've tried everything lol

  5. #5
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Columns & widths

    Not sure what you're asking
    I believe smoothbeaver is saying that he/she has a width set for each column, and wishes to keep that width for rows 1-14 and change that width for the next few or so rows. Which is not possible unless merging is used.

  6. #6
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Columns & widths

    You can, however, place a picture of your cells underneath rows 1-14. But, that does not allow for editing. So... I guess either merge the cells or use the picture method. If this is only for printing, then the picture will work fine. So save the data you take a picture of in another sheet to preserve it. And then you can edit it and change the picture whenever you want.

  7. #7
    Registered User
    Join Date
    07-31-2013
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Columns & widths

    Quote Originally Posted by LaffyAffy13 View Post
    I believe smoothbeaver is saying that he/she has a width set for each column, and wishes to keep that width for rows 1-14 and change that width for the next few or so rows. Which is not possible unless merging is used.
    Exactly (and I'm a guy) - thanks again

  8. #8
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: Columns & widths

    Sounds good. Hopefully you can find a way around it. Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] User Form ListBox Column Widths - How to set widths for unknown number of columns
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2013, 05:24 AM
  2. [SOLVED] Can I have multiple columns widths within a column?
    By heather in forum Excel General
    Replies: 5
    Last Post: 06-12-2006, 06:55 PM
  3. Fixing columns widths
    By mjennings in forum Excel General
    Replies: 0
    Last Post: 03-15-2006, 05:30 PM
  4. [SOLVED] Columns widths
    By JcR in forum Excel General
    Replies: 1
    Last Post: 03-14-2006, 11:55 AM
  5. How do I freeze the widths of columns?
    By SuzyR in forum Excel General
    Replies: 2
    Last Post: 01-14-2005, 04:06 PM

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