ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i set half an excell sheet to now scroll with the rest. (https://www.excelbanter.com/excel-discussion-misc-queries/40362-how-do-i-set-half-excell-sheet-now-scroll-rest.html)

greasepain37

how do i set half an excell sheet to now scroll with the rest.
 
http://office.microsoft.com/en-us/te...186511033.aspx with that
check book register. the top few lines do not scroll when i scroll teh page.
how do i repeat that option

KL

Select the cell under the row and to the right of the column you want
immobilized and then go to menu WindowFreeze Panes

Regards,
KL


"greasepain37" wrote in message
...
http://office.microsoft.com/en-us/te...186511033.aspx with that
check book register. the top few lines do not scroll when i scroll teh
page.
how do i repeat that option




CyberTaz

Am not familiar with that template, but it sounds like what you are looking
for is Freeze Panes.

Select a cell in the row _below_ the ones you want to freeze (note that
Columns to the left of that cell will also be frozen), then go to
WindowFreeze Panes. You can also turn the feature off any time... The same
command will read as Unfreeze Panes.

HTH |:)



On 8/14/05 11:31 AM, in article
, "greasepain37"
wrote:

http://office.microsoft.com/en-us/te...186511033.aspx with that
check book register. the top few lines do not scroll when i scroll teh page.
how do i repeat that option



Monte

Try "Freeze Panes". It's located under "Window".


"greasepain37" wrote:
http://office.microsoft.com/en-us/te...186511033.aspx with that
check book register. the top few lines do not scroll when i scroll teh page.
how do i repeat that option


All times are GMT +1. The time now is 02:23 AM.

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