Sorting Many Columns And Keep Information In Rows Intact

If you want to sort many columns ( more than 3 columns ) it`s easy.


# Use CONCATENATE worksheet function to merge numbers you want to sort


# Write CONCATENATE beside each cell you want to sort later


# Then Go to Sort icon in tools bar


# Sort Ascending or Descending as you want


# Remove any merged cells to work well.


# Thanks....

Publish Post