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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Highlight the table in full (i.e. all the rows and columns you want) before
applying Filter to it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Cells only display a maximum number of text characters 4
Hiding Rows 5
hiding an image 2
How do I hide multiple rows under one row IN EXCEL? 2
Automatic Sorting? 6
How do I calculate only visible data (not hidden rows)? 2
Sorting complex worksheets 1

Back
Top