Combine/Merge Cells in Microsoft Excel - Make Better Headers

http://www.TeachMsOffice.com

This Microsoft Excel video tutorial shows you how to merge a cell in Excel. This means that you can actually combine multiple cells to create one single larger cell.This eliminates the need to re-size an entire column or row just to fit the contents of one cell.

This is a simple and easy to use feature in Excel and, in this example, you will learn how to create a better looking header which is centered over all of the data which it represents. This techniques allows you to create a more visually appealing look and feel in Excel and also helps to make clear which headings apply to what.


To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions.

Have a great day!

Category:

Education

Tags:

• microsoft
• excel
• office
• 2003
• 2007
• help
• tips
• tricks
• how
• to
• merge
• combine
• cells
• in
• make
• better
• headers
• center
• data
• resize
• boxes

[PatrickMercader]

can you combine 2 or more cells with text to make one cell with all the words in it?

[ExcelisHell]

Yes, but not if the cells you want to combine already have the text in them. If you combine cells which already contain text, only the text in the left most column will remain. The best way to do this with a large amount of text is to combine the cells first and then paste the text or combine cells if the text is only in the left most column.

[aminemoo]

Thank you very much that was very helpful

[gtrcrzy6]

Thank you, this helped me alot

[BLCKBRTH]

much thx

[Ivanmaria1]

thank u very much i also knewed but i forgot

[ebaymagot]

Thank you

[ctiepie]

woo this really helps thanx sooo soo soo much :)!

[PrincessWithSkills]

Useful.