PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup How to keep first row in spreadsheet

Reply

How to keep first row in spreadsheet

 
Thread Tools Rate Thread
Old 07-01-2005, 06:25 PM   #1
=?Utf-8?B?TWlzc3Rvcnk4ODg=?=
Guest
 
Posts: n/a
Default How to keep first row in spreadsheet


How can I keep my first row on my spreadsheet? For instance, row 1 will
always stay on even when I'm scrolling down it.
  Reply With Quote
Old 07-01-2005, 08:08 PM   #2
RWN
Guest
 
Posts: n/a
Default Re: How to keep first row in spreadsheet

Select A2 and "Window->Freeze Panes"

--
Regards;
Rob
------------------------------------------------------------------------
"Misstory888" <Misstory888@discussions.microsoft.com> wrote in message
news:289F8B29-F9A3-41E6-9E2A-8C0E3B4AFBD0@microsoft.com...
> How can I keep my first row on my spreadsheet? For instance, row 1 will
> always stay on even when I'm scrolling down it.



  Reply With Quote
Old 07-01-2005, 10:35 PM   #3
Gord Dibben
Guest
 
Posts: n/a
Default Re: How to keep first row in spreadsheet

Select A2 and click on Window>Freeze Panes" to freeze Row 1

To freeze column A also select B2.


Gord Dibben Excel MVP

On Fri, 7 Jan 2005 10:25:03 -0800, "Misstory888"
<Misstory888@discussions.microsoft.com> wrote:

>How can I keep my first row on my spreadsheet? For instance, row 1 will
>always stay on even when I'm scrolling down it.


  Reply With Quote
Old 13-01-2005, 11:20 PM   #4
Jack in the UK
Guest
 
Posts: n/a
Default Re: How to keep first row in spreadsheet


Misstory888 wrote:
> *How can I keep my first row on my spreadsheet? For instance, row 1
> will
> always stay on even when I'm scrolling down it. *


If you prefer you can always split the screen

Jack



--
Jack in the UK
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1335086.html



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off