Forum Discussion
gba100
Nov 15, 2021Copper Contributor
Column numbers missing
How do I fix this? It skipped from 1 to 17. I want it to be in order
HansVogelaar
Nov 15, 2021MVP
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.
- gba100Nov 15, 2021Copper ContributorI 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.
- HansVogelaarNov 15, 2021MVP
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.