How to Merge Cells in Excel 2013



How to Merge Cells in Excel

Steps

  1. Open your Excel document.Double-click an Excel document to open it in Excel.
    • If you haven't yet created the document, open the Excel program and clickBlank Workbook.
  2. Select the cells you want to merge.Click one cell, then drag your mouse to select the other cell(s) you want to merge.
    • For example, if you want to merge cellsA1throughC1, you would click and drag fromA1right toC1.
    • The cells you merge must be touching each other; for example, you can mergeA1withB1, but not withC1without mergingB1as well.
  3. Click the tab.It's in the top-left side of the Excel window. This will bring up theHometoolbar below the green ribbon at the top of the Excel window.
  4. ClickMerge & Center.This box is in the "Alignment" section of options in theHometoolbar. Doing so will automatically merge your selected cells and center their content.
    • If you don't want to center the cells' content, click instead the▼icon to the right ofMerge & Centerand then clickMerge Cells.

Community Q&A

Search
  • Question
    Can six cells be merged into two cells in Excel?
    GaiusG
    Community Answer
    Yes, of course that's possible. Choose 3 cells to be merged into a single cell, then repeat the process with the remaining three cells.
    Thanks!
Unanswered Questions
  • The "merge" option is blanked out. How do you merge when Excel does not highlight the option? I have chosen three consecutive cells but the option just does not work. What can I do?
  • Merge cells command is grayed out. How do you activate?
  • How can I copy and merge 2 cells into one cell in another sheet?
  • What do I do if I want to merge information from one book to another?
  • How do you merge cells?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Quick Summary

1. Open theExcel document.
2. Select cells to merge.
3. ClickHome.
4. ClickMerge & Center.

Did this summary help you?
  • You can create an overarching title box for your Excel content by merging cells.

Warnings

  • You cannot merge cells while editing a cell.

Related wikiHows

Article Info

Categories:

In other languages:

Português: , Español: , Italiano: , Deutsch: , Français: , 中文: , Русский: , Bahasa Indonesia: , Nederlands: , العربية: 

Thanks to all authors for creating a page that has been read 217,736 times.





Video: Excel 2010 Basics - Merging and Splitting Cells.mov

How to Merge Cells in Excel
How to Merge Cells in Excel images

2019 year
2019 year - How to Merge Cells in Excel pictures

How to Merge Cells in Excel forecast
How to Merge Cells in Excel recommend photo

How to Merge Cells in Excel picture
How to Merge Cells in Excel photo

How to Merge Cells in Excel How to Merge Cells in Excel new photo
How to Merge Cells in Excel new photo

pictures How to Merge Cells in Excel
photo How to Merge Cells in Excel

Watch How to Merge Cells in Excel video
Watch How to Merge Cells in Excel video

Communication on this topic: How to Merge Cells in Excel, how-to-merge-cells-in-excel/
Forum on this topic: How to Merge Cells in Excel, how-to-merge-cells-in-excel/ , how-to-merge-cells-in-excel/

Related News


Home Remedies to Get Rid of Grey Hair
River Island x War Child Join Forces To Create Exclusive T-Shirt
A Google Employee Blamed Biology for the Low Number of Female Programmers
Genetic Counseling and its Influence on Breast Cancer Decisions
552018
How to Run a Student Community at a University
Blueberry Margarita
16 Ways To Treat Foot Pain
Herve Leger by Max Azria SpringSummer 2019 Collection – New York Fashion Week
The Sex Problem He Should See His Doctor About
Sunday Morning Hash Browns
How to Curl Barbie Hair
How to Live with Neutropenia



Date: 05.12.2018, 17:49 / Views: 94274