answersLogoWhite

0

Selecting cell B5. This is because every row above and every column to the left of the active cell are frozen.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

When you insert a column where does it automatically go?

The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.The column will go where the currently selected column is, pushing all columns to the right. So if column D was selected and you inserted a column, column D would become column E and the inserted column would now be column D.


How do you adjust the column width and or row height of many cells at once in Excel 2010?

Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.


What is the row height of Excel 2007?

By selecting an empty row and pressing Ctrl + 'Down arrow key', the selected cell will be the next item down the column. The row height in Excel 2010 is 1048576 cells.


How do you change the width if multiple column to have equal width?

Select all the columns you want to adjust the width for. Then through the menu or ribbons set the column width that you want. It will be applied to all of the selected columns.


To freeze both column headings and row titles select the cell that is the intersection of the column and row titles?

When you freeze, it freezes all rows above the active cell and all columns to the left of the active cell. The row and column that the active cell is in, does not get frozen. So, for example, to freeze Column A and Row 1, you would first put the cursor into cell B2.


Which is the correct process for selecting nonconsecutive columns?

There is one correct process for selecting nonconsecutive columns. Select the first column using the shift key, then press Ctrl and click for every other column desired after that.


How do you change width of selected column to automatically fit the widest entry in the column?

To change the width of a selected column to automatically fit the widest entry in programs like Microsoft Excel, you can double-click the right boundary of the column header. Alternatively, you can select the column, go to the "Home" tab, click on "Format," and then choose "AutoFit Column Width." This will adjust the column width to accommodate the longest entry in that column.


What does the width adjustment command do in excel?

The column width command adjusts the width of a column or selected range of columns.


How can you format a whole row or column at once?

Select the row by clicking on the row number first (or the column by clicking on the column letter). Once selected any formatting you change will apply in every cell selected. More than one row or column may be selected or any group of cells and the same will apply


How do you find the address of an excel cell?

The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.The address is based on the column and row that the cell is in. So the cell in Column K and Row 5, the cell is K5. When you have a cell selected, you will see the address in the name box.


What happens when the SUM button is clicked?

Excel will attempt to sum cells by selecting nearby cells which it presumes are the ones to be selected and summed. Usually this will be the cells above. If you select a range of cells and then click the Autosum button it will use the selected cells and sum them, putting the total at the bottom of the column, or it can do it for several columns, giving a total for each.


In Microsoft Excel what column do you Make a cell active to insert a new column between E and F?

A new column or row will always go where the active cell is, or in the place of the row(s)/Column(s) selected. So if you want to put a column between column E and column F, the new column will be where column F now is, so you select column F, or put the active cell in it. It is better to have it selected. To do that, either click on the heading of the column, of with the active cell in the column, press and hold the Ctrl key and press the spacebar.