Header Row 1 is displayed in split screen - Way to keep

  • Thread starter Thread starter Bob Reynolds
  • Start date Start date
B

Bob Reynolds

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display selected cell at bottom of screen 2
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Wandering Split 4
Splitting a file into multiple workbooks 2
Exclude header row when copying autofilter results? (XL2003) 1
Copying header rows and inserting them into all worksheets 6
Ensuring Selected Cell is Visible on Screen 7
How to split an excel workbook in code and data 2

Back
Top