| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row always in screen view
I have a long list of items and would like the top row to always be in screen
view. How do you do this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row always in screen view
utcam03
Select A2 and goto windowFreeze Panes Mike Rogers "utcam03" wrote: I have a long list of items and would like the top row to always be in screen view. How do you do this? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row always in screen view
Thank you for the reply, but that didn't work how I need it to. Then it
didn't allow me to scroll all the way back to the right when it I froze that row. Also, I want that row to always be at the top of the window when I scroll down- freezing didn't do that. Thanks "Mike Rogers" wrote: utcam03 Select A2 and goto windowFreeze Panes Mike Rogers "utcam03" wrote: I have a long list of items and would like the top row to always be in screen view. How do you do this? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row always in screen view
You did select A2, right?
The rule for freezing panes is.........everything above and left of the selected cell will remain in view as you scroll down or across. Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 09:02:01 -0800, utcam03 wrote: Thank you for the reply, but that didn't work how I need it to. Then it didn't allow me to scroll all the way back to the right when it I froze that row. Also, I want that row to always be at the top of the window when I scroll down- freezing didn't do that. Thanks "Mike Rogers" wrote: utcam03 Select A2 and goto windowFreeze Panes Mike Rogers "utcam03" wrote: I have a long list of items and would like the top row to always be in screen view. How do you do this? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row always in screen view
I played with it some more and got it to work.
Thanks "Gord Dibben" wrote: You did select A2, right? The rule for freezing panes is.........everything above and left of the selected cell will remain in view as you scroll down or across. Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 09:02:01 -0800, utcam03 wrote: Thank you for the reply, but that didn't work how I need it to. Then it didn't allow me to scroll all the way back to the right when it I froze that row. Also, I want that row to always be at the top of the window when I scroll down- freezing didn't do that. Thanks "Mike Rogers" wrote: utcam03 Select A2 and goto windowFreeze Panes Mike Rogers "utcam03" wrote: I have a long list of items and would like the top row to always be in screen view. How do you do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I Autofit To Screen Size | Excel Worksheet Functions | |||
| Bottom of spreadsheet hidden in full screen view | Excel Discussion (Misc queries) | |||
| view fonts and size as you change them on the screen like corel | Excel Worksheet Functions | |||
| Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
| Can't view text boxes in Excel on screen | Excel Worksheet Functions | |||
Linear Mode
