ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   freeze other columns when columns have been frozen already (https://www.excelbanter.com/excel-worksheet-functions/45243-freeze-other-columns-when-columns-have-been-frozen-already.html)

Freeze column

freeze other columns when columns have been frozen already
 
I'm trying to freeze a column after i've froze a row,and when i go to window
the only option i have left is "unfreeze panes". Can somebody explain to me
how to do it?thanks.

Gord Dibben

The freeze line is above and to the left of where you select a cell.

Columns and rows must be "frozen" at the same time.

i.e. to freeze row 1 and column A select B2 and WindowFreeze Panes.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 15:36:02 -0700, "Freeze column" <Freeze
wrote:

I'm trying to freeze a column after i've froze a row,and when i go to window
the only option i have left is "unfreeze panes". Can somebody explain to me
how to do it?thanks.




All times are GMT +1. The time now is 12:58 AM.

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