SOLVED

EXcel spreadsheet

New Contributor

How do I lock the headings at the top of each page of spreadsheet so that they stay at the top of screen.

4 Replies

@BigAl25 Find any of these ikons on the View ribbon. Try and see what happens.

Screenshot 2022-01-18 at 17.50.34.png

Picture taken on a Mac but similar on PC.

 

@Riny_van_Eekelen 

Thanks. They are there on View ribbon, but faint and not available for use.

Can I make them live

best response confirmed by Hans Vogelaar (MVP)
Solution

Make sure that you are in Normal or Page Break view. Freeze Panes does not work in Page Layout view.

@Riny_van_Eekelen 

success!!

Many Thanks