Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title row to stay in place when scrolling down
I want to make the first few lines of my chart stay put when scrolling down
the page, for ex: in the excel template on Microsoft office called 'Loan amortization Schedule', lines 1-17 stay put when scrolling down. Can anybody tell me how to do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title row to stay in place when scrolling down
What version of Excel are you using?
Let's assume you want row 1 to remain visible when you scroll. Select cell A2 In Excel 2007 goto the View tabFreeze PanesFreeze Panes In earlier versions of Excel goto the menu WindowFreeze Panes -- Biff Microsoft Excel MVP "MS" wrote in message ... I want to make the first few lines of my chart stay put when scrolling down the page, for ex: in the excel template on Microsoft office called 'Loan amortization Schedule', lines 1-17 stay put when scrolling down. Can anybody tell me how to do that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Title row to stay in place when scrolling down
Select the cell just below the title area (e.g. cell A3). Then on the menu
select Window then Freeze Panes. That should do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep the title fixed while scrolling | Excel Worksheet Functions | |||
how do i create make the title always stay at top when scolling d. | Excel Discussion (Misc queries) | |||
How to set the row for title to be fixed during scrolling? | Excel Worksheet Functions | |||
How to set the row for title to be fixed during scrolling? | Excel Discussion (Misc queries) | |||
Title in dropdown menu to stay | Excel Discussion (Misc queries) |