Nov 15 2021 09:29 AM
How do I fix this? It skipped from 1 to 17. I want it to be in order
Nov 15 2021 09:33 AM
Click on the row number 1, then Shift+click on the row number 17.
On the Home tab of the ribbon, in the Cells group, click Format > Hide & Unhide > Unhide Rows.
Alternatively, right-click anywhere in the selection and select Unhide from the context menu.
Nov 15 2021 09:53 AM
Nov 15 2021 10:33 AM
Has a filter been applied?
Try the following:
On the Data tab of the ribbon, in the Sort & Filter group, check whether the Clear button is enabled. If so, click it.