How do I activate sort in Excel?
I have worksheets set up in Excel. I am wanting to sort 1 column of these
worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? |
Hi marygries
Unprotect your sheet -- Regards Ron de Bruin http://www.rondebruin.nl "marygries" wrote in message ... I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? |
"marygries" wrote: I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? When I go to tools, protection, unprotect is not there as an option??? |
Do you have more than one sheet selected? You cannot sort grouped sheets.
Do you see [Group] in the title bar? If so, select a sheet to ungroup them. If they were grouped, make note that what was done to one sheet was done to all in the group. Gord Dibben Excel MVP On Tue, 15 Mar 2005 14:09:05 -0800, " wrote: "marygries" wrote: I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? When I go to tools, protection, unprotect is not there as an option??? |
All times are GMT +1. The time now is 12:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com