answersLogoWhite

Top Answer
User Avatar
Wiki User
Answered 2010-04-12 03:21:45

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

001
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Related Questions


By default, inserted columns go where the selected columns are, pushing the existing ones to the right. Inserted rows, push existing rows down. If you have an entire column selected, then you cannot insert rows, as it would push everything off the worksheet, because each existing row has a cell selected in it.


New rows go where the currently selected rows are and the existing rows are pushed down. So if you selected row 3 and inserted, there would be a new row 3 and what was row 3 would now be row 4, with all rows below it also being pushed down.


All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.All rows below the one inserted will shift down a row when the insertion happens. The rows above the inserted row are not affected.


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.



The last rows of excel 2007 is 1,048,576


I do not understand what you are asking, but here is a possible response.If you want to insert multiple rows in an Excel workbook, click on the row number after which you would like to insert the blank rows. Then, click and hold to drag down the number of rows you want and insert blank rows.EXAMPLE: You want to add three blank rows between rows 5 and 6.Click on the number five (row header) to the left of row five.Hold down the mouse key and highlight rows 6 through 8 (that will highlight three rows).Go to the section in your version of Excel that inserts rows (in Excel 2007, that is the Home tab, Cells section, Insert -- click on insert cells).Observe that you have inserted three blank cells in your workbook. The old row 6 is now row 9.


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.


Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.Sorting only affects the selected area in a spreadsheet. The cells in the rows of columns selected will move. Cells on the same row but not in the columns that have been selected will not move.


That depends on the version you have. The standard amount of rows has been 65,536 rows, up to Excel 2003. Since version 2007 of Excel the last row is 1048576. Excel 5 and 95 had 16,384 rows.


Rows are identified by numbers. The numbers appear down the left side of the spreadsheet. When a row is selected, or any cells in a row are selected, the row header changes colour to indicate that.


Yes, whatever row or rows are selected are where the new row or rows will appear. The existing row or rows will be pushed down.


To display a row that was hidden, select the row before and after the hidden row. (ie - if row 5 is hidden, select row 4 and 6) Once you have selected those rows, right click in the highlighted area and select UnHide.


Click on the label for the row you want, then hold 'Ctrl' and click on any extra row you want. You can also press the Shift key and the spacebar to select the current row or rows, if cells from more than one row are already selected.


Row numbers for the hidden rows will be missing on the side of the worksheet.


Formulas can be copied down and across, so in one sense all formulas can be row based. There are some that look at data in rows, if that is what you are referring to. Functions like HLOOKUP work on a row basis. The TRANSPOSE function can work with rows and columns, switching them. There is a function called ROW for detecting the current row and another called ROWS for calculating how many rows are in a range. OFFSET enables data to be selected in rows. All of these and others are Lookup and Reference functions.


When you select a column header in Excel, all the cells in that column are selected. This means 65536 cells (the maximum number of rows in Excel). Similarly, if you select a row header, this will select 256 cells (the maximum number of columns in Excel). For more information on Excel Size and Cells: http://www.excel-hocam.com/mod/resource/view.php?id=18&username=guest


Go to the top tool bar where it says insert, click on it and select rows. it will insert a row above the row you have highlighted.


In Excel 2007 it is 1,048,576 rows. If you really wanted to ask what is the height of a row, then the answer is 15.


They are what they say. A row is a line of cells horizontally and a column is a vertical row of cells.



That depends on the version. In Excel 2000 and Excel 2003, the maximum is 256 columns and 65,536 rows. For Excel 2007, the limit is 16,384 columns and 1,048,576 rows.


as many as number of rows in the version that is used less one row for col labl. is the max no of rows.


To number your rows in Excel, put a '1' in the first row, for instance in cell a1, the formula '=a1+1' in the second row, and then copy that formula to each additional row you want to number. Be careful, though, as inserting and deleting rows will mess the sequence up, and you will need to fix it as needed.


If you have just inserted a row, then pressing F4 will continue to insert new rows.



Copyright ยฉ 2021 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.