Comments on: How to alphabetize in Excel: sort columns and rows A-Z or Z-A

Comments page 2. Total comments: 52

1. 

   Sivakumar says:
   2018-05-25 at 8:35 am

   Hi,

   I want to sort out nearly 100 columns and in all the columns rows number is differ. Ex, In one column, until row 10 have data in another column have data until 20. In this situation, how to sort out the data in all column in A to Z format. I tried.But, in some columns in between blank cells came. Kindly help me.

   One more question, by reading this i understood that for sorting out multiple columns i have to use add level. But, when the column numbers are more means each time how can i go change the column number. If there is other way, i could save my time.

   1. 

      Doug says:
      2018-05-25 at 12:09 pm

      Sivakumar:
      Can you sort each column separately or do all the columns have to be sorted as one big selection?
      If you can sort each column by itself you can avoid the blank row problem.
      If the data in each column has to stay with its respective row across the entire data set, you're doing it the only way it can be done. You have my sympathy.

2. 

   sachin says:
   2018-05-01 at 6:52 am

   hi friend!!!
   I have problem in this formula i used but it's not working and result showing #N/A. please solve it.

   1. 

      Svetlana Cheusheva says:
      2018-05-01 at 8:07 am

      Hi Sachin,

      You can download our sample workbook that contains all the formulas discussed in this tutorial and try them on your data.

3. 

   Sam Manford says:
   2018-04-23 at 10:42 am

   Thanks for this, love your tutorials. Keep it up!

   1. 

      Subba Rao says:
      2020-05-26 at 5:35 am

      My friend, I have a problem in sorting the entire spreadsheet.
      Ex: I have three hundred names entered from line two to fifty one and in several columns.
      I need to sort all the names in the spreadsheet, all columns at once. I tried all methods I knew, in vain. Please help me. Yhanks