![merging cells in excel 2013 merging cells in excel 2013](https://cdn.extendoffice.com/images/stories/doc-excel/grey-out-unused-range/doc-kutools-set-scroll-1.png)
You can delete them by selecting the columns and clicking the Delete button from the right-click menu.
Merging cells in excel 2013 how to#
In this article, we're going to show you how to merge cells in Excel without losing your data. Uncheck Select All and select only Graphic card.Īs a result, all three rows of Graphic card (8-10) are filtered, showing that merged cells are filtered successfully.Excel will give you a warning message telling that you will lose the data, when you try to merge cells using the Merge & Center feature. Click on the filter icon for Column B (the arrow in cell B1).First, turn on the filter.Ĭlick anywhere in the data range, and in the Ribbon, go to Home > Sort & Filter > Filter. Click on the first cell in the range (B2), to paste formats.Select the previously copied merged cells from Column H, and in the Ribbon, go to Home > Format Painter. Now, use the copied column (H) to return Column B to its original format.This populates the formula in the selected range: All blank cells are populated with the appropriate product name. (2) Specify a separator for the combined data. In the Combine Columns & Rows dialog box, specify the options as below screenshot shown: (1) Select Combine rows under To combine selected cells according to following options. In cell B3, type “=B2” (to copy the value from cell B2), and press CTRL + ENTER on the keyboard. Select the range that you want to merge, and click Kutools > Combine. In the Go To Special window, select Blanks and click OK.Keep the same range selected (B2:B16), and in the Ribbon, go to Home > Find & Select > Go To Special….This button allows you to choose how Excel formats these cells. When inserting new rows, columns, or cells, you will see the Insert Options button next to the inserted cells. The new row will appear above the selected row. Select the range of merged cells in Column B (B2:B16), and in the in Ribbon, go to Home > Merge & Center. Click the Insert command on the Home tab. Now unmerge all cells, and populate blank cells with the appropriate product names.This range will later be copied back to the data set. Right-click outside the data set (e.g., H2) and choose Paste (or use the keyboard shortcut CTRL + V).Īs a result of Steps 1 and 2, the merged cells from Column B, are now copied to Column H, with the same formatting.Select the range with merged cells (B2:B16), right-click the selected area, and choose Copy (or use the keyboard shortcut CTRL + C). First copy the data to another location.To see all relevant rows (8–10) when filtering for Graphic card, follow these steps: This happens because while filtering, Excel unmerges all cells by default and considers, in this case, B9 and B10 to be blank. If you know want to filter for Graphic card and display data for this product only, Excel displays only Row 8, the first row containing Graphic card in Column B. Say you have the following data set.Īs you can see, product names in Column B are merged across three rows to display three months of data (cells B2: B4 are merged, B5:B7, etc.). When you filter a data set that has merged cells across rows, Excel returns only the first row of the merged cells.
![merging cells in excel 2013 merging cells in excel 2013](https://media.cheatography.com/storage/thumb/webucator_excel-2013-keyboard-shortcuts.750.jpg)
![merging cells in excel 2013 merging cells in excel 2013](https://www.exceltrick.com/wp-content/uploads/2013/06/Cells-After-Merging-image-01.png)
This tutorial demonstrates how to filter merged cells in Excel.