Formatting Excel 2010, Excel 2003


  1. Posts : 18
    Windows 7
       #1

    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 Attached Thumbnails Formatting Excel 2010, Excel 2003-excel-en.jpg  
      My Computer


  2. Posts : 6
    Windows 7 Ultimate x32
       #2

    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 Computer


  3. Posts : 18
    Windows 7
    Thread Starter
       #3

    @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 Computer


  4. Posts : 18
    Windows 7
    Thread Starter
       #4

    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
    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
    Last edited by Sinsemilla; 05 Jun 2011 at 19:04.
      My Computer


  5. Posts : 6
    Windows 7 Ultimate x32
       #5

    Hope it works


    Hope it works

    Bigtel
      My Computer


  6. Posts : 18
    Windows 7
    Thread Starter
       #6

    bigtel49 said:
    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 Computer


 

  Related Discussions
Our Sites
Site Links
About 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 03:29.
Find Us