ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   freezing panes (https://www.excelbanter.com/excel-discussion-misc-queries/203317-freezing-panes.html)

SteW

freezing panes
 
Hi all

I have a work Sheet with dates running accross the Row 1 and in title
list running down Column A. I ONLY SEEM TO BE ABLE TO FREEZE THE COLUMN OR
THE ROW BUT NOT BOTH. IS THIS CORRECT

STEW

Mike H

freezing panes
 
Stew,

Select (say) B2 and click 'Window' Freeze panes and both Row 1 and Column 1
will be frozen.

Mike

"stew" wrote:

Hi all

I have a work Sheet with dates running accross the Row 1 and in title
list running down Column A. I ONLY SEEM TO BE ABLE TO FREEZE THE COLUMN OR
THE ROW BUT NOT BOTH. IS THIS CORRECT

STEW


SteW

freezing panes
 
Thanks Mike

"Mike H" wrote:

Stew,

Select (say) B2 and click 'Window' Freeze panes and both Row 1 and Column 1
will be frozen.

Mike

"stew" wrote:

Hi all

I have a work Sheet with dates running accross the Row 1 and in title
list running down Column A. I ONLY SEEM TO BE ABLE TO FREEZE THE COLUMN OR
THE ROW BUT NOT BOTH. IS THIS CORRECT

STEW


Mike H

freezing panes
 
Your welcome and thanks for the feedback

"stew" wrote:

Thanks Mike

"Mike H" wrote:

Stew,

Select (say) B2 and click 'Window' Freeze panes and both Row 1 and Column 1
will be frozen.

Mike

"stew" wrote:

Hi all

I have a work Sheet with dates running accross the Row 1 and in title
list running down Column A. I ONLY SEEM TO BE ABLE TO FREEZE THE COLUMN OR
THE ROW BUT NOT BOTH. IS THIS CORRECT

STEW



All times are GMT +1. The time now is 07:45 AM.

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