Filtering formulated cells

Occasional Visitor



In my excel, on sheet 1 I have multiple formulated cells pulling data from 5 different sheets. In column A of the formulated cells, I want to filter the data being pulled from A to Z. When I filter though some of the data disappears and/or shows empty cells in between different cells with data in them. Is there a way to fix this so I can filter my column A and it shows all my data and in alphabetical form? 



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies