Highlight the table in full (i.e. all the rows and columns you want) before
applying Filter to it.

"Melissa @ST" wrote:

I've tried that but it's also not sorting the entire document just the first
50 rows, i need to sort the entire document using a filter.

"Anne Troy" wrote:

Somehow, it seems you have an autofilter on. Go to Data--Autofilter and
turn it off.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Melissa @ST" <Melissa wrote in message
...
I can not sort a document without the document hiding rows - how do I stop
this from happening? The row numbers turn blue and hide - this is not
enabling me to sort the entire document.