Lists in Excel 2003
I am attempting to include a list function in a large spreadsheet. However
some of the rows are subcategories of the cells above them. Is there a way for me to have Excel view the main cell and sub cells as just one in the list? Any help would be appreciated as I have been working on this spreadsheet for two weeks and am finally done...minus the list function. |
Lists in Excel 2003
hi
Not unless you create an extra column. the first column would contain the main Category, with an entry in each row. the second category column would contain the sub category. Filter on the first column. -- Regards Roger Govier "Chddb" wrote in message ... I am attempting to include a list function in a large spreadsheet. However some of the rows are subcategories of the cells above them. Is there a way for me to have Excel view the main cell and sub cells as just one in the list? Any help would be appreciated as I have been working on this spreadsheet for two weeks and am finally done...minus the list function. |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com