If you have drop down arrows at the top of the columns then you
have filtering. I would expect the blue coloring was introduced
with Excel 97 or Excel 2000, but you would see the selected
rows row number in blue and the arrow in blue if selections for
that column are being filtered.

To restore all cells to view.
Data, Filter, Show All
To eliminate filter altogether
Data, Filter, turn off auto filer, or turn off advanced filter

When you learn something new also learn how to turn it off,
unfortunately that is usually not described as well as how to
do something.

To learn more about Filtering see Debra Dalgleish's pages at
http://www.contextures.com
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Frank Kabel" wrote in message ...
Hi
you probably have hidden / grouped some rows. Are the row numbers
coloured in blue?

--
Regards
Frank Kabel
Frankfurt, Germany

"Nospam" schrieb im Newsbeitrag
...
Why do the row numbers seen on the left hand side of a worksheet
jump?
In my case they are from 1,2,3, etc to 18 then it goes to 1262, 1263
etc ?

This seems to upset the facility of dragging formulas down the page
when
required.

How do you get this back to "normal"

Thanks in advance

Bob



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.792 / Virus Database: 536 - Release Date: 09/11/2004