2002 excel microsoft training - Creating workbooks

Dear Adeolu

Thank you for attending the Excel and Access Training!!

Merging cells are really helpful for table headings!

It depends if you want to only merge the cells but may be not put the data in the centre!!
In order to do this you have to click on Format > Cells...
In the alignment tab simply put a check on the option that says merge cells at the bottom of the dialog box!!

If you want to merge the cells and at the same time centre the data you can highlight the relevant cells and on the formatting toolbar press the white button which has got a small a with some arrows and is on the right hand side of the right-justify button!!

Please note that before pressing the button ensure you don't have data in the other cells except the first one. Otherwise it will delete the content of the other cells.


I hope this helps!!

Kindest Regards

Rajeev Rawat

MOS Master instructor 2000/2003