Filter by Color not working

B

BarbaraPietersen

New Member
Joined
Mar 30, 2011
Messages
7
Hi
I am using Excel 2007 and suddenly I can no longer filter by color. The option is greyed out and so is the sort by Color option. Does anyone have any idea why this would happen?

Thanks in advance.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Is the file saved as an xlsx or xlsm or are you in Excel 97-2003 compatibility mode (xls).
 
Upvote 0
Probably a silly question, but you do actually have some coloured cells in that column?
 
Upvote 0
Thanks all for responses. Answers in order:

- This is the first time it has happened and appears to be only on this workbook
- Sheet is not protected
- I have colored cells right across the entire row

Thanks again for any help
:confused:
 
Upvote 0
Did you apply the colour or is it the result of table autoformats?
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Clear Filter causing freeze
Replies
1
Views
234
frabulator
frabulator
P
  • Question
Button VBA run-time error 2147319767 (80028029)
Replies
1
Views
62
frabulator
frabulator
R
  • Question
Slicer not working properly
Replies
1
Views
61
shift-del
shift-del
Z
  • Question
I went on excel today and personal modules are grey out
Replies
1
Views
223
zone709
Z
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
971
Alex Blakenburg
A

Forum statistics

Threads
1,214,636
Messages
6,120,664
Members
448,976
Latest member
sweeberry

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top