All I want to freeze both red areas at a time during scrolling the white worksheet area.

Copper Contributor

Screenshot.png

3 Replies

Hi @AMIT_KUMAR_VERMA 

 

place the active cell to Q5 and choose from the menue "View | Split"

 

This is the only option I can think of.

 

Thanks for your reply but it didn't work as I want. All I want to stay fix all red color areas during scrolling the white worksheet.

@AMIT_KUMAR_VERMA You could try creating a scrolling about around the white space.

This could help: https://www.youtube.com/watch?v=zePDoXpIBvw