Xóa Merge Cell Trong Word / 2023 / Top 18 # Xem Nhiều Nhất & Mới Nhất 11/2022 # Top View | Hoisinhvienqnam.edu.vn

How To Merge Cells In Word 2022 Tables / 2023

The steps in this guide are going to show you how to merge two or more cells in a table that you have created in your Microsoft Word document.

Select the Layout tab at the top of the window, to the right of Table Design.

In fact, you may have even merged cells in Microsoft Excel before, which likely led you to look for a way to merge cells in Word. Fortunately you have the ability to select cells in a Microsoft Word table, then take those selected cells and combine them into one large single cell. Our guide below will show you how to merge cells in Word and help you achieve your desired table formatting.

How to Merge Table Cells in Microsoft Word 2016

The steps in this article were performed in the Microsoft Word for Office 365 version of the application, but will also work in other recent versions including Microsoft Word 2016 and Microsoft Word 2019.

Step 1: Open your document containing the table with cells that you wish to merge.

Step 4: Drag your mouse to select the rest of the cells to include in the merge. I am merging the top row of my table in the image below, as indicated by the gray fill color appearing in those cells.

Step 5: Select the Layout tab to the right of the Table Design tab at the top of the window.

Step 6: Choose the Merge Cells option in the Merge section of the ribbon.

How to Unmerge Cells in Word 2016

Now that you know how to merge cells in Word tables, it’s also helpful to know how to undo that merge in case you accidentally merge the wrong cells, or discover that you need to change your layout.

Word handles this with a Split Cells tool. This allows you to select the merged cells in your table, then specify the number of rows or columns that the merged cells should be split into.

Step 1: Select the merged cell that you wish to split into multiple cells.

Find out how to add space between your Word table cells if it seems like the data in your cells is too close to the data in surrounding adjacent cells.

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

How To Merge Cells In Excel / 2023

You can organize and manipulate the data by merging the rows and columns to suit your report. What’s more, Excel allows you to unmerge the cells.

Reasons for Merging Cells

Merge Options

There are four primary merge options available in Excel.

Merge & Center:

This alternative merged cells and aligns text at the center while retaining the top and left most data. 

Merge Across:

This option combines cells in columns without changing their alignment.

Merge Cells:

It is the simplest method of merging the selected cells

Unmerge Cells:

It is the opposite of merging because it unmerges or splits the cells.

Let’s get started on how to merge cells in Excel

Method 1: Merge & Center Option in Excel

The Merging command is located on the Excel Home Tab. 

Afterward, maneuver to the

Merge & Center

button located under the

Home Tab

How to Merge Columns in Excel

It is easy to merge columns in Excel. Select the multiple columns you wish to join and repeat the above process. 

The first step is to highlight the

two columns

you want to merge. For instance, you may want to combine the “

First Name

” and “

Last Name

” like in the example below. 

Take note that selecting the

Merge & Center

button will provide you with one large cell that has only one value. 

Method 2: Merging Multiple Cells using the Format Method

Another easy method to merge cells is using the format menu. 

Highlight

the multiple cells to be merged. 

Locate the Alignment Tab and check on the “

Merge Cells

” option. 

Although 53% of excel users utilize the Merge Cells Feature, merging cells creates multiple data problems. First of all, it is difficult to copy and paste data. Secondly, it is impossible to highlight a single column that contains numbers as data. Thirdly, the option of Autofill is disabled, which makes it challenging to save on time on Excel. Lastly, since merged cells are not similar to the original cells, you cannot use essential Excel features such as COUNTIFS and SUMIFS. Therefore, the ideal alternative to counter these problems is using the “Center Across Selection” merging option.

How to Merge Cells without Losing Data

Method 1: Center Across Selection

Center Across Selection does not modify and combine cells. Instead, it only aligns the relevant text at the center. Therefore, when merging cells, you don’t lose any functionality such as copy, paste, or Autofill. 

The first step is to

select the text

you want to join across. 

Alternatively, press

CTRL+1

to launch the

Alignment Group Dialogue box

However, the only difference is that the cells are intact, including their functionality. Please note that this option only works for horizontal groups. Therefore, you’ll need to merge cells vertically. What’s more, ensure that you join cells with single entries because data from multiple entries may be unsuccessful to emerge.

Method 2: Concatenation Formula

The Concatenation formula is the best option for merging cells if you don’t want to lose your data. What’s more, this formula is the best for joining multiple cells such as “First Name” and “Last Name” into a single cell. However, a new cell will be created for the result.

First of all, select cell “

C2

” and apply the

CONCATENATE

formula

(A2,” ” B2)

to get the desired results. 

A2

refers to the first cell to be merged, whereas

B2

is the last cell to be merged. 

The space between the first name and the last name is represented by the two quotations (“) marks. 

Method 3: How to Merge cells using Ampersand (&) Operator

The Ampersand (&) Operator is similar to the Concatenation formula. However, whereas ampersand uses “&” operator function, the latter use the CONCATENATE function. 

First of all, select

Cell 2

titled “

Full Name

”. 

After that, apply the formula

=A2&“ “&B3

to give the desired result as illustrated below.

How to Unmerge Cells In Excel

If you need to split the previously merged cells, then you can unmerge them. 

Select the

merged cells 

Limitations of Merging Cells using Excel

However, Excel’s primary weakness is that only the upper-left value of cells is retained while all other data is discarded. Although data from one cell is retained, the contents of two or more cells cannot be merged. Consequently, only the data from the upper-left will be kept after merging.

Secondly, Excel only merges cells that form a rectangular shape. For instance, it is possible to combine data from cells C1, C2, D1, and D2. However, it is impossible to merge cells from C1, C2, and B1 only. Lastly, the sort command does not function on the already merged cells.

If you’re looking for a software company you can trust for its integrity and honest business practices, look no further than SoftwareKeep. We are a Microsoft Certified Partner and a BBB Accredited Business that cares about bringing our customers a reliable, satisfying experience on the software products they need.   We will be with you before, during, and after all the sales.

That’s our 360 Degree SoftwareKeep Guarantee. So, what are you waiting for? Call us Today on +1 877 315 1713 or email sales@softwarekeep.com. As well, you can reach us via Live Chat.

Merge And Combine Cells In Excel Without Losing Data / 2023

The tutorial demonstrates different techniques to quickly merge two cells in Excel and combine multiple cells without losing data in Excel 2016, 2013, 2010 and lower.

In your Excel worksheets, you may often need to merge two or more cells into one large cell. For example, you may want to combine several cells for a better data presentation or structure. In other cases, there may be too much content to be displayed in one cell, and you decide to merge it with adjacent blank cells.

Whatever the reason, combining cells in Excel is not as straightforward as it may seem. If at least two cells you are trying to join contain data, the standard Excel Merge Cells feature will only keep the upper-left cell value and discard values in other cells.

But is there a way to merge cells in Excel without losing data? Of course there is. And further on in this tutorial, you will find a few solutions that work in all versions of Excel 2016, Excel 2013, Excel 2010 and lower.

Combine cells using Excel’s Merge and Center feature

The fastest and easiest way to combine two or more cells in Excel is to use the built-in Merge and Center option. The whole process takes only 2 quick steps:

Select the contiguous cells you want to combine.

In this example, we have a list of fruits in cell A1 and we want to merge it with a couple of empty cells to the right (B2 and C2) to create a large cell that fits the entire list.

Join Excel cells into one

Combine multiple cells into one cell

Read more

Quickly merge cells without any formulas!

And keep all your data safe in Excel

Read more

Other merging options in Excel

Merge Across – combine the selected cells in each row individually:

Merge Cells – join the selected cells into a single cell without centering the text:

Excel’s merging features – limitations and specificities

When using Excel’s built-in features to combine cells, there are a few things to keep in mind:

Make sure that all the data you want to include in a merged cell is entered in the left-most cell of the selected range because only the content of the upper-left cell will survive after merging, data in all other cells will be deleted. If you are looking to combine two or more cells with data in them, check out How to merge cells without losing data.

If the Merge and Center button is greyed out, most likely the selected cells are in Edit mode. Press the Enter key to cancel the Edit mode, and then try to merge cells.

It’s not possible to sort a range containing both merged and unmerged cells.

How to merge cells in Excel without losing data

As already mentioned, the standard Excel merge features keep the content of the top-left cell only. And although Microsoft has made quite a lot of improvements in the recent versions of Excel, the Merge Cells functionality seems to have slipped out of their attention and this critical limitation persists even in Excel 2013 and Excel 2016. Well, where there is no obvious way, there is a workaround 🙂

Method 1. Combine cells within one column (Justify feature)

This is a quick and easy method of merging cells keeping all their content. However, it requires that all the cells to be merged reside in one area in one column.

Select all the cells you want to combine.

Make the column wide enough to fit the contents of all cells.

If the combined values spread across two or more rows, make the column a bit wider and repeat the process.

This merging technique is easy to use, however it does have a number of limitations:

Using Justify you can only join cells in a single column.

It works for text only, numerical values or formulas cannot be merged in this way.

It does not work if there are any blank cells in between the cells to be merged.

Method 2. Merge multiple cells with data in any range (Merge Cells add-in)

To be able to merge two or more cells in Excel without losing data and without extra “tricks”, we created a special tool – Merge Cells for Excel.

Using this add-in, you can quickly combine multiple cells containing any data types including text, numbers, dates and special symbols. Also, you can separate the values with any delimiter of your choosing such as a comma, space, slash or line break.

To join cells exactly the way you want them, configure the following options:

Choose Cells into one under “What to merge”.

Select the delimiter under “Separate values with”.

Specify the cell where you want to place the result: top-left, top-right, bottom-left or bottom-right.

Make sure the Merge all areas in the selection option is selected. If this box is not checked, the add-in will work like the Excel CONCATENATE function, i.e. combine the values without merging the cells.

Apart from joining cells, this tool can quickly merge rows and columns, you just have to select the corresponding option in the “What to merge” drop-down list.

To give the Merge Cells add-in a try, you are welcome to download the evaluation version that works with Excel 2016, 2013, 2010, 2007 and 2003.

Method 3. Use the CONCATENATE function to combine two or multiple cells

Users who feel more comfortable with Excel formulas, may like this way to combine cells in Excel. You can employ the CONCATENATE function or Excel & operator to join the cells’ values first, and then merge the cells if needed. The detailed steps follow below.

Supposing you want to combine two cells in your Excel sheet, A2 and B2, and both cells have data in them. Not to lose the value in the second cell during merging, concatenate the two cells by using either of the following formulas:

=CONCATENATE(A2,", ",B2)

=A2&", "&B2

The formula, however, inserts the concatenated values in another cell. If you do need to merge two cells with the original data, A2 and B2 in this example, then a few extra steps are required:

Copy the cell with the CONCATENATE formula (D2).

=CONCATENATE(A2, ": ", B2, ", ", C2)

You can find more formula examples in the following tutorial – CONCATENATE in Excel: combine text strings, cells and columns.

Shortcut for merging cells in Excel

If you merge cells in your Excel worksheets on a regular basis, you may find useful the following Merge Cells shortcut.

Select the cells you want to merge.

Press the

Alt

key that provides access the commands on the Excel ribbon and hold it until an overlay appears.

Hit

H

to select the Home tab.

Press

M

to switch to Merge & Center.

Press one of the following keys:

C

to merge and center the selected cells

A

to merge cells in each individual row

M

to merge cells without centering

How to quickly find merged cells

To find merged cells in your Excel sheet, perform the following steps:

How to unmerge cells in Excel

After unmerging the cells, the entire contents will appear in the top-left cell.

Alternatives to merging cells in Excel

It goes without saying that merged cells can help present the information in your Excel worksheets in a better and more meaningful way… but they spawn numerous side-effects that you may not be even aware of. Here are just a few examples:

You can’t sort a column with merged cells.

Neither AutoFill nor Fill Flash feature works if a range of cells to be filled contains merged cells.

You cannot turn a range containing at least one merged cell into a full-fledged Excel table, let alone a pivot table.

If you want to combine cells somewhere in the middle of your Excel sheet, you may consider using the Center Across Selection feature as an alternative:

Select the cells that you’d like to join, B4 and C4 in this example.

Press

Ctrl + 1

to open the Format Cells

In terms of look, the result is indistinguishable from the merged cell:

To prove that we did not really merge two cells, we can select each one individually:

This is how you can combine two cells in Excel or merge multiple cells without losing data. Hopefully, this information has proved useful for your day-to-day tasks. I thank you for reading and hope to see on our blog next week.

You may also be interested in

Cách Xử Lý Dữ Liệu Với Merge Cells Trong Excel / 2023

Merge Cells, hay còn gọi là gộp ô, nghĩa là các ô sẽ được gộp lại (phối lại) với nhau. Và khi áp dụng Merge Cells, thì chỉ có ô đầu tiên có chứa giá trị, nội dung các ô còn lại sẽ bị xóa giá trị.

+ Bỏ gộp ô: Bạn chọn ô đã gộp, sau đó chọn Merge Cells, thì lúc này các ô sẽ tự động tách riêng ra nhau.

NHỮNG SAI LẦM KHI DÙNG MERGE CELLS

TẠI SAO HÀM TRẢ VỀ KẾT QUẢ KHÔNG ĐÚNG?

CÁCH DÙNG MERGE CELLS NHƯNG VẪN GIỮ NGUYÊN GIÁ TRỊ CÁC Ô.

HƯỚNG DẪN GỘP Ô VẪN GIỮ NGUYÊN GIÁ TRỊ CỦA Ô:

Bước 1: Chọn số ô tương ứng để merge ở bên ngoài, ví dụ mình chọn 2 ô B13:C13, mình đã tô vàng cho các bạn dễ nhìn.

Bước 2: Chọn Merge Cells cho 2 ô đó.

Bước 3: Ta chọn Format Painter.

Bước 4: Chọn ô đầu tiên cần Merge, lúc này ta chọn ô B4.

Bước 5: Bạn cần chọn Format Cells, để định dạng lại giá trị trong ô (nếu cần). Kết quả ta có như bên dưới.

HƯỚNG DẪN TỰ ĐỘNG CO GIÃN ĐỘ RỘNG CỦA Ô KHI DÙNG MERGE CELLS:

Bước 1: Ta chọn 1 ô bên ngoài vùng in, bạn nên chọn qua chế độ Page Break View, kéo vùng in phù hợp khổ giấy. Và thiết lập công thức bên ngoài vùng in đó.

Bước 2: Tại ô I5, nhập công thức =ô chứa nội dung, ở đây ta có: =A5. Sau khi Enter ta thấy ô có nội dung y hệt ô đã merge cells bên cạnh: A5:G5.

CÁCH XỬ LÝ DỮ LIỆU VỚI MERGE CELLS

Trong ví dụ của mình đang theo chiều ngang, vậy thì nếu theo chiều dọc thì công thức của bạn sẽ thế nào?

Câu hỏi đặt ra, bây giờ chúng ta từ bỏ Merge Cells cho cột A, và thay vì lập cột phụ D, ta xử lý dữ liệu cột A được không? Câu trả lời là được, chúng ta qua phần 6.

CÁCH ĐIỀN DỮ LIỆU VÀO CÁC Ô TRỐNG SAU KHI BỎ GỘP Ô (UN-MERGE CELLS)

Theo các bạn, chúng ta sẽ xử lý cột A ở phần 5 như thế nào? Có nhiều cách.

Bước 1: Chọn các ô cần bỏ Merge Cells (A3:A6).

Bước 2: Chọn Un-Merge Cells

Bước 4: Ta chọn tiếp Special… (phím tắt đi tới Special, ta có thể nhấn F5, thay vì phải làm từ bước 3).

Bước 5: Ta chọn [x] Blanks, và chọn OK.

Bước 6: Ta nhập vào công thức: =A3, kết thúc với phím CTRL+ENTER.

Bước 7: Lúc này bạn sẽ thấy các ô trống đều được điền công thức vào.

Bước 8: Nhiệm vụ cuối cùng, là sao chép toàn bộ kết quả vùng A3:A6, rồi dán lại chính nó với Paste Value như đã làm với cách 1, vậy là xong!