0
In what row with the active cell B1 be after you insert a new row?
Wiki User
∙ 14y ago
If you insert a new row above B1, the cell contents will move to B2 in the second row. If you insert a new row below B1, the cell contents will not move.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is on the shortcut menu allows you to insert rows between rows that already contain data?
Select any cell in the row where you want the new row to be, press Alt+I (for insert) then press R (for row). To insert a new column at the selected cell, press C instead of R.
Which cell becomes active when you press the enter key?
Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.Usually the cell below what is currently the active cell. If you are in the last row, it will stay in the same cell.
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.
When you insert a cell into a row all data in that row is shifted down true or false?
False. If you insert just one cell, then all data below it, not the full row, will be pushed down. If you insert a full row, then the whole row will be pushed down.
What is the default value of a row and column in Microsoft Excel?
There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.There is no default value for rows and columns. All cells are blank and the cursor is always in column A and row 1 when a new worksheet loads, making cell A1 the active cell.
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.
The intersection of a row and column in a table?
In a Excel table (or spreadsheet), the intersection of a column and row is called a "cell." Where a column and row intersect you get a cell. The cell is reference by the column letter and the row number. So, for example, where column C meets row 15, is cell C15. You classify it by its column letter followed by the row number. Such as D3, B2, C5, etc.
How do you add a new row in excel 2007?
Click where you want to insert a new row, then right click and click on insert and pick entire row, click ok.
How do you insert a row between rows 3 and rows 4?
Select row 4 first. Then insert a new row, using the insert option on the cells group on the Home tab. The current row 4 will be pushed down to become row 5 and you will have a new blank row 4. Row 3 will be as it was.
What key do you press to move the active cell in a row?
There are many keys that can change the active cell's position. To stay in the one row, the left or right arrows will move one cell or use the Home key to get to the start of a row.
If you want to add a new row onto your spreadsheet what do you do?
Put the cursor into a cell on the row where the you want the new row to be, or put the cursor over the row number and click on it when you see an arrow pointing towards the row. So if you want a row between row 3 and row 4, put the cursor in or select row 4. Then go to the Insert menu and pick "row" or right-click the mouse and pick Insert off the shortcut menu and then pick Entire Row.
What KEYS Selects the cell at the beginning of the row that contains the active cell?
Home
