How to lock rows in excel?

0 ⤊

How to lock rows in excel?

I want to lock rows in excel so for example rows 1-5 will always be visable (won't move) no matter how far down in the sheet i scroll.
Kind of like a banner in websites.

2007-04-06 06:32:34 · 3 answers · asked by asdfasdf a 1 in Computers & Internet ➔ Software

3 answers

To "freeze" rows 1-5, click on cell A6, then select "window" from the top menu, click on "Freeze Panes". Voila.

2007-04-06 06:39:00 · answer #1 · answered by slobsinger 1 · 0⤊ 0⤋

Open the worksheet
Position the cursor in the first cell to follow the rows you want to repeat (like A6)

click Window
cl Freeze panes
*****************

2007-04-06 13:50:57 · answer #2 · answered by TheHumbleOne 7 · 0⤊ 0⤋

Windows + Freeze-Panes

2007-04-06 13:36:06 · answer #3 · answered by lda 4 · 0⤊ 0⤋