Get real, active and permanent YouTube subscribers

Get Free YouTube Subscribers, Views and Likes

How to Filter with Merged Cells in Excel | Cannot Filter Merged Cells - Filter Only Shows First Row

Follow

Chester Tugwell

In this Microsoft Excel video tutorial I explain how to filter using merged cells. If you want to retain the look of your data, using merged cells, but still want to be able to filter this is your solution.

#exceltips #exceltricks #exceltutorial

posted by Makabayo7d

How to filter merged cells in excel|Filter not working for merged cell in Excel

How to filter merged cells in excel|Filter not working for merged cell in Excel

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

How to Make Search Bar in Excel (All Column Search)

How to Make Search Bar in Excel (All Column Search)

How to Filter in Excel

How to Filter in Excel

6 Excel Tools Most Users Never Think to Use (Files Included)

6 Excel Tools Most Users Never Think to Use (Files Included)

Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Excel's NEW Checkboxes Are Incredibly Cool! Here's why

2 Simple Alternatives to Merging Cells in Excel

2 Simple Alternatives to Merging Cells in Excel

How To Find Merged Cells In Excel || [Excel Tricks]

How To Find Merged Cells In Excel || [Excel Tricks]

Excel Tips: Unable to Filter Data after merging Cells? Then try this tips!

Excel Tips: Unable to Filter Data after merging Cells? Then try this tips!

Automated Attendance Sheet in Excel with Formula | Download Attendance Sheet Template

Automated Attendance Sheet in Excel with Formula | Download Attendance Sheet Template

Say Goodbye to IF Statements in Excel with SWITCH

Say Goodbye to IF Statements in Excel with SWITCH

I don't use PIVOT tables anymore... I use this other thing instead!

I don't use PIVOT tables anymore... I use this other thing instead!

5 Excel Secrets You'll Be Embarrassed You Didn't Know

5 Excel Secrets You'll Be Embarrassed You Didn't Know

Is it really this EASY to Sort and Filter Pivot Tables?

Is it really this EASY to Sort and Filter Pivot Tables?

Fastest Way to Delete Empty Rows in Excel (New)

Fastest Way to Delete Empty Rows in Excel (New)

Fix Excel Error When Sorting: 'To do this, all the merged cells need to be the same size.'

Fix Excel Error When Sorting: 'To do this, all the merged cells need to be the same size.'

EASILY Make an Automated Data Entry Form in Excel

EASILY Make an Automated Data Entry Form in Excel

When Should You Use the Hash Sign in Excel Formulas?

When Should You Use the Hash Sign in Excel Formulas?

merge cell data filter |Excel Merged Cell Data Filter | How To Filter Merged Cells In Excel?

merge cell data filter |Excel Merged Cell Data Filter | How To Filter Merged Cells In Excel?

IF Statement in Excel Based on Cell Colour

IF Statement in Excel Based on Cell Colour

Recommended

Women's Makeup From Ancient Times To Present Day

Women's Makeup From Ancient Times To Present Day

04:10

No Other Horoscopes Before The Year 2050!

No Other Horoscopes Before The Year 2050!

09:24

Harry Potter Is No Longer In A Good Shape!

Harry Potter Is No Longer In A Good Shape!

00:17

Oops! I Did It Again - Kids Embarrass Parents Compilation

Oops! I Did It Again - Kids Embarrass Parents Compilation

05:08

Long Time No See, Piglet!

Long Time No See, Piglet!

01:01

Would You Sell Your Dog For 100000$?

Would You Sell Your Dog For 100000$?

04:46

Hyundai - Best Alternative To Any Cosmetics

Hyundai - Best Alternative To Any Cosmetics

00:46

'Star Wars' Came To Life As YouTuber Created 40W Laser Shotgun

'Star Wars' Came To Life As YouTuber Created 40W Laser Shotgun

01:54