Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Header Row 1 is displayed in split screen - Way to keep
Hello,
I am using Excel as a database for a merge file and I have the screen split so that Row 1 is always visible. However some of the people it's been distributed to like to click in there and then it scrolls down, leaving them without the headers. Is there anyway to permanently freeze this first row in the split screen where they can't alter the display. I do need to have the worksheet unprotected because of a couple of macro's running. Thanks BOB REYNOLDS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Header Row 1 is displayed in split screen - Way to keep
I don't like Window|split for the same reason.
But I do like Window|Freeze panes. It doesn't allow the top (or left) frozen area to scroll independently. Bob Reynolds wrote: Hello, I am using Excel as a database for a merge file and I have the screen split so that Row 1 is always visible. However some of the people it's been distributed to like to click in there and then it scrolls down, leaving them without the headers. Is there anyway to permanently freeze this first row in the split screen where they can't alter the display. I do need to have the worksheet unprotected because of a couple of macro's running. Thanks BOB REYNOLDS -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Header Row 1 is displayed in split screen - Way to keep
Oh I love it. So simple but so elusive, thanks so much
Bob "Dave Peterson" wrote in message ... I don't like Window|split for the same reason. But I do like Window|Freeze panes. It doesn't allow the top (or left) frozen area to scroll independently. Bob Reynolds wrote: Hello, I am using Excel as a database for a merge file and I have the screen split so that Row 1 is always visible. However some of the people it's been distributed to like to click in there and then it scrolls down, leaving them without the headers. Is there anyway to permanently freeze this first row in the split screen where they can't alter the display. I do need to have the worksheet unprotected because of a couple of macro's running. Thanks BOB REYNOLDS -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split screen | Excel Discussion (Misc queries) | |||
split screen | Excel Discussion (Misc queries) | |||
Setting hyperlinked cells to be displayed at the top of the screen | Excel Discussion (Misc queries) | |||
Split Screen | Excel Worksheet Functions | |||
Value is not displayed on the screen | Excel Programming |