+ Reply to Thread
Results 1 to 2 of 2

Adjusting individual column widths on the same sheet?

  1. #1
    Registered User
    Join Date
    11-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    82

    Adjusting individual column widths on the same sheet?

    Hi guys,

    I have multiple tables of data on a excel sheet as shown here:

    screenshot.2980.png

    Is there a way with excel to edit individual column widths for each table on the same sheet?

    Right now, if i edit a width it will obviously change the width for all table.

    Any suggestions will be very much appreciated!

    Cheers.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Adjusting individual column widths on the same sheet?

    Columns in Excel can only have a single width for all rows in that column. You can create the appearance of varying column widths & row heights by merging cells. Where practical, text can also be centred across multiple columns without the need for merging.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Replies: 2
    Last Post: 11-05-2015, 11:58 AM
  2. [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
  3. Fixing column widths in part of a sheet
    By Blakeydaman in forum Excel General
    Replies: 1
    Last Post: 09-21-2012, 06:23 AM
  4. Adjusting uneven column widths according to the data
    By shankar.nstl in forum Excel General
    Replies: 1
    Last Post: 09-04-2011, 09:57 PM
  5. column widths when copying to another sheet
    By ozzie4x4 in forum Excel General
    Replies: 1
    Last Post: 02-22-2011, 03:54 AM
  6. Set column widths to match specified sheet
    By Sean Bartleet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2005, 08:10 AM
  7. [SOLVED] Can you set Individual Cell Widths ??
    By tmb in forum Excel General
    Replies: 3
    Last Post: 04-10-2005, 12:07 PM

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