Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Inserting multiple columns on Excel (https://www.askmehelpdesk.com/showthread.php?t=1413)

  • Jan 4, 2003, 05:35 AM
    nirdk
    Inserting multiple columns on Excel
    Can anyone help me to insert multiple columns under any particular cell without disturbing other cell data ?

    For example it should be like :

    ---------------------------------------------------------
    | A | B | C |
    ----------------------------------------------------------
    1 | PHY | CHEM | MATH |
    ----------------------------------------------------------
    2 | | ORG | INOR| |
    ----------------------------------------------------------
    3 | 75 | 35 | 45 | 89 |
    ----------------------------------------------------------
    4 | 65 | 25 | 35 | 90 |
    ----------------------------------------------------------

    It means we should have multiple columns under the same "B" column.

    Many thanks in advance !

    With Regards,

    Nirmal
  • Jan 14, 2003, 11:32 PM
    sclark
    Inserting multiple columns on Excel
    The easiest way I can think of is to:
    1) Insert a row in between columns B and C (making math column d
    2) Merge B1 and C1 so that the Chem heading follows both columns
    3) Use Orig and INor as two separate columns (B and C) under the one heading (Math)
  • Sep 30, 2003, 06:18 AM
    QQapple
    Inserting multiple columns on Excel
    I agree with sclark

    Since you look new to excel.. hope this helps:

    To merge:
    1. In that example you provided, select both B1 and C1
    2. Right click on them and select from the menu "Format cells"
    3. A window should pop up - select the tab "Alignment"
    4. There should be an option to "Merge cells"... click that check box so that there is a tick beside Merge cells
    5. Press OK

    (by the way... If you ever have a chance to learn Microsoft office (tutorial/workshop/guide/step-by-step/whatever) I highly reccogmend that you learn Microsoft office... office may be frustrating to use but only when you are not familier with it... If you perfect it... you'll be surprised how powerful it is, and it will also safe you a lot of time(bonus!)

  • All times are GMT -7. The time now is 01:18 AM.