ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row numbers (https://www.excelbanter.com/excel-discussion-misc-queries/256404-row-numbers.html)

Richard

Row numbers
 
Row numbers are not consecutive (jumps from row 3 to row 8). To the best of
my knowledge I've never done anything (like hiding) that would cause this
condition.

Fred Smith[_4_]

Row numbers
 
Do you have a data filter on?

Regardless of what caused it, did you try unhiding the rows?

Regards,
Fred

"Richard" wrote in message
...
Row numbers are not consecutive (jumps from row 3 to row 8). To the best
of
my knowledge I've never done anything (like hiding) that would cause this
condition.



Mike H

Row numbers
 
Richard,

Rows don't dissapear, they are visible, hidden or so small you can't see
them and the difference between the last 2 states is fundamental to the
method for making then visible again.

Method one. Select rows either side of the 'missing' rows and right-click in
the shaded area and see if they come back

If they dont right click again and this time select 'row height' and set to
say 15 and they should appear
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Richard" wrote:

Row numbers are not consecutive (jumps from row 3 to row 8). To the best of
my knowledge I've never done anything (like hiding) that would cause this
condition.


Mike H

Row numbers
 
I forgot one are they filtered out with a worksheet filter?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H" wrote:

Richard,

Rows don't dissapear, they are visible, hidden or so small you can't see
them and the difference between the last 2 states is fundamental to the
method for making then visible again.

Method one. Select rows either side of the 'missing' rows and right-click in
the shaded area and see if they come back

If they dont right click again and this time select 'row height' and set to
say 15 and they should appear
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Richard" wrote:

Row numbers are not consecutive (jumps from row 3 to row 8). To the best of
my knowledge I've never done anything (like hiding) that would cause this
condition.



All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com