|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 2nd, 2004, 06:38 PM
|
|||
|
|||
AutoFilter not an Option
I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the AutoFilter selection is greyed out. If I copy the data into a new spreadsheet I can select AutoFilter.
Does anyone have any suggestions as to why I can't select AutoFilter in the original spreadsheet? 
|
|
#2
July 2nd, 2004, 08:58 PM
|
|||
|
|||
|
AutoFilter not an Option
Jeremy
The worksheet is protected? ToolsProtection. Is "unprotect sheet" available? If so, you may need a password to unprotect the sheet. Note: sheet protection does not prevent copying and pasting to another sheet or book. Gord Dibben Excel MVP On Fri, 2 Jul 2004 10:38:01 -0700, Jeremy wrote: I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the AutoFilter selection is greyed out. If I copy the data into a new spreadsheet I can select AutoFilter. Does anyone have any suggestions as to why I can't select AutoFilter in the original spreadsheet?
|
|
#3
July 3rd, 2004, 03:23 AM
|
|||
|
|||
|
AutoFilter not an Option
One more potential problem: Do you have more than one sheet selected (grouped)?
Jeremy wrote: I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the AutoFilter selection is greyed out. If I copy the data into a new spreadsheet I can select AutoFilter. Does anyone have any suggestions as to why I can't select AutoFilter in the original spreadsheet? -- Dave Peterson
|
|
#4
July 3rd, 2004, 04:41 PM
|
|||
|
|||
|
AutoFilter not an Option
No. Looks like it was sheet protection. Thanks.
"Dave Peterson" wrote: One more potential problem: Do you have more than one sheet selected (grouped)? Jeremy wrote: I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the AutoFilter selection is greyed out. If I copy the data into a new spreadsheet I can select AutoFilter. Does anyone have any suggestions as to why I can't select AutoFilter in the original spreadsheet? -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combo Box selection disappearing on new record and change of option selection | EmmA | Using Forms | 2 | June 17th, 2004 02:21 AM |
| Option button | Aniko | Using Forms | 1 | June 4th, 2004 08:26 AM |
| Cannot check autofilter - Grey'd out | Worksheet Functions | 2 | January 9th, 2004 03:58 PM | |
Linear Mode
