formating cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to format an excel document. There are various tables on one worksheet (this is my requirement), I would like to find out how to format the cells for different tables in a way that they will not affect others i.e. in a way that cells which are bigger in one table will not affect cells which are smaller in another.
Please revert at the earliest
 
Nadia,

You can't have varying width cells within the same column. All
cells in a column must be the same width. Similarly, all cells
within a row must have the same height.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


nadia said:
I am trying to format an excel document. There are various
Click to expand...
tables on one worksheet (this is my requirement), I would like to
find out how to format the cells for different tables in a way
that they will not affect others i.e. in a way that cells which
are bigger in one table will not affect cells which are smaller
in another.
 
Hi

And in general it isn't a good idea to have several tables on same worksheet
(and it isn't only because it's cumbersome to access them you when you have
to scroll down or to right for it)
1. You can't use autofilter feature for tables, placed vertically, exept for
single one
2. You can't delete entire row(s), when there are additional tables to
right/left
3. Deleting a range in some table can mess up hopelessly formulas in all
your tables on worksheet at once
 
Back
Top