Forum

Notifications
Clear all

How to sort multiple columns??

2 Posts
2 Users
0 Reactions
54 Views
(@lewismiles)
Posts: 1
New Member
Topic starter
 

Attached is a sample section of my 200xcolumn database.

I'm looking for a way - formula or macro - to sort all columns from low to high, as I've manually done with the bolded column E.

I'm using Excel 2007.

Is it possible to automate this process and do all columns at once?

Thanks.

 
Posted : 21/11/2020 6:02 am
(@wilkies0106awhotmail-com)
Posts: 19
Eminent Member
 

Hi,

I can't see the attachment.

Yet what happens if you select all your data and then on the ribbon, Home tab, Editing group, Sort and Filter, Sort A-Z?

 

A

 
Posted : 21/11/2020 10:28 am
Share: