How do you freeze an excel cell?

Question

Wiki User · Answer

You use the Freeze Panes option. When you do it, columns to the left of the active cell and rows above the active cell will be frozen. So if you wanted to freeze just the first column, you would make B1 the active cell before freezing the panes. To freeze just the first row, you would make A2 the active cell before freezing the panes. To freeze both the first column and first row, the you would make cell B2 the active cell before freezing the panes.

Wiki User

∙ 8y ago

Wiki User · Answer

You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.

Wiki User · Answer

You use the Freeze Panes option. Wherever the active cell is when you use it, all columns to the left of it will be frozen, as will all rows above it. You will find it on the Window menu in versions up to Excel 2003 and on the View tab on the ribbon from versions of Excel from 2007 onwards.

Wiki User · Answer

select the below cell of freeze cell and click on freeze panes again click on freeze panes button than we see freeze the cell.

How do you freeze an excel cell?

What else can I help you with?

What cell do you activate to freeze rows 1 - 5 in an Excel worksheet?

How do you stop the first cell of Excel and where ever you go it is seen?

What is the cell address of the last cell of the Microsoft Excel 2003?

What is the fullform of excel?

How do you lock the first row in excel so you always see the label?

What is cell aligement in Excel?

How do you freeze the top row of the current worksheet?

What is a number that can be entered into a cell on Excel?

How do you time stamp a cell in Microsoft Excel?

What does it mean if you see about getting excel in business?

What does it mean cell colour Excel?

How do you freeze a line in a document on Microsoft Excel?

Resources

Top Categories

Product

Company