Sorting Tables in Excel 2003?

  • Thread starter Thread starter JazzySinatra
  • Start date Start date
J

JazzySinatra

I'm having a hard time figuring out how to sort tables that consist of more
than one row in Excel 2003.
It is like a checklist of things that need to be done, but in date order.
Some dates have more than one task, so some tables have more rows than others
and I need to figure out how to sort everything in date order but keep the
tables together. Is it possible to do this? Thanks
 
Not without filling the dates into the empty cells.

Easiest method is select the date column and F5>Special>Blanks>OK

Type an = sign into active blank cell the point or arrow to cell above.

Hit CRTL + Enter to fill blanks.

Copy the column and in place paste special>values>ok>esc.


Gord Dibben MS Excel MVP
 

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

Pivot Table Sort Order 1
Sort 2
writing a sort macro 2
Pivot Table - Compare Dates & calc. % 1
SORTING DATA IN TABLES 1
Pivot table drill down sort 0
How can I save a sort order for re-use instead of having to type i 1
sorting dates in a pivot table 1

Back
Top