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? |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com