QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Merge Cells, Columns & Rows in Excel?

By Neha T Leave a Comment

Whenever we create any data in an excel sheet and we want to provide it with a title which must be centred over the entire range of the data, we have to merge cells of that particular section. The Merge & Centre option of Excel merges all the cells of the selected range and only the text in the upper left-most box is preserved and is placed at the centre of the merged cells.

In this section, we will discuss Merge & Centre, Merge Across, Unmerge Cells, Merge Columns and Rows.

Steps to Merge Cells, Columns & Rows in Excel 2016:

Step 1: Select the range of cells that you want to merge. Like, in the image below you can see that I have created information regarding sales done by the staff. And I want to give it a title as Sale Information.

Merge Cell in Excel 1

So, I have written Sales Information in Cell A1 and I want it in the centre & above the entire information. For that, I have to merge cells A1 to D1. So, I have selected the range A1:D1.

Merge Cell in Excel 2

Step 2: After selecting the range, go to the Home tab and click on Merge & Centre’s dropdown arrow in Alignment group.

Merge Cell in Excel 3

Step 3: Click on Merge & Centre from the displayed options.

Merge Cell in Excel 4

The effect of Merge & Centre would be like you can see in the image below. Cells A1, B1, C1 & D1 are merged to form one single large cell.

Merge Cell in Excel 5

But, this is the case when only one cell has data content and other cells among the selected range are empty.

Let us see the effects of Merge & Centre when most of the cells in the selected range has some text. In the image below I have selected the range A4:D4 and all the cells in the range have some text. Again click on the Merge & Centre.

Merge Cell in Excel 6

This time it displays a message that “Merging cells only keeps the upper-left value and discards other values”. If you agree with the condition, click OK.

Merge Cell in Excel 7

In the image below you will see the effect of Merge & Centre if the selected range has text in most of the cells. You can observe that in the selected range we have four cells, earlier with the data Stieve in A4, 264 in B4, 220 in C4, 30 in D4. After Merge & Centre, the cells A1, B1, C1 & D1 are merged &  only Stieve text of A1 is preserved and is placed at the centre.

Merge Cell in Excel 8

Unmerge Cells

Step 1: Select the range of cells that you have merged and click the dropdown arrow of Merge & Centre of Alignment group inHome tab. Among the displayed option click on the Unmerged Cells.

Merge Cell in Excel 9

Step 2: In the image below you can see the effect of Unmerge Cells. Your earlier data will not be recovered when you unmerge the cells. Only the merged cells get unmerged.

Merge Cell in Excel 10

Merge Columns

Step 1: Select the number of columns from the column header that you want to merge. Go to the Home tab and in the Alignment group click on Merge & Centre.

Merge Cell in Excel 11

Step 2: In the image below you can see the effect of Merge & Centre on the selected columns.

Merge Cell in Excel 12

Merge Rows

Step 1: Selected the number of rows that you want to merge and go to the Home tab and click on Merge & Centre of Alignment group.

Merge Cell in Excel 14

Step 2: See the effect of Merge & Centre on the selected range of rows.

Merge Cell in Excel 15

The image below shows the effect of Merge & Centre on the selected range of cells. You can observe the effect of Merge Across is different from Merge & Centre.

Merge Across merges the cells in the same row into one large cell, it merges all the columns in each row, it doesn’t merge rows in the selected range.

Merge Cell in Excel 16

So, this was all about how Merge & Centre option works in Excel.

You Might Also Like:

how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? Delete Duplicates feature imageHow to Delete Duplicates in Excel 2016? hide columns feature imageHow to Hide and Unhide Rows & Columns in Excel? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? delete blank row feature imageHow to Delete Blank Rows in Excel 2016? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? compare two columns in Excel Feature imageHow to Compare Two Columns to Find Matches & Differences in Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to install and configure uTorrent server in Ubuntu 14.04
  • How to Unfollow Someone on Instagram?
  • How to Change Fonts Size in WhatsApp?
  • How to Insert/Embed a Video in MS PowerPoint (PPT) 2016
  • How to Auto Login Windows 10?

Copyright © 2023 · QueHow · Contact Us