ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get 2 tables (one below the other) with different sizes? (https://www.excelbanter.com/excel-discussion-misc-queries/98199-how-get-2-tables-one-below-other-different-sizes.html)

Carmen

How to get 2 tables (one below the other) with different sizes?
 
Hello everyone,

I would be grateful if you could help me with an issue that i´m struggling
with.
I have to have two tables in an excel sheet, one below the other (it is
necessary). The two tables are sharing columns, i.e., column A is the same
for each table, however i need one specific column to have a different size
for each table. ¿How can I do that?

Thank you very much and best regards,

Carmen
--
CSC

Toppers

How to get 2 tables (one below the other) with different sizes?
 
A column can only be a single width.

"Carmen" wrote:

Hello everyone,

I would be grateful if you could help me with an issue that i´m struggling
with.
I have to have two tables in an excel sheet, one below the other (it is
necessary). The two tables are sharing columns, i.e., column A is the same
for each table, however i need one specific column to have a different size
for each table. ¿How can I do that?

Thank you very much and best regards,

Carmen
--
CSC


starguy

How to get 2 tables (one below the other) with different sizes?
 

you can merge cells wherever required.

Carmen Wrote:
Hello everyone,

I would be grateful if you could help me with an issue that i´m
struggling
with.
I have to have two tables in an excel sheet, one below the other (it
is
necessary). The two tables are sharing columns, i.e., column A is the
same
for each table, however i need one specific column to have a different
size
for each table. ¿How can I do that?

Thank you very much and best regards,

Carmen
--
CSC



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=559592


Mark Ivey

How to get 2 tables (one below the other) with different sizes?
 
Here is one thought...

You could put the two tables on different sheets, edit them as needed, and then do a Copy Picture... of each table (press and hold the shift key and select edit to find this feature).

Paste the table pictures as needed (one above/below of the other), then link the table pictures to the actual tables (make sure the table picture is selected and type "=" in the formula bar, then select the range of cells that corresponds to that table). Any changes made to the original tables from this point on will show in the table pictures as well.

Hope this helps.

--
Mark Ivey
"Carmen" wrote in message ...
Hello everyone,

I would be grateful if you could help me with an issue that i´m struggling
with.
I have to have two tables in an excel sheet, one below the other (it is
necessary). The two tables are sharing columns, i.e., column A is the same
for each table, however i need one specific column to have a different size
for each table. ¿How can I do that?

Thank you very much and best regards,

Carmen
--
CSC


All times are GMT +1. The time now is 08:48 AM.

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