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
Sinsemilla

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
-excel-en.jpg  
My System SpecsSystem Spec
05 Jun 2011   #2
bigtel49

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
Sinsemilla

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 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
My System SpecsSystem Spec
05 Jun 2011   #4
Sinsemilla

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
bigtel49

Windows 7 Ultimate x32
 
 
Hope it works

Hope it works

Bigtel
My System SpecsSystem Spec
05 Jun 2011   #6
Sinsemilla

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
Thread Forum
Formatting in Excel 2010
Hello all, In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box. My question is, why we use those formats? Is there any benefit for it please?
Microsoft Office
Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003
Hi, If I upgrade only the Outlook part of my Office 2003 installation to Outlook 2010 will the "Ribbon" style menu of Outlook 2010 be installed in my remaining Office 2003 menus? I accept that at some point I will probably have to get to grips with the "Ribbon" style menus introduced...
Microsoft Office
problem saving excel spread sheet in 2010 to 97-2003 format
I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft...
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 18:05.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App