Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 8th 06, 11:23 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1
Default 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

  #2   Report Post  
Old July 8th 06, 01:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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

  #3   Report Post  
Old July 8th 06, 02:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1
Default 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

  #4   Report Post  
Old July 8th 06, 03:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 25
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
How do I keep file sizes small when using multiple pivot tables? jester1072 Excel Discussion (Misc queries) 2 June 6th 05 06:43 PM
How to pull numbers from two tables with conditions? Anna Excel Worksheet Functions 1 May 14th 05 03:21 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 10:53 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017