I like to select the exact range. I select A1:z9999 if I want to filter the
data in A1:Z9999. I don't just select the columns in that range.

And my bet is that there was a gap when data|Filter|autofilter was applied--or
the filter was applied to the wrong range--but that's just a guess.

strictly_rhythm wrote:

Hi Dave thankyou for your response,

sorry to sound daft but when you say select the complete range do you
mean to highlight the column in question from the very top where it has
A B C or which ever particular column it is? or do you mean just
highlight from top to bottom the data to be checked? What exactly is
selecting the entire range?

Also when i opened up the spreadsheet there is no gap but i had to
click on 'ALL' on the filter to bring up the noticeable break in the
list. Why is that?

regards

Steve

--
strictly_rhythm
------------------------------------------------------------------------
strictly_rhythm's Profile: http://www.excelforum.com/member.php...o&userid=36002
View this thread: http://www.excelforum.com/showthread...hreadid=557886

--

Dave Peterson