Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HELP
 
Posts: n/a
Default Stationery Column and Row

How do I make the first column and row of a spreadsheet stationery so that I
can stroll down and still see the headings of the first column and row? Can
this be done?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Select B2

Menu WindowFreeze Panes

--
HTH

Bob Phillips

"HELP" wrote in message
...
How do I make the first column and row of a spreadsheet stationery so that

I
can stroll down and still see the headings of the first column and row?

Can
this be done?



  #3   Report Post  
 
Posts: n/a
Default

Hi
Use Window/Freeze Panes. Select cell A2 first!

--
Andy.


"HELP" wrote in message
...
How do I make the first column and row of a spreadsheet stationery so that
I
can stroll down and still see the headings of the first column and row?
Can
this be done?



  #4   Report Post  
JulieD
 
Posts: n/a
Default

Hi

click in cell B2 and choose window / freeze panes

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"HELP" wrote in message
...
How do I make the first column and row of a spreadsheet stationery so that
I
can stroll down and still see the headings of the first column and row?
Can
this be done?



  #5   Report Post  
 
Posts: n/a
Default

(Missed the row and column bit! More caffeine required, methinks.)

--
Andy.


<Andy B wrote in message ...
Hi
Use Window/Freeze Panes. Select cell A2 first!

--
Andy.


"HELP" wrote in message
...
How do I make the first column and row of a spreadsheet stationery so
that I
can stroll down and still see the headings of the first column and row?
Can
this be done?





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



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

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

About Us

"It's about Microsoft Excel"