I'm working in a large spreadsheet. I want to see the column headings stay
on top of my spreasheet as I'm scrolling down thru multiple pages.
Thank you very much
I'm working in a large spreadsheet. I want to see the column headings stay
on top of my spreasheet as I'm scrolling down thru multiple pages.
Thank you very much
Select a cell in column A in the row below the heading rows.
Then select Windows | Freeze panes
regards
Trevor
"SunnyLee" <[email protected]> wrote in message
news:[email protected]...
> I'm working in a large spreadsheet. I want to see the column headings
> stay
> on top of my spreasheet as I'm scrolling down thru multiple pages.
>
> Thank you very much
Use "Freeze Panes".
This old post should help explain:
http://tinyurl.com/2qdzt
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"SunnyLee" <[email protected]> wrote in message
news:[email protected]...
> I'm working in a large spreadsheet. I want to see the column headings
stay
> on top of my spreasheet as I'm scrolling down thru multiple pages.
>
> Thank you very much
"SunnyLee" wrote:
> I'm working in a large spreadsheet. I want to see the column headings stay
> on top of my spreasheet as I'm scrolling down thru multiple pages.
>
> Thank you very much
Thank you so much Trevor...you made my day and this info is certainly going
to help me at work.
Lee
"Trevor Shuttleworth" wrote:
> Select a cell in column A in the row below the heading rows.
>
> Then select Windows | Freeze panes
>
> regards
>
> Trevor
>
>
> "SunnyLee" <[email protected]> wrote in message
> news:[email protected]...
> > I'm working in a large spreadsheet. I want to see the column headings
> > stay
> > on top of my spreasheet as I'm scrolling down thru multiple pages.
> >
> > Thank you very much
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks