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.
>.