How do I stop rows from hiding when sorting a worksheet?
 

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.

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.

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.

Melissa

Sorting and filtering are two distinctly different operations.

Sorting does not hide rows.

Filtering hides rows.

What do you want to do?


Gord Dibben Excel MVP

On Thu, 30 Jun 2005 13:51:03 -0700, "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.

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.