Autofilter not appearing correctly? help!

Hey all.

I copied a large spreadsheet into a new worksbook and hence new sheet. This sheet was then customised for the user ..I got rid of un-necessary rows within the this new customised spreadsheet that user would not require.

The autofilter in the original large spreadsheet shows many different options when the drop down button is clicked...
whilst the sheet that ive created which was mostly copied does show the autofilter but shows no additional options..it only shows the options: "All", "Top 10" and "Custom".

Why is this?

Am i making any sense?!?!?!

London,

You can set up a new Autofilter. Click in the heading row, Data - Filter -
and click Autofilter, which should currently have a check mark. That will
turn off the Autofilter. Then do that again to set up a new one. If your
data isn't contiguous (blank rows or columns in it), you may have to
manually select the entire table (including header row).

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"londonchick" <[email protected]>
wrote in message
news:[email protected]...
>
> Hey all.
>
> I copied a large spreadsheet into a new worksbook and hence new sheet.
> This sheet was then customised for the user ..I got rid of un-necessary
> rows within the this new customised spreadsheet that user would not
> require.
>
> The autofilter in the original large spreadsheet shows many different
> options when the drop down button is clicked...
> whilst the sheet that ive created which was mostly copied does show the
> autofilter but shows no additional options..it only shows the options:
> "All", "Top 10" and "Custom".
>
> Why is this?
>
> Am i making any sense?!?!?!
>
>
> --
> londonchick
> ------------------------------------------------------------------------
> londonchick's Profile:
> http://www.excelforum.com/member.php...o&userid=24529
> View this thread: http://www.excelforum.com/showthread...hreadid=381272
>

You many have a blank row between the headings and the data. If you
delete it, the drop down lists should show items from the column.

londonchick wrote:
> Hey all.
>
> I copied a large spreadsheet into a new worksbook and hence new sheet.
> This sheet was then customised for the user ..I got rid of un-necessary
> rows within the this new customised spreadsheet that user would not
> require.
>
> The autofilter in the original large spreadsheet shows many different
> options when the drop down button is clicked...
> whilst the sheet that ive created which was mostly copied does show the
> autofilter but shows no additional options..it only shows the options:
> "All", "Top 10" and "Custom".
>
> Why is this?
>
> Am i making any sense?!?!?!
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html