ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stationery Column and Row (https://www.excelbanter.com/excel-worksheet-functions/23659-stationery-column-row.html)

HELP

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?

Bob Phillips

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?





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?




JulieD

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?





(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?







All times are GMT +1. The time now is 08:21 AM.

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