Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |