Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I define a line to appear on top, regardless of scrolling d
How do I define a line to appear on top, regardless of scrolling down?
I simply need that the "title" (top) line will remain in my view while scrolling down. |
#2
|
|||
|
|||
position cursor under and to the right of the area desiredwindowfreeze
panes -- Don Guillett SalesAid Software "Line on top" <Line on wrote in message ... How do I define a line to appear on top, regardless of scrolling down? I simply need that the "title" (top) line will remain in my view while scrolling down. |
#3
|
|||
|
|||
Go your titles line in Column A and click on WindowsFreeze panes.
If you also want to continue to see Column A as you scroll to the right you can use WindowsFreeze panes in Column B idea. "Line on top" wrote: How do I define a line to appear on top, regardless of scrolling down? I simply need that the "title" (top) line will remain in my view while scrolling down. |
#4
|
|||
|
|||
You would click on the row below the titles row and then freeze panes.
If you click on row 1, the freeze line will be mid-window. B1 to freeze row 1. B2 to freeze row 1 and column A i.e. everything above and left of the selected cell will be frozen. Gord Dibben Excel MVP On Wed, 23 Mar 2005 06:03:01 -0800, "ww" wrote: Go your titles line in Column A and click on WindowsFreeze panes. If you also want to continue to see Column A as you scroll to the right you can use WindowsFreeze panes in Column B idea. "Line on top" wrote: How do I define a line to appear on top, regardless of scrolling down? I simply need that the "title" (top) line will remain in my view while scrolling down. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |