ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   having a two tables on the same page with different widths (https://www.excelbanter.com/excel-worksheet-functions/45273-having-two-tables-same-page-different-widths.html)

southerntwangqt

having a two tables on the same page with different widths
 
I want to make two table charts but I can't have two different widths for
their colums. So where on table has to have 1 skinny colum and on wide
column, the table below it has to be the same. I want to be able to adjust
the widths for different tables on the same page. I even tried cutting and
pasting a table I created on a separate page and it still formatted it to the
width of the existant table. HELP ME PLEASE...THANKS

Dave Peterson

If you put one table in (say) columns A:E and the other in G:M, you can set the
columnwidths the way you want--but you'll have trouble with rowheights.

If I were you, I'd put each table on a dedicated worksheet. It makes making
changes much easier and safer -- deleting a column won't be a disaster to the
other table.

southerntwangqt wrote:

I want to make two table charts but I can't have two different widths for
their colums. So where on table has to have 1 skinny colum and on wide
column, the table below it has to be the same. I want to be able to adjust
the widths for different tables on the same page. I even tried cutting and
pasting a table I created on a separate page and it still formatted it to the
width of the existant table. HELP ME PLEASE...THANKS


--

Dave Peterson

southerntwangqt

Thank you. I put the other chart on a dedicated worksheet #2. I used Sheet 2
and still under the same file name

"Dave Peterson" wrote:

If you put one table in (say) columns A:E and the other in G:M, you can set the
columnwidths the way you want--but you'll have trouble with rowheights.

If I were you, I'd put each table on a dedicated worksheet. It makes making
changes much easier and safer -- deleting a column won't be a disaster to the
other table.

southerntwangqt wrote:

I want to make two table charts but I can't have two different widths for
their colums. So where on table has to have 1 skinny colum and on wide
column, the table below it has to be the same. I want to be able to adjust
the widths for different tables on the same page. I even tried cutting and
pasting a table I created on a separate page and it still formatted it to the
width of the existant table. HELP ME PLEASE...THANKS


--

Dave Peterson



All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com