Sorting in Excel

[BernardThomasWalsh]

Hi All, I'm new to this so just throwng looking for advice.

If i have a table i want to sort via clicing on watver cell i click, how do i do this?

For example if my table was as below i want ti click Contract type and the table sort a-z below, if i click again it would sort z-a. If i thin click 2020 Quarterly Charge it would display lowest to highest value below and clicked again it would return highest to lowest order .  I've seen these tables on line with an up/down arrow sign but can't find on Excel so maybe it's Microsoft Access platform or something.  any help would be greatly appreciated!  B

Contract Type	Development	2020 Quarterly Charge	Q1 AFS CALC
Fire Alarm and Emergency Lighting	Achill Square	€233.97	€198.90
Fire Alarm and Emergency Lighting	Adamstown	€920.00	€876.35
Fire Alarm and Emergency Lighting	Allendale	€135.00	€106.96
Emergency Lights only	CNML Block 1	€250.00	€168.25

[#2]

@BernardThomasWalsh 

Here's a resource that should answer your question. https://exceljet.net/lessons/how-to-sort-an-excel-table

[#3]

To sort in Excel is one of the simplest operation.

All you need to do is to right-click on the column you want to sort. Then select Sort A - Z or Sort Z - A.

To Sort on Multiple columns, click on the Custom Sort in the data tab. Select the columns from the dropdowns

[#4]

Hi there. I know that. I'm trying to find out low you get 2 arrows both up and down in the cells thus whatever cell you click on the table automatically sorts by that columb?

Like the one attached. Thank you for replying! :thumbs_up::thumbs_up:

[#5]

Sent further info. That video didn't show me what I wanted. Thanks for replying though

[#6]

@BernardThomasWalsh 

Do you have reason to believe that's an Excel screen shot?

It might be, I suppose, but I've never seen that pairing of arrows in the headings of an Excel Table...

If it is, and you do find out how to do it , please come back and share the news.