answersLogoWhite

0

select 2 rows, the no. of rows you select will be the no. of rows to be inserted

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you insert multiple rows in Excel?

If you select more than one row and then insert, Excel inserts the amount of rows selected. So the first thing to do is to select 20 rows. Then you can insert rows and it will put in 20 new rows for you.


Excel rows are inserted the selected row?

You can insert rows above or below the selected row. You select what you would like to do on the insert worksheet rows menu.


What do you do when inserting rows and deleting ranges in Excel?

To insert rows, you select the row(s) where you want the new row(s) to go. You can even just select a cell in the row(s) you want. So if you wanted to insert 2 new rows between row 1 and row 2, you could select a cell in row 2 and row 3, or select both of those rows. Right click, and pick Insert and choose to insert an Entire row. The existing rows 2 and 3 will be pushed down to become rows 4 and 5, and 2 news rows will be in row 2 and row 3. To delete a range, select the cells in the range. To delete the contents, press the Delete key. To get rid of the cells completely, right click and pick Delete on the shortcut menu. You can then choose to move the cells below up into the position where the range was, or move the cells to the right of them into the position of those cells.


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.


Can rows can be added to a worksheet after data has been entered?

Yes. Excel is very flexible, as are all spreadsheets, so you can easily insert new rows and columns when data has already been entered. You just need to select the row you want the new row to be in. The content of that row will be pushed down into the next row and a new blank row will be inserted. You can also select multiple rows and insert them.


True or false insert rows and columns from the shortcut menu?

That is true. There is an insert option on the shortcut menu which can allow you to insert rows and columns.


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 step would you follow to insert a table with 5 lows and 3 columns in your document?

To insert a table with 5 rows and 3 columns into your document, you can typically follow these steps: go to the "Insert" tab in your document editor, find the "Table" option, select the dimensions (5 rows, 3 columns), and insert the table into your document. You can then populate the table cells with your desired content.


How will you add rows and columns to an existing work sheet?

To add rows to an existing worksheet, right-click on the row number where you want the new row to appear and select "Insert" from the context menu. For adding columns, right-click on the column letter where you want the new column to be inserted and choose "Insert." You can also use the ribbon menu by selecting the "Home" tab, then clicking on "Insert" in the Cells group to add either rows or columns.


Describe the process to insert some blank rows at the top of your?

Describe the process to insert some blank rows at the top of your spreadsheet


How do you get the rows to line up in excel?

This question is not clear. All rows already are lined up. If you are trying to align the contents of cells, you can highlight the column you want to align and select the same alignment for all rows in that column.


What key can you repeatedly press to continue inserting rows after inserting a single row with the Insert command?

Click on the Insert Sheet Rows button.