| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and Header Row's | Excel Discussion (Misc queries) | |||
| Global hiding null rows | Excel Discussion (Misc queries) | |||
| sorting rows wich can vary in number | Excel Discussion (Misc queries) | |||
| Hiding Rows Conditionally | Excel Discussion (Misc queries) | |||
| sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) | |||
Linear Mode
