Sorting in Excel

  • Thread starter Thread starter bballfan2501
  • Start date Start date
B

bballfan2501

I now when sorting excel puts blanks last. is there a way to get blanks to
come first and then sort numerically or alphabetically?
 
Hi,

1. Select the column you want to sort on and press F5, Special, Blanks, OK
2. Type but don't enter -10^10 and then press Ctrl+Enter
3. Sort your data - the -10^10 should have come to the top
4. Select all the -10^10 entries and delete them

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Hi,

please change the -10^10 in the last post to simple -10000000 (any large
negative number)

cheers,
Shane Devenshire
 

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

Removing blank cells 13
Sorting in Excel 2
Command botton 3
Columns not sorting properly. 2
Sort by Every Other Row? 0
Open File menu sort alphabetical. 6
Pivot Table Report Filter Sorting 3
sort non delimeted non fixed width alpha numeric column 2

Back
Top