Excel has long had a feature allowing you to add background shading to cells, but if you use non-standard colours then replicating them can be fiddly. Excel 2010 makes that process easier with a simple but obvious tweak: a list of recently-used colours on the Fill drop-down (the small bucket) in the Ribbon.
I suspect this isn’t a new feature and was also in Excel 2007, but I’ve only just noticed it since I normally access the Fill option using the even more venerable Control-1 keyboard shortcut for Format Cells. That’s more keyboard-friendly and also makes it easier to tweak related options such as borders, but the access to recently-used colours is worth noting if you do a lot of shading.
Leave a Reply
You must be logged in to post a comment.