how do i prevent a row from moving, like subheader that is visibl

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Binmaru - 16 Jan 2008 15:50 GMT

In Excel, how do I prevent a row from moving, like a subheader that I want to
stay always visible at the top of my document?

Reply to this Message

David Biddulph - 16 Jan 2008 16:34 GMT

If you want row 1 to stay fixed, select row 2 & use Windows/ Freeze Panes.

If you want to freeze both rows and columns, if you select cell C3, for
example, before selecting Windows/ Freeze Panes, then it will freeze rows 1
and 2 and columns A and B. In other words it will freeze rows above and
columns to the left of the selected cell.

Signature

David Biddulph

> In Excel, how do I prevent a row from moving, like a subheader that I want
> to
> stay always visible at the top of my document?

Reply to this Message

Mike Rogers - 16 Jan 2008 16:42 GMT

Binmaru

Place you curser below the row you want to see all the time and
goto>Window>freeze panes.

Mike Rogers

> In Excel, how do I prevent a row from moving, like a subheader that I want to
> stay always visible at the top of my document?

Reply to this Message

ShaneDevenshire - 16 Jan 2008 16:43 GMT

Hi,

If you are asking how to lock titles at the top of the screen - put your
cursor on the row below the titles and choose Window, Freeze Panes.

If you are trying to freeze other rows on screen while being able to scroll
above or below them - there really is not way to do that.

Signature

Cheers,
Shane Devenshire

> In Excel, how do I prevent a row from moving, like a subheader that I want to
> stay always visible at the top of my document?

Reply to this Message