View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DMS @ CFH DMS @ CFH is offline
external usenet poster
 
Posts: 1
Default Sorting with expanding a section feature

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?