Forum Discussion

AMIT_KUMAR_VERMA's avatar
AMIT_KUMAR_VERMA
Copper Contributor
Feb 16, 2022

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

excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Feb 16, 2022

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.

 

  • AMIT_KUMAR_VERMA's avatar
    AMIT_KUMAR_VERMA
    Copper Contributor
    Feb 16, 2022

    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.

Resources