add a button in xcel

  • Thread starter Thread starter carrie
  • Start date Start date
Should already be on your Standard toolbar -- a "Z" over an "A" next to a
down-arrow.

Rgds,
Andy
 
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.
 
-----Original Message-----
how to provide a button in xcel for sorting sth by
(alphabetical)and (descending)
.
no.....
Click to expand...
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......
 
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
 
Back
Top