Column numbers missing

Copper Contributor

 

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

 

gba100_0-1636997168340.png

 

3 Replies

@gba100 

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.

@gba100 

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.