Hi...I am wondering if there is a way to sort any column with a one click
function. My spreadsheet will be used by many and giving that many tutorials
on how to use the sort menu is not an option. I'd like to be able for them
to click on a particular column to sort (keeping all rows intact). If this
is not possible in Excel, is there an office program that will allow me to do
that?
Thank you.
~~Beth~~

You can easily assign a macro to sort a single column if you double-click the
top row in that column. But it needs a macro...
--
Gary''s Student - gsnu200816


"Beth" wrote:

Hi...I am wondering if there is a way to sort any column with a one click
function. My spreadsheet will be used by many and giving that many tutorials
on how to use the sort menu is not an option. I'd like to be able for them
to click on a particular column to sort (keeping all rows intact). If this
is not possible in Excel, is there an office program that will allow me to do
that?
Thank you.
~~Beth~~

Thanks for the help Gary. The macros work...takes a bit of planning but it
works.
--
Thank you.
~~Beth~~


"Gary''s Student" wrote:

You can easily assign a macro to sort a single column if you double-click the
top row in that column. But it needs a macro...
--
Gary''s Student - gsnu200816


"Beth" wrote:

Hi...I am wondering if there is a way to sort any column with a one click
function. My spreadsheet will be used by many and giving that many tutorials
on how to use the sort menu is not an option. I'd like to be able for them
to click on a particular column to sort (keeping all rows intact). If this
is not possible in Excel, is there an office program that will allow me to do
that?
Thank you.
~~Beth~~