AUTOFILTER

Posted by Nancy A Williams on November 22, 2000 4:20 PM

I did something to the spreadsheet so that I'm now stuck in AutoFilter and AutoFilter doesn't work. I was hiding and unhiding columns and then trying to filter. Right now most of the Data menu is grayed out, so I can't even sort the data.

Also, when I do a print preview, I get an area that is superimposed over another area and it prints out real small.

I've looked everywhere in Help and their instructions don't work because I think I am frozen. Any help would be appreciated. I'm a beginner, as you might have guessed.

Posted by Baki on November 22, 2000 7:18 PM

Try to see if the spreadsheet is protected under the tools menu. If that is the case, you need to unprotect it to be able to be able to sort and autifilter etc...