قالب وردپرس درنا توس
Home / Tips and Tricks / How to Merge and Remove Cells in Microsoft Excel

How to Merge and Remove Cells in Microsoft Excel



By merging and removing cells in Microsoft Excel, you can keep your spreadsheet clean, concise, and easy to understand. The most common use is to create a header to identify the content across multiple columns, but for some reason this can be done quickly in Excel.

Note that Excel does not give you the ability to split a cell in the same way as you can in a table in Microsoft Word. You can unlock previously merged cells.

Merge Cells

Merging cells aggregates two or more cells into a single cell. To do this, select the cells that you want to merge.

 Highight Cells in Excel

Then, on the Home tab, click the Merge and Center button.

 Merge and Center "width =" 221 "height =" 135 "src =" /pagespeed_static/1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror ="; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);

As the name suggests, the selected cells are merged here. Each text in the cells is centered by default.

 Merged Cells in Excel

As you can see, the A1, B1, and C1 cells are merged into a single cell. There are other options to choose from. To access these options, click the arrow next to Merge and Center. A drop-down menu will be displayed. Dropdown Options

These options are relatively simple. Note that in Merge Across, only the selected cells in a row are merged, not the cells in a column.

So, what happens if we merge cells that already contain content? This is something you have to be very careful with. When merging cells with existing data, only the upper left value is preserved, and discards all other values. This means that all data except the data in the upper left cell will be deleted . Although Microsoft gives you a warning message before you merge the cells, make sure that the data is lost before proceeding.

Removing Cells

Merging cells splits previously merged cells into individual cells. Simply select the merged cells and then click the Merge and Center button again to disable the setting. Similarly, you can click the arrow next to "Merge and Center" to bring up the drop-down menu, and then click Unpare cells.

 Resolve Cells

When you unzip a cell that contains data, all data is in the upper-left cell and all other cells are empty.


Source link