sorting without affecting the format

A

alyndejs

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

Bernie Deitrick

Sort the individual blocks separately (data without blanks), or else the space (blanks) will get
sorted as well.

HTH,
Bernie
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

Mail Merge Directory Conditional Page Break 0
excel 2011 won't sort alphabetically 7
Mis-performing MP4 files in Mac PPT 1
Sorting rows 16
Inconsistent formatting of section numbers 0
Sort behaves unexpectedly 1
Word 2016: How do I change a REF field code that references a Heading style to Arabic when the Headi 1
Insert Multiple Fields without Dialog closing between each... 0

Top