I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks
I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
Thanks
If you want to freeze the entire first row, with your cursor in Cell A1,
click on Windows|Freeze panes.
If you move your cursor to say C1 before doing this, not only will your
first row remain visible, but also Cols A-B will always remain visible (if
you scrool to the right)
"SeabeePlumber" wrote:
> I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
> Thanks
Select cell A2
Choose Windows>Freeze Panes
SeabeePlumber wrote:
> I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
> Thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Selecting A1 and Freeze Panes will freeze panes in the center of the window.
Not what OP asked for.
Select A2 to freeze row 1.
Select B2 to freeze row 1 and column A.
Everything above and to the left of selected cell will be frozen.
Gord Dibben Excel MVP
On Sun, 10 Apr 2005 10:17:02 -0700, Kassie <[email protected]>
wrote:
>If you want to freeze the entire first row, with your cursor in Cell A1,
>click on Windows|Freeze panes.
>
>If you move your cursor to say C1 before doing this, not only will your
>first row remain visible, but also Cols A-B will always remain visible (if
>you scrool to the right)
>
>"SeabeePlumber" wrote:
>
>> I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
>> Thanks
Thanks gordon, that was a bad lapsus latina
"Gord Dibben" wrote:
> Selecting A1 and Freeze Panes will freeze panes in the center of the window.
>
> Not what OP asked for.
>
> Select A2 to freeze row 1.
>
> Select B2 to freeze row 1 and column A.
>
> Everything above and to the left of selected cell will be frozen.
>
>
> Gord Dibben Excel MVP
>
>
>
> On Sun, 10 Apr 2005 10:17:02 -0700, Kassie <[email protected]>
> wrote:
>
> >If you want to freeze the entire first row, with your cursor in Cell A1,
> >click on Windows|Freeze panes.
> >
> >If you move your cursor to say C1 before doing this, not only will your
> >first row remain visible, but also Cols A-B will always remain visible (if
> >you scrool to the right)
> >
> >"SeabeePlumber" wrote:
> >
> >> I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
> >> Thanks
>
>
lapsus latina
Same like a brain-fart or a senior moment<g>
Gord
On Sun, 10 Apr 2005 11:57:02 -0700, Kassie <[email protected]>
wrote:
>Thanks gordon, that was a bad lapsus latina
>
>"Gord Dibben" wrote:
>
>> Selecting A1 and Freeze Panes will freeze panes in the center of the window.
>>
>> Not what OP asked for.
>>
>> Select A2 to freeze row 1.
>>
>> Select B2 to freeze row 1 and column A.
>>
>> Everything above and to the left of selected cell will be frozen.
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>>
>> On Sun, 10 Apr 2005 10:17:02 -0700, Kassie <[email protected]>
>> wrote:
>>
>> >If you want to freeze the entire first row, with your cursor in Cell A1,
>> >click on Windows|Freeze panes.
>> >
>> >If you move your cursor to say C1 before doing this, not only will your
>> >first row remain visible, but also Cols A-B will always remain visible (if
>> >you scrool to the right)
>> >
>> >"SeabeePlumber" wrote:
>> >
>> >> I'd like to keep my top line (Name, Date, Etc.) from scroling in Excel 2003?
>> >> Thanks
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks