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.
It is inserted above it.
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.
Not sure why you would want to do that, but Excel supports it if that is what you decide to do.
many a time you may require to add a row of data or a coloumn of data which you forgot to enter earlier .excel proveides you the facility to insert rows or columns onto the sxisting worksheet very easily .it is that inserting a row of data will shift the rest of the rows down and cause the ladt row of the worksheet ,the rest of the columns shift right ,if there is any data in the last row or column of the worksheet that will be lost .
Right click on the cell, select format cells, select currency and $.
It is often referred to as the row header or row heading or row number.
Select cell A2. Then, on the menu bar, select Window, Freeze Panes.
Clicking on the header of the row or column will select it. So for example, to select row 3, click on the 3 at the start of it or to select column R, click on the R at the top of it. Pressing Ctrl and the spacebar will select the current column. Shift and spacebar will select the current row.
no
You can insert rows above or below the selected row. You select what you would like to do on the insert worksheet rows menu.
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.
Select and copy the row data.Go to the top cell of the column where you would like to copy the data.Click on copy - transpose.Observe the data from the row in the column.Go back and delete the row data.