I have a comprehensive education grid that was created in an excel
spreadsheet version 2003. It currently has 15 columns and 323 rows. Each
column has an alpha or alpha/numeric header and each row is assigned to a
specific persons name in my organization. Not all of the column contents are
date oriented, some have text as well. If I select a specific column to sort
ascending or descending, based on the contents of that particular column, and
then select "expand the selection", thinking that all of the data on either
side of that column will follow, it does not work. My data for a particular
person gets shuffled and therefore becomes unable to use effectively. Does
anyone know if this is possible in Excel or if there is some rule on number
of columns that can be included in the "expand the selection" sort?

A rule that I have found to be very effective is "Don't ever allow Excel to
select/determine/guess what range I want to work with". If you want to sort
a range, first select the range yourself. Then do Data - Sort. There are
various ways to select a range. If you are finding it difficult to select
your range, post back and tell us what you have and what range you are
wanting to select. HTH Otto
"DMS @ CFH" <DMS @ wrote in message
...
I have a comprehensive education grid that was created in an excel
spreadsheet version 2003. It currently has 15 columns and 323 rows. Each
column has an alpha or alpha/numeric header and each row is assigned to a
specific persons name in my organization. Not all of the column contents
are
date oriented, some have text as well. If I select a specific column to
sort
ascending or descending, based on the contents of that particular column,
and
then select "expand the selection", thinking that all of the data on
either
side of that column will follow, it does not work. My data for a
particular
person gets shuffled and therefore becomes unable to use effectively. Does
anyone know if this is possible in Excel or if there is some rule on
number
of columns that can be included in the "expand the selection" sort?