Sorting a column in a spreadsheet

  • Thread starter Thread starter akkrug
  • Start date Start date
A

akkrug

What is the best way to sort a spreadsheet? My boss wanted filters set up,
so I set up an autofilter for all columns. She also wanted to sort by one
column, so I recorded a macro that sorted the column in ascending order and
another macro to sort it into descending order. I thought there might be a
better way to do it. Also, can I assign the macro to a button instead of a
shortcut key?

Thanks for the help!!

Ken
 
If you've setup your autofilters correctly, you can simply use the sorting
capability listed within the filter.

But yes, you could create a button from the forms toolbar (or a picture, if
you like) and assign a macro to either of them.
 
akkrug said:
What is the best way to sort a spreadsheet? My boss wanted filters set up,
so I set up an autofilter for all columns. She also wanted to sort by one
column, so I recorded a macro that sorted the column in ascending order and
another macro to sort it into descending order. I thought there might be a
better way to do it. Also, can I assign the macro to a button instead of a
shortcut key?

Thanks for the help!!

Ken
Click to expand...

I know bosses expect to have the info at their finger tips but I think
this is a case of teach a man to fish. The functions you are asking
about sort and filter are two basic functions in a spreadsheet. take 2
minutes and show this person HOW to do this themsleves and save yourself
some time.

gls858
 
Back
Top