| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sorting without affecting the format
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sorting without affecting the format
Sort the individual blocks separately (data without blanks), or else the space (blanks) will get
sorted as well. HTH, Bernie MS Excel MVP "alyndejs" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'd like to Sort one column without affecting the others | Excel Worksheet Functions | |||
| How can I sort data without affecting formula? | Excel Discussion (Misc queries) | |||
| sorting without affecting links | Excel Discussion (Misc queries) | |||
| macros affecting different worksheets | Excel Discussion (Misc queries) | |||
| Is there a virus out there that is affecting excel spreadsheets | Charts and Charting in Excel | |||
Linear Mode
