Talk

Advanced search

Excel question - how do I insert a button at the top of each column to sort the data?

(8 Posts)
ministryofsleep Thu 12-Nov-09 13:53:12

into eg ascending or descending order?

SingleMum01 Thu 12-Nov-09 14:01:11

you don't need to insert a button - click in the column you wish to sort, then the A-Z button on the toolbar

BadgersPaws Thu 12-Nov-09 14:02:46

I "think" the only way to do this is to put some code behind a button, which is something that some people stop from running as it's a huge security risk.

I'm curious to see if there's a better way...

bloss Thu 12-Nov-09 14:12:56

Message withdrawn

Snorbs Thu 12-Nov-09 14:14:55

Isn't this what Pivot Tables do?

palacemonkey Thu 12-Nov-09 14:31:27

use an auto-filter - that way you've got all the options above (ascending, descending, alpha etc). smile

ministryofsleep Thu 12-Nov-09 14:46:49

palacemonkey - that's it - autofilter - thank you smile

ministryofsleep Thu 12-Nov-09 14:48:12

"button" wasn't a very techie way of explaining was it blush

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now