0
How do you Select row 3 and freezer rows 1 and 2 in place in excel?
Wiki User
∙ 9y ago
You can select the entire row by clicking on the row number on the left end of the row. Then you can choose the Freeze Panes option. To freeze the first two rows you don't need to select all of row 3. Put the cursor in cell A3 and then do Freeze Panes and rows 1 and 2 will be frozen.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is the Microsoft Excel command that enables you to select one or more rows or columns and lock them into place?
Freeze Panes
How do you collapse rows in Excel?
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.
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.
In Excel what key do you hold down if two rows are adjacent to one another to avoid selecting all the rows?
Pressing the Shift key while clicking on the row header will select rows that are adjacent, selecting all rows between the first and last row you select. Pressing the Ctrl key while clicking on the row header will select rows that are not adjacent.
What are rows identified as in Excel?
Rows are a horizontal arrangement of cells. All rows are numbered. The amount of rows depend on the version of Excel you have. Versions of Excel from 2007 have 1,048,576 rows. Before that, there was 65,536 rows.
How many rows should you select if you want to insert two rows?
select 2 rows, the no. of rows you select will be the no. of rows to be inserted
Number of rows in Microsoft Excel 2003?
There are 256 Columns and 65536 Rows in Excel 2003.
How many rows and columns in Excel 2000?
In Excel 97 there were 256 columns and 65536 rows.
How can I increase to more than 65536 rows in Excel 2007?
Excel 2007 has 1,048,576 rows, so it has more than 65,536 rows. Excel 2003 had 65,536 rows and it was not possible to increase that.
How many rows and columns in Excel 2010?
There are 1,048,576 rows and 16,384 columns in Excel 2010
How do you select nonadjacent columns or rows in excel?
After selecting the first row or column, press and hold the ctrl key and click on the header of the next row or column you want to select.
