ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   'Floating' cells (https://www.excelbanter.com/new-users-excel/173393-floating-cells.html)

Squaralina

'Floating' cells
 

Hello,

I'm sorry if this is obvious, or might seem easy to be found but I've
resorted to asking in desperation. I don't know the correct term for
what I want to do so I haven't been able to search successfully for it
and my IT department has quoted me FOUR weeks to contact me back }: (

I want to know how to create 'floating' titles to columns and rows - so
when I scroll down or across, the top cells will stay in place and move
down over the other cells, so I can see, on a big spreadsheet, what my
columns and rows are called.

Many thanks in advance...




--
Squaralina

George Gee

'Floating' cells
 
If you want the first row, and the first column
to remain visible as you scroll:

Select cell B2 Window Freeze Panes.

George Gee


"Squaralina" wrote in message
...

Hello,

I'm sorry if this is obvious, or might seem easy to be found but I've
resorted to asking in desperation. I don't know the correct term for
what I want to do so I haven't been able to search successfully for it
and my IT department has quoted me FOUR weeks to contact me back }: (

I want to know how to create 'floating' titles to columns and rows - so
when I scroll down or across, the top cells will stay in place and move
down over the other cells, so I can see, on a big spreadsheet, what my
columns and rows are called.

Many thanks in advance...




--
Squaralina





All times are GMT +1. The time now is 10:19 AM.

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