add a button in xcel

[carrie]

how to provide a button in xcel for sorting sth by
(alphabetical)and (descending)

 

[Andy Brown]

Should already be on your Standard toolbar -- a "Z" over an "A" next to a
down-arrow.

Rgds,
Andy

 

[Harald Staff]

They are already there on the standard toolbar, sorting by the column where
your selected cell is.

If you absolutely need your own, record a macro while sorting and assign the
code to a button from the Forms toolbar.

 

[carrie]

-----Original Message-----
how to provide a button in xcel for sorting sth by
(alphabetical)and (descending)
.
no.....

what i mean is that provide button"s" for sorting by one
thing(alphabetical) and the other one by value descending
and then to name these buttons......

 

[Ed]

Carrie:

If I understand you correctly, I think the solution would be as Harold
said - to record the sorting actions you want in a macro, then add custom
buttons to your toolbar and assign the macros to them. Here's how I did it:
-- Select a column
-- Start the marco recorder and name it appropriately
-- Got to Data>Sort, set sorting parameters, and click OK
-- Right-click on the toolbar area, choose Customize, select Macros in the
Categories, and drag the Custom button up to the toolbar
-- Right-click on the button and assign the proper macro to the button.

HTH
Ed