How Do i freeze cells?!

[KristyP]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Numbers
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]Merged
[/TD]
[TD]merged
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD]merged
[/TD]
[TD]merged
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD]merged
[/TD]
[TD]merged
[/TD]
[/TR]
</tbody>[/TABLE]
PROBLEM: I have a drop down menu in my data set i.e (numbers) and when I filter for 1 & 3 it hides my merged data in that row. I'd like to be able to filter without collapsing my merged cells.

Let me know if you need further clarification. THANK YOU!

 

[jolivanes]

Indeed Gerald.
The whole idea of that snippet is to change the merged cells to center across the same cells.
In other words, eliminate the ranges that possibly will give you grief.

 

[Michael M]

Why would you still want this ??

How would I go about using your code so Ranges (e1:v24) & (e24:v29) stay merged even if I filter?

See my previous post regarding merged cells and filtering / sorting.

If you MUST filter /sort, you may need to reconsider you use of Merged cells in your layout or reconsider the layout itself !....