Join David Rivers for an in-depth discussion in this video Merging cells, part of Office 365: Learning Excel.
- Sometimes when you want content…to span several different cells,…a good idea is to merge those cells into one.…Take a look at our Landon Hotels revenue sheet here.…Perhaps our title would look good…if it was centered across the table…that appears down below of data.…Well, in that case, we might want to merge…all of the cells from column A all the way to column N…and center it across those cells.…It's easily done, and that's exactly…what we're going to do right now.…You can open up RH_Revenues0206…if you need to catch up.…
Let's click and drag across from cell A1 to N1…Next, we want to merge these cells together.…We'll go back to the Home tab,…and from here we're going to merge these cells into one…by going over to Merge & Center.…But click the drop-down arrow to see that we can…merge and center, which will do two things at once:…merge the cells and center the contents,…which is our title, across the middle.…We can merge across, just simply merge the cells.…If we ever want to undo the merging,…we can unmerge from here.…
- What is Excel?
- Creating and saving workbooks
- Adding formulas and functions
- Using AutoFill
- Formatting, text, numbers, dates, and times
- Merging cells
- Inserting charts and pictures
- Sharing and printing workbooks
Skill Level Beginner
Q: This course was updated on 04/24/2017. What changed?
A: The following topic was updated: sharing workbooks using online options.