Formatting Excel 2010, Excel 2003

Hello,

I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything :shock:

Thank you

If I understand the problem

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.

Cheers

@jimbo45

You say:

"Not sure what the problem is Here's a reasonable Complex spreadsheet -- no probs with Cell titles or whatever. (My version is the Office Pro version 32 bit although I'm on W7 x-64).
Cheers
jimbo"

thanks. I would check out your example only when I click the link in Gmail:

This thread is located at:
Formatting Excel 2010, Excel 2003 - Windows 7 Forums

I get this:
http://img832.imageshack.us/img832/5223/sevenforums.jpg
and cannot get at it.

This gets mysteriouser and mysteriouser. Perhaps I should get off the subject before my PC explodes?
Then again, that would solve the problem

bigtel49 said:

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.
Cheers

Click to expand...

Thanks bigtel49, that sounds right; it may well be just what the doctor recommended.

I wish I were more articulate; I know what I mean most of the time, but looking back at previous posts I see 'what a tangled web' I have woven.

That is why I almost always attach or else link to an image I think might be helpful.

Again thank you bigtel49 and all who have pitched in, I am in your debt for true.

Greetz

Hope it works

Hope it works

Bigtel

bigtel49 said:

Hope it works

Bigtel

Click to expand...

Time will tell. I'm saving that for tomorrow, as the time here (Sweden) is now 2:10 am, and my a** is sore from sitting at the PC some 12-14 hrs today.

As you may have guessed, this question here isn't the only thing I'm involved in, there's a gazillion things, give or take.

It's great fun but now I'll take a dive before I fall to the floor.

If you would like, Ill follow up tomorrow (in, say, 10 hrs) how's that?

I have gathered lots of tips today - a good thing too as the finished Excel sheet (of which this cell-merging thingy is only small part)
is due at work on tuesday.

Or else. As my employer :devil: likes to say whenever work conditions are discussed: "one always has the option of unemployment".

Seeyabye!
Göran