sorting without affecting the format

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

Guest

Pls tell me how to sort out datas (A-Z or alphabetical oreder) without
affecting the format (like spaces or rows in between). Any help would be
greatly appreciated. Thank you.
 
Sort the individual blocks separately (data without blanks), or else the space (blanks) will get
sorted as well.

HTH,
Bernie
MS Excel MVP
 
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

Sort behaves unexpectedly 1
SORTING HELP! 2
a-z sort on sheets 1
sort a column without losing the corresponding value in next col 2
Can I use Sort to alphabetize & leave blank row bet. rows (2003) 4
Sorting 1
Sorting 6
Sorting day names chronologically 5

Back
Top