#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 44
Default sizing cells/tables

I got two tables in an excel sheet.
Is it possible to change the sizes of the cells in one table without
changing the cells in the other table? Is there a way to isolate the cells in
one of the tables from the other table?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default sizing cells/tables

Any rows or columns that are shared by the tables will be the same size in
both tables.

To 'isolate' the tables, you'll need to move one so that the two tables do
not share any row(s) or column(s).

"willy" wrote:

I got two tables in an excel sheet.
Is it possible to change the sizes of the cells in one table without
changing the cells in the other table? Is there a way to isolate the cells in
one of the tables from the other table?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,081
Default sizing cells/tables

In addition to JLatham's point, if you need the two tables to be stacked
vertically or aligned horizontally for printing purposes, then follow his
instructions first to set up your tables so they look right. When done, use
the Camera tool to copy one of the tables as a picture, then paste it next
to, or below, the other table.

You can also access the Copy as Picture command (i.e. the Camera tool) from
the Edit menu by (I think), holding down the Shift key when clicking on the
Edit menu. It's all different in XL2007 so I can't confirm that.

"willy" wrote:

I got two tables in an excel sheet.
Is it possible to change the sizes of the cells in one table without
changing the cells in the other table? Is there a way to isolate the cells in
one of the tables from the other table?


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
Draging formulas and sizing rows/cells Slyons Excel Worksheet Functions 1 March 11th 08 02:48 AM
Problem with preventing objects moving and sizing with cells Nichelle H. New Users to Excel 2 May 31st 07 04:17 AM
Automatically re-sizing merged cells LongTermNoob Excel Worksheet Functions 1 March 28th 07 10:42 AM
sizing different cells in same column cmkogos2 Excel Discussion (Misc queries) 2 May 2nd 05 09:48 PM
Sizing individual Cells Tom Excel Worksheet Functions 2 December 1st 04 06:01 PM


All times are GMT +1. The time now is 12:21 AM.

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

About Us

"It's about Microsoft Excel"