Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

How do I change column widths within idividual tables on the same.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jon6181 - 04 Sep 2004 06:11 GMT
I'm using xl 2000.  I want to place several tables on the same worksheet.  Is
it possible to change column widths of a table without affecting the column
width of the other tables.
Biff - 04 Sep 2004 06:37 GMT
Hi!

If the tables are one on top of the other, no. Both column
width and row height are constant for the entire column or
row.

A possible workaround would be to merge cells but that has
disadvantages.

Biff

>-----Original Message-----
>I'm using xl 2000.  I want to place several tables on the same worksheet.  Is
>it possible to change column widths of a table without affecting the column
>width of the other tables.
>.
Frank Kabel - 04 Sep 2004 08:55 GMT
Hi
no, not possible

Signature

--
Regards
Frank Kabel
Frankfurt, Germany


> I'm using xl 2000.  I want to place several tables on the same
> worksheet.  Is it possible to change column widths of a table without
> affecting the column width of the other tables.
Ken Wright - 04 Sep 2004 10:45 GMT
Would linked pictures of your tables work?

Copy one of your tables using normal Edit / Copy, then pick where you want to
put it on your new sheet, hold down SHIFT and then click on the EDIT menu where
you will now see an option of PASTE PICTURE LINK.  Hit that and you can then
resize the image if you wish.  Repeat for your other tables, and you will then
see that as data changes in the original tables it will also change in these
linked 'images'.

Might be an idea to remove gridlines as well, else it can look tacky.  Also
consider reomving gridlines from the sheets that contain your tables prior to
copying them.

Signature

Regards
          Ken.......................    Microsoft MVP - Excel
             Sys Spec - Win XP Pro /  XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> I'm using xl 2000.  I want to place several tables on the same worksheet.  Is
> it possible to change column widths of a table without affecting the column
> width of the other tables.
SIdBord - 05 Sep 2004 04:40 GMT
You might experiment with using merged cells.
>-----Original Message-----
>I'm using xl 2000.  I want to place several tables on the same worksheet.  Is
>it possible to change column widths of a table without affecting the column
>width of the other tables.
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.