Create a dropdown with Excel 2003
If you’re using Excel 2010, click here for an updated post.
Just like a drop-down list on a web page, the drop-down list on an Excel spreadsheet presents a [limited] number of options for you to select, thus limit potential data entry errors and make the output more consistent and uniform. The drop-down list mentioned in this post has a down arrow button, but it is not the Filter/AutoFilter functionality of Excel, which can be accessed through menu Data > Filter > AutoFilter. Read more...
Apply RGB colors / custom colors/ custom color palette to MS Excel charts and text.
Updated article for Excel 2010: Excel 2010 Custom Colors
The article below was written for Excel 2003; it’s still accurate and useful for Excel 2003 users. If you’re using Excel 2010, please click on the above link for a more relevant article.
Using consistent colors and color palette across different marketing tools and materials — ads, sale literature, web pages, spreadsheets and charts,… — are significantly important and beneficial. However, most of the time your business colors are not included inside Excel default color palette. If that’s the case, you’ll need to replace the default colors in Excel with your customized color palette. Here’s how: Read more...