Excel cells sorting

[kmkarthikkm]

Dears,

I want to sort the cells A to Z , but the cells does not contain any datas presently. If datas are coming through another program into this excel, then the excel will be automatically converted to pdf with sorting the values.

Is any body can help how to sort the empty cells A to Z in excel.

 

[Roderick_E]

run the macro recorder and sort the column. You may need to put fake data in the rows to get it to work, then you can remove and apply to the real data when needed.

 

[kmkarthikkm]

Thanks Roderick, can you please send an example