Button to sort cells?

[David Morrison]

I have a spreadsheet with a number of columns. At times, it is
convenient to sort the rows according to different columns.

I can certainly sort manually using the menu, but I wondered if it might
be possible to have a button at the top of each column which I could
click to sort the rows by that column?

Thanks

David

 

[CyberTaz]

If you go to Data> Filter - AutoFilter the captions of your data will be
fitted with buttons which provide lists that include the sort options.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[David Morrison]

If you go to Data> Filter - AutoFilter the captions of your data will be
fitted with buttons which provide lists that include the sort options.

Ah, excellent! Thanks very much.

David