Select the top cell of the suspect column.
While holding down the Ctrl button, tap the down arrow key.
Repeat as necessary.

-or-

Select the suspect column.
Go to Edit (menu) | Go To | Special (button) | Blanks
Click Ok.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"duketter"
wrote in message
Excel 2003 - Is there anyway to sort multiple columns to look for gaps. What
I have is 8 different spreadsheets and he spreadsheet contains about 64,000
lines (almost the max Excel allows). There is a column in each spreadsheet
that is a unique identifier and should not contain a gap. However, the
numbers are in no particular order. So for instance, spreadsheet 1 contains
the numbers 1,2,4. Spreadsheet number 3 might contain the number 3 so there
is no gap.

Due to the large nature of the spreadsheet, I cannot put all these numbers
into on column in one spreadsheet and just sort for the answer. Is there a
way to put a bunch of different columns into one spreadsheet and then do a
sort of somekind to look for any gaps between the numbers?
Thanks!