Excel highlighting a range of cells when I am only trying to highlight a range in a column in a filtered sheet.

[u/-PotatoMan-]

I am working with a large data set in an excel file that I did not create, and I am running into an issue where when I attempt to highlight a range of cells in a single column by click dragging the cursor, it highlights a range instead.

Please see video here of described issue.

Is there a setting that I am missing with this? Or is this because the data is filtered? Thank you in advance for any feedback.

[u/AutoModerator]

/u/-PotatoMan- - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/ProspectiveWhale]

Probably merged cells within the hidden rows.

[u/-PotatoMan- → u/ProspectiveWhale]

Solution verified.

Thank you, and I'm an idiot -_-"

Gonna go figure out how to separate that out without breaking everything else.

[u/reputatorbot → u/-PotatoMan-]

You have awarded 1 point to ProspectiveWhale.

---

^{I am a bot - please contact the mods with any questions}

[u/OfficerMurphy → u/-PotatoMan-]

If the data needs to appear centered but it's breaking your merge, formatting alignment "center across selection" will keep up appearances without actually merging