ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I make the top row of my spreadsheet non-scrollable? (https://www.excelbanter.com/excel-discussion-misc-queries/69896-how-can-i-make-top-row-my-spreadsheet-non-scrollable.html)

Stumped

How can I make the top row of my spreadsheet non-scrollable?
 
I'm trying to set up the page so that the top line doesn't scroll off the
screen when the vertical scroll bar is used.

qwopzxnm

How can I make the top row of my spreadsheet non-scrollable?
 

Set your curser below and to the right of the cells you don't want to
scroll and then go up to "Window" then "Freeze Panes"

-Matt


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=509151


Stumped

How can I make the top row of my spreadsheet non-scrollable?
 
Thank-you!

"qwopzxnm" wrote:


Set your curser below and to the right of the cells you don't want to
scroll and then go up to "Window" then "Freeze Panes"

-Matt


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=509151




All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com