Excel filter - row numbering

Soldato
Joined
10 Jan 2010
Posts
5,319
Location
Reading
Hey guys

When things are filtered the row numbers on the side 'skip' numbers because the data isn't showing.
JuJnY.png

That makes no sense so, above I had a bunch of letters, filtered so it only shows 'a'. On the left it goes: 1,2,7,12 and misses the rest because they are filtered out.

Is there a way it will show just 1,2,3,4 instead? (red pen :p)

Thanks
 
Last edited:
Back
Top Bottom