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

M

Melissa @ST

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.
 
M

Melissa @ST

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.
 
G

Gord Dibben

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
 
M

Melissa

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