If you have just inserted a row, then pressing F4 will continue to insert new rows.
Click on the Insert Sheet Rows button.
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.
Press the HOME key.
Press the HOME key.
Select the rows around the missing ones. Then go to the Format menu, pick Rows and then Unhide. With the rows selected you can also press and hold both the Ctrl and Shift keys and press the 9 key on the main keyboard.
Nope . It is F4
by default is left alignment, you can change it if you want
T spacers
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.
KEEP ROWS and PURGE 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.
No. That is a feature of Microsoft Word tables, but not Excel. There are specific options for inserting rows and columns in Excel.