| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Beginners Question setting up spreadsheet
Hello, I have a spreadsheet and the top roll has information that I need to be able to see when I scroll down. How do I set it up so when I scroll down the top roll or top couple of roll remain in place. Thanks PappyJoe -- PappyJoe ------------------------------------------------------------------------ PappyJoe's Profile: http://www.excelforum.com/member.php...o&userid=36936 View this thread: http://www.excelforum.com/showthread...hreadid=566483 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Beginners Question setting up spreadsheet
If the data you want visible is in row 1 then select row 2, go to the window menu, then click on split, then go to window menu and click on freeze pane. -- Steel Monkey ------------------------------------------------------------------------ Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051 View this thread: http://www.excelforum.com/showthread...hreadid=566483 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Beginners Question setting up spreadsheet
Thanks, I tried that but when I did rolls 4-7 disappeared and just the opposite of what I wanted to happen, happened. The bottom part of my spread sheet froze and the top part would scroll. I must be doing something wrong. PappyJoe -- PappyJoe ------------------------------------------------------------------------ PappyJoe's Profile: http://www.excelforum.com/member.php...o&userid=36936 View this thread: http://www.excelforum.com/showthread...hreadid=566483 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Beginners Question setting up spreadsheet
I got it. Once I changed the View from page layout to normal it worked. Thanks -- PappyJoe ------------------------------------------------------------------------ PappyJoe's Profile: http://www.excelforum.com/member.php...o&userid=36936 View this thread: http://www.excelforum.com/showthread...hreadid=566483 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Beginners Question setting up spreadsheet
WindowFreeze Panes is enough.
You don't need the Split. Split and Freeze Panes are two separate functions. Gord Dibben MS Excel MVP On Sun, 30 Jul 2006 21:36:33 -0400, Steel Monkey wrote: If the data you want visible is in row 1 then select row 2, go to the window menu, then click on split, then go to window menu and click on freeze pane. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet Security | Excel Discussion (Misc queries) | |||
| Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
| Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
| Question regarding dynamic range setting | Excel Worksheet Functions | |||
| spreadsheet design question | New Users to Excel | |||
Linear Mode
