How To Filter Merged Cells In Google Sheets
See all How-To Articles
How to Filter Merged Cells in Excel
This tutorial demonstrates how to filter merged cells in Excel.
Filter Merged Cells
When you filter a data set that has merged cells across rows, Excel returns simply the showtime row of the merged cells. Say yous have the following data set.
As y'all can come across, product names in Column B are merged beyond three rows to display 3 months of data (cells B2: B4 are merged, B5:B7, etc.). If yous know desire to filter for Graphic carte and display information for this product only, Excel displays just Row viii, the first row containing Graphic card in Column B.
This happens because while filtering, Excel unmerges all cells past default and considers, in this case, B9 and B10 to be blank. To see all relevant rows (eight–10) when filtering for Graphic card, follow these steps:
- Showtime copy the information to another location.
Select the range with merged cells (B2:B16), right-click the selected area, and choose Re-create (or use the keyboard shortcut CTRL + C).
- Right-click outside the data gear up (due east.k., H2) and cull Paste (or use the keyboard shortcut CTRL + V).
As a result of Steps ane and 2, the merged cells from Column B, are now copied to Column H, with the same formatting. This range will later be copied dorsum to the data set.
- Now unmerge all cells, and populate blank cells with the appropriate product names.
Select the range of merged cells in Column B (B2:B16), and in the in Ribbon, go to Home > Merge & Middle.
- Keep the aforementioned range selected (B2:B16), and in the Ribbon, get to Dwelling house > Find & Select > Go To Special…
- In the Go To Special window, select Blanks and click OK.
- At present all blank cells are selected.
In cell B3, type "=B2" (to copy the value from prison cell B2), and press CTRL + ENTER on the keyboard.
This populates the formula in the selected range: All blank cells are populated with the appropriate product proper noun.
- Now, employ the copied cavalcade (H) to return Column B to its original format.
Select the previously copied merged cells from Column H, and in the Ribbon, go to Home > Format Painter.
- Click on the first cell in the range (B2), to paste formats.
- Y'all can at present filter information in Column B. Kickoff, plough on the filter.
Click anywhere in the data range, and in the Ribbon, go to Home > Sort & Filter > Filter.
- Click on the filter icon for Column B (the arrow in cell B1). Uncheck Select All and select simply Graphic carte du jour.
As a result, all three rows of Graphic card (viii–x) are filtered, showing that merged cells are filtered successfully.
How To Filter Merged Cells In Google Sheets,
Source: https://www.automateexcel.com/how-to/filter-merged-cells/
Posted by: fishfriese1951.blogspot.com
0 Response to "How To Filter Merged Cells In Google Sheets"
Post a Comment