2 Different spreadsheets on 1 page?

[Steph Lichtman-Price]

I am reproducing a court financial statement into Excel and need to know if
it is possible to create two or more spreadsheets (or tables) with varying
column widths onto one page, and if so, how? The purpose is for attorneys to
be able to input the client financial data directly into the worksheet and
have it calculate the totals. Thank you!

 

[IC]

Not sure what you mean here, but there is nothing to stop you having 2
distinct sets of cells within one sheet.

Ian

 

[Harlan Grove]

I am reproducing a court financial statement into Excel and need to know
if it is possible to create two or more spreadsheets (or tables) with
varying column widths onto one page, and if so, how? The purpose is for
attorneys to be able to input the client financial data directly into the
worksheet and have it calculate the totals. Thank you!

If you mean can you have multiple sections underneath each other in a
worksheet have different column widths, then no, not possible. While it
would be possible to merge cells to produce the appearance of different
column widths, merged cells make many calculations quite difficult.

 

[Steph Lichtman-Price]

Thanks for the reply. How do I go about merging the cells? I don't need to
do calculations in the cells that would be merged...I just need to double the
widths of some existing columns of text.

 

[Bill Sharpe]

Tell the attorneys to click on the tabs at the bottom of the worksheet
to move to their particular table, which will be on another sheet.

Well, maybe ask the attorneys to do that, politely.

Other solution may be to put the tables side by side instead of under
one another. Then you can vary the column widths as desired. Works if
total columns required doesn't exceed 256.

Bill

"Steph Lichtman-Price" <Steph (e-mail address removed)>
wrote in message
I am reproducing a court financial statement into Excel and need to know
if
it is possible to create two or more spreadsheets (or tables) with
varying
column widths onto one page, and if so, how? The purpose is for
attorneys to
be able to input the client financial data directly into the worksheet
and
have it calculate the totals. Thank you!

 

[IC]

Select the cells you want to merge then Format - Cells - Alignment - Merge
cells - OK.

Ian

 

[Steph Lichtman-Price]

Ian -

Thank you!

- Steph

Select the cells you want to merge then Format - Cells - Alignment - Merge
cells - OK.

Ian

 

[Steph Lichtman-Price]

Bill -

Thanks for the advice. Unfortunately, because it is a Court form, it has to
be in a specific format (and side by side tables aren't it!)

Thanks again!

- Steph