how to fix row numbers?

[gaollca]

I am new here. I have a question about my excel file. The row number on my excel file is not continual. There
miss some numbers in the middle. For exmaple , A1 , A2 ....A1200 Then A1201 is misssing. The next one is A1202 . How should I fix it.

 

[BenMiller]

Click the little space on the top left of your screen, between the row numberings and the column letterings - right to the left of A and above 1. This will select all of your data. Double-click on any row - on the line between two rows, where you would change the row height.

 

[VoG]

The missing rows may be hidden.

See Excel Unhide Rows - Unhide Rows in Excel for how to unhide them.

 

[T. Valko]

I am new here. I have a question about my excel file. The row number on my excel file is not continual. There
miss some numbers in the middle. For exmaple , A1 , A2 ....A1200 Then A1201 is misssing. The next one is A1202 . How should I fix it.

Maybe those rows are hidden.

Click the sheet selector, that little square immediately above the row 1 header and to the left of the column A header.

Hover your mouse in the row headers
Right click>Unhide

See if those rows are now visible.

 

[gaollca]

Thank you ! guys. They were hidden! Now I have them back . Now I have my filter work on the entire sheet.
Thanks for the help.

I am new here. I have a question about my excel file. The row number on my excel file is not continual. There
miss some numbers in the middle. For exmaple , A1 , A2 ....A1200 Then A1201 is misssing. The next one is A1202 . How should I fix it.

 

[T. Valko]

Thank you ! guys. They were hidden! Now I have them back . Now I have my filter work on the entire sheet.
Thanks for the help.

Good deal. Thanks for the feedback!