0
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
∙ 7y ago
Wiki User
∙ 9y agoYou 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
∙ 9y agoYou 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
∙ 12y agoselect the below cell of freeze cell and click on freeze panes again click on freeze panes button than we see freeze the cell.
Add your answer:
Earn +20 pts
What cell do you activate to freeze rows 1 - 5 in an Excel worksheet?
You would make cell A6 the active cell and then activate the freeze panes option.
How do you stop the first cell of Excel and where ever you go it is seen?
The question is not clear, but this is my best guess for an answer. There is no way to freeze only a single cell. Select cell B2 and freeze panes. In Excel 2007, on the View Tab, in the Windows section, click on Freeze Panes. Then, select the first option to freeze columns to the left and rows above the selected cell.
What is the cell address of the last cell of the Microsoft Excel 2003?
The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.
What is the fullform of excel?
executable cell
How do you lock the first row in excel so you always see the label?
Select cell A2. Then, on the menu bar, select Window, Freeze Panes.
What is cell aligement in Excel?
You can align an Excel cell to left, right, and center.
How do you freeze the top row of the current worksheet?
In Excel 2003 and earlier, place your cursor in row 2 and click on Freeze Panes. The Freeze Pains command will freeze the rows above the cursor. Excel 2007 offers an option to freeze top row no matter where your cursor is located.
What is a number that can be entered into a cell on Excel?
Which of the following is a number that can be entered into a cell?
How do you lock the top row and left column in Microsoft excel as in when you scroll down or right how do you get the top row 1 and the left column A to remain visible?
Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.
Format cell in Excel?
To format a cell in excel right click on it, then on the thing that pops up click on format cell
What does it mean cell colour Excel?
Cell color refers to the color of the square you have selected in Excel.
What does it mean if you see about getting excel in business?
Excel means egg cell or sperm cell.
