ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   format question (https://www.excelbanter.com/new-users-excel/196480-format-question.html)

Bassman

format question
 
Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!

daddylonglegs

format question
 
If you have headers in row 1 select A2 and use Window Freeze Panes

"Bassman" wrote:

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!


Lars-Åke Aspelin[_2_]

format question
 
On Sun, 27 Jul 2008 10:54:13 -0700 (PDT), Bassman
wrote:

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!



Have a look at "Freeze panes" in the Excel help.

Hope this helps / Lars-Åke

Ben M. Schorr - MVP (OneNote)

format question
 
Freeze Panes. The exact way to do it depends a little on the version of
Excel you're using. Check the Help system in Excel.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"Bassman" wrote in message
:

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!



Bassman

format question
 
On Jul 27, 11:09*am, Lars-Åke Aspelin
wrote:
On Sun, 27 Jul 2008 10:54:13 -0700 (PDT), Bassman

wrote:
Hello,
How do I lock a row from moving when I scroll? *I what the header to
stay put!


Have a look at "Freeze panes" in the Excel help.

Hope this helps / Lars-Åke


I knew it would be easy. I have spent a lot of time trying to figure
out. I have a sheet someone else sent me...(my excel teacher) that
looks great and I have been looking every where so I can add to my new
project at work. I have not tried yet but I am sure I can handle now.


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com