Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Line on top
 
Posts: n/a
Default 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.
  #3   Report Post  
ww
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 05:12 AM
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"