ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   View row headers while scrolling (https://www.excelbanter.com/excel-discussion-misc-queries/23191-view-row-headers-while-scrolling.html)

Newsgirl

View row headers while scrolling
 
I took a course in January and was taught there was a way of being able to
view the row headers while scrolling, but now I can't remember. How do you do
this.
--
Yours truly - Canadian Newsgirl

JulieD

Hi

click in A2 and choose window / freeze panes

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Newsgirl" wrote in message
...
I took a course in January and was taught there was a way of being able to
view the row headers while scrolling, but now I can't remember. How do you
do
this.
--
Yours truly - Canadian Newsgirl





hi.
select Cell A2.
then on the toolbar click WindowFreeze Pane.
accually, you can freeze rows and columns. any where you
place the cellpointer and click freeze pane, all rows
above and all columns to the left will freeze.
to remove freeze pane click windowunfreeze pane.
There is an icon for it too.

-----Original Message-----
I took a course in January and was taught there was a way

of being able to
view the row headers while scrolling, but now I can't

remember. How do you do
this.
--
Yours truly - Canadian Newsgirl
.



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

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