formating issue

M

minimus

Hello,

I use excel 07.

I have an excel sheet. On the sheet I have tables spread vertically and not
horizontally.
That is, I have three tables placed beneath each other.
Now, If i play around with the width of a column, of course the width of the
cells on the same column chnage accordingly.
This is what i dont want it to happen. I want to arrange cells widths
independent from each other, while at the same time the keep other tables'
cell widths fixed.
Now you will suggest to put tables horizontally and change widths then.
The problem is that I copy and paste the tables to word. in the word file
tables will be placed vertically.
hence, I want to arrange tables in excel the tables vertically placed
because this tells me already how they will look like in word.

Put in other words: I somehow want to split the excel sheet into several
parts and be able to change column widths indepenent from one another
 
R

rewb2

I don't think there's any way of genuinely splitting the worksheet
into separate sections (with separate widths). Given that you clearly
don't want to have these presented horizontally, and therefore I
assume won't want the tables to appear on different worksheets either,
I would suggest using merged cells.

Depending on the layout of the tables you are working with, you should
be able to merge cells within each table such that you can have
columns with different widths between the tables (although the overall
Excel columns will of course be the same throughout). As an example,
you could have very narrow columns (e.g. columns with width of 1) and
merge quite a few cells together for each 'cell' within each of the
three tables, thereby giving you a reasonable amount of flexibility as
to how wide each table column is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top