Description
In this video I'll show you how to merge cells in Microsoft Excel. Merging cells is a great way to center a title across your spreadsheet or group related rows under one label.
Timestamps:
Introduction: 0:00
Merge and Center a Title: 0:14
Choose a Different Merge Option: 0:45
Merge Cells with Data: 1:16
Use Center Across Selection: 2:20
Conclusion: 2:44
Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#excel #microsoftexcel #exceltutorial #techtips #tutorial
Video Transcript:
Step 1. Open your Excel spreadsheet. For this example, I'm using a convention booth schedule for a comic book shop, with a title in cell A1 and the schedule underneath it in columns A through E.
Step 2. Click and drag to select cells A1 through E1.
Step 3. Click "Merge and Center" on the Home tab, in the Alignment group. The five cells merge into one big cell, and the title is centered above the schedule.
Click the arrow next to "Merge and Center" to see the other options. "Merge Across" merges the selected cells in each row separately, which is handy when you select several rows at once. "Merge Cells" combines the cells without centering the text. And "Unmerge Cells" splits a merged cell back into separate cells. And "Center Across Selection" centers text across the selected cells without merging them. More on that in a moment.
You can also merge cells to group rows, like putting one Friday label next to all of Friday's shifts.
Keep in mind that when you merge cells that all contain data, Excel keeps only the value in the upper left cell and deletes the rest.
Step 1. Click and drag to select cells A4 through A11, which all say Friday.
Step 2. Click "Merge and Center." A message appears letting you know only the upper left value will be kept.
Step 3. Click "OK." The eight cells become one cell labeled Friday. Excel places the label at the bottom of the merged cell.
Merged cells can cause problems when you sort, filter, or copy and paste your data. If you only want a title to look centered, use Center Across Selection instead. To try it on the title, first click the merged title cell, click the arrow next to "Merge and Center," and choose "Unmerge Cells."
Step 1. Select cells A1 through E1, then press "Control" and "1" to open the Format Cells window, and click the "Alignment" tab.
Step 2. Choose "Center Across Selection" in the Horizontal drop-down menu.
Step 3. Click "OK." The text looks merged, but the cells stay separate.
