Row numbers bunched up - how do i get it back to normal? (pic included)

**no.18shirt** · 05-06-2013, 06:31 AM

Hi

My rows have suddenly bunched up as you can see in the picture between 542 and 3,495. How do I get it back to normal where you can see the lines 1 by 1?

Thanks excel number2.png

**:) Sixthsense :)** · 05-06-2013, 06:57 AM

Select the Row 542 and Row 3495 and do right click and select unhide

**no.18shirt** · 05-06-2013, 07:00 AM

That just unhides one row at a time, I dont want to click 3,000 times...

**:) Sixthsense :)** · 05-06-2013, 07:04 AM

You need not to do it for 3000 times when your selection covers those 3000 rows at the time of giving unhide.

**no.18shirt** · 05-07-2013, 04:25 AM

I've selected both lines at once and individually and it still only reveals one more row at a time when I press unhide... any ideas?

**aydeegee** · 05-07-2013, 04:36 AM

To be absolutely sure of what is happening,
click on the number 542. This should highlight the whole row.
Hold down the shift key
Click on the number 3495. This should highlight all rows that you can see between 542 and 3495
Right click in this area and select unhide.

You can also see this effect if there is a filter on.
Goto data
In the sort & filter section click on clear.

Has this helped?

Regards
Alastair