0
What cell should be selected to freeze the cells in column A and rows 1 through 4 befoe selecting Freeze Panes?
Wiki User
∙ 9y ago
Selecting cell B5. This is because every row above and every column to the left of the active cell are frozen.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
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.
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.
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.
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.
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.
Which is the correct process for selecting an entire column?
Click on the letter at the top of a column or put the cursor in any cell in the column and press and hold the Ctrl key and then press the space bar.
To hide a column in Excel begin by selecting the column and then what?
You can press Ctrl and the zero key. Ctrl-Shift-0 will unhide it. There is also the column options which include hiding and showing columns.
