Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default format question

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 287
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 913
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default 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.
  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 39
Default 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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format question Richard Excel Discussion (Misc queries) 3 March 8th 08 03:00 PM
Format % Question Stan Atshuller Excel Worksheet Functions 3 October 2nd 06 08:54 PM
Format Question VegasBurger Excel Worksheet Functions 2 June 24th 06 06:34 PM
Format question Luis Excel Discussion (Misc queries) 1 June 22nd 05 02:42 PM
Format Question Please WILLIAM DAVIS Excel Discussion (Misc queries) 2 January 7th 05 01:45 AM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"