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

sclark

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 seperate columns (B and C) under the one heading (Math)

QQapple

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!)