1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible to remove the echo effect while using freeze

When i use freeze to lock some columns on the left side, it doubles up when i scroll far left, creating an echo effect

https://preview.redd.it/e9uutnxe99tg1.png?width=1483&format=png&auto=webp&s=5a1d4206c53946e321e9ee4fa6f848b8628e9aa6

is there a way to make it stop scrolling where it bounces back, so that i dont need to see double for .5 seconds

https://preview.redd.it/e0e4p0xg99tg1.png?width=815&format=png&auto=webp&s=66d37fc0402a43e343a47f96c458750b4a6f040f

Additional info, thx 4 the help btw

for the guy asking for my version

https://preview.redd.it/ph0cuxzi99tg1.png?width=801&format=png&auto=webp&s=2237891ac4210a3ae6947e56feaa087829b1a8e8

Regarding using split, i dont know enough about it, but i can tell how i did it and what happens when i click split

i just marked the column and hit freeze

https://preview.redd.it/9zfi24vn99tg1.png?width=1471&format=png&auto=webp&s=06930d07ec2b5fcd3bb66035e2f1a612e6b1c769

then freeze panes

then it looks like pic 1 when i scroll but bounces back to how pic 2 looks after half a sec.

if i click split it stays duplicated and doesnt bounce back, so i dont think thats it

submitted by /u/Professional_Arm5592
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives