| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
keep first row fixed
Hi, sorry might be the wrong place to ask question. I have a very large excel spreadsheet that scrolls down. date name etc 1/1/05 John 2/1/-5 andrew I would like the headings (a1, b1...)of the columns to remain static so when I scroll several pages down I know what the names of the rows are. Is there a way around this andrewm -- andrewm ------------------------------------------------------------------------ andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130 View this thread: http://www.excelforum.com/showthread...hreadid=384822 |
|
#2
|
|||
|
|||
|
Andrew, Highlight row 2 Go to Window Split HTH. -- greg7468 ------------------------------------------------------------------------ greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031 View this thread: http://www.excelforum.com/showthread...hreadid=384822 |
|
#3
|
|||
|
|||
|
Click on Row 1 so that whole row 1 is highlighted. Then goto the menu and select WindowsFreeze Pane. Do the same to Unfreeze. Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=384822 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fixed string length,even other record is copied | Excel Discussion (Misc queries) | |||
| Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| Export to fixed width text file | Excel Discussion (Misc queries) | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
