The Worksheet Data toolbar buttons perform statistics on columns or rows of data, sort columns of data, use functions to set column values or mathematically transform data, update these column values, and fill columns with row numbers or random numbers.
Performs statistics on the selected columns of data.
Performs statistics on the selected rows of data.
Opens the Nested Sort dialog box.
Opens the Set Column Values dialog box.
Updates all worksheet column values.
Fill selection range with row numbers.
Fill selection range with uniform random numbers.
Fill selection range with normal random numbers.
Add/Remove data filter for the selected columns. Removing would clean up selected data filters' setting.
Enable/Disable selected columns' data filter. Disabled data filters would not be run.
Run enabled column filters in active worksheet, and unmatched rows would be hidden.