Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 11th 05, 03:19 PM
Dave_86
 
Posts: n/a
Default How do I make a row or information, follow as you scroll down..?

How do I make a row or information, follow as you scroll down..?

I've seen spreadsheets that allow a row or rows of information follow along
the top of the screen as I scrolled down, so I didn't have to keep looking
back up to enter data in the correct column.

Thanks,
Dave



  #3   Report Post  
Old May 11th 05, 03:33 PM
David McRitchie
 
Posts: n/a
Default

Hi Dave,
See http://www.mvps.org/dmcritchie/excel/freeze.htm

For Display use Freeze Panes, select a cell past the
row and column you want to freeze. i.e. B2
then use Window (menu), Freeze Pane

For Printing under File, Page Setup, Sheet
Rows to repeat at top $1:$1
Columns to repeat at left $A:$A
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave_86" wrote in message ...
How do I make a row or information, follow as you scroll down..?

I've seen spreadsheets that allow a row or rows of information follow along
the top of the screen as I scrolled down, so I didn't have to keep looking
back up to enter data in the correct column.

Thanks,
Dave






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
how do I make a heading row "float" to follow the data as I scrol. ROOD Excel Worksheet Functions 1 March 30th 05 11:11 PM
How do I make the fill color of a cell on one sheet follow the co. SteelerfanDan Excel Worksheet Functions 2 March 8th 05 09:29 PM
how do i make a chart using text information? danielle Excel Worksheet Functions 5 February 26th 05 09:21 PM
List ? - How do I make information in one cell determine list to u Brad_A Excel Worksheet Functions 1 January 18th 05 04:10 PM
make list of information from different cells ACTLibrarian Excel Worksheet Functions 1 November 4th 04 09:18 PM


All times are GMT +1. The time now is 10:07 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017