Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a row or information, follow as you scroll down..?
|
#2
|
|||
|
|||
place the cursor below and to the right of what you want to "freeze"
windowfreeze panes -- Don Guillett SalesAid Software "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 |
#3
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a heading row "float" to follow the data as I scrol. | Excel Worksheet Functions | |||
How do I make the fill color of a cell on one sheet follow the co. | Excel Worksheet Functions | |||
how do i make a chart using text information? | Excel Worksheet Functions | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |