Column numbers missing

Copper Contributor


How do I fix this? It skipped from 1 to 17. I want it to be in order




3 Replies


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.


I tried that and it doesn't do anything. When I right-click the line between 1 and 17 and click unhide, the rows show up one at time, but I would have to keep right clicking and doing it.


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.