Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Formatting Excel 2010, Excel 2003


05 Jun 2011   #1

Windows 7
 
 
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

Thank you



Attached Thumbnails
Formatting Excel 2010, Excel 2003-excel-en.jpg  
My System SpecsSystem Spec
.

05 Jun 2011   #2

Windows 7 Ultimate x32
 
 
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
My System SpecsSystem Spec
05 Jun 2011   #3

Windows 7
 
 
@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 Windows 7 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
My System SpecsSystem Spec
.


05 Jun 2011   #4

Windows 7
 
 

Quote   Quote: Originally Posted by bigtel49 View Post
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
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
My System SpecsSystem Spec
05 Jun 2011   #5

Windows 7 Ultimate x32
 
 
Hope it works

Hope it works

Bigtel
My System SpecsSystem Spec
05 Jun 2011   #6

Windows 7
 
 

Quote   Quote: Originally Posted by bigtel49 View Post
Hope it works

Bigtel
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 likes to say whenever work conditions are discussed: "one always has the option of unemployment".

Seeyabye!
Göran
My System SpecsSystem Spec
Reply

 Formatting Excel 2010, Excel 2003




Thread Tools



Similar help and support threads for2: Formatting Excel 2010, Excel 2003
Thread Forum
Solved Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003 Microsoft Office
problem saving excel spread sheet in 2010 to 97-2003 format Microsoft Office
Microsoft Excel 2010 - chart formatting question Microsoft Office
Excel 2003 quits Microsoft Office
Excel 2003 Macro Help? Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 09:10 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33