98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Creating workbooks
2002 excel microsoft training - Creating workbooks
Resolved · Low Priority · Version Standard
Adeolu has attended:
Access Introduction course
Excel Introduction course
Creating workbooks
how do i merge cells?
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |