Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

To change Gridline color in Excel, use Excel Options, apply a custom-colored border to the cells, or apply a custom line color. Full details here.

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Go Beyond Color Your customization job does not have to end when you alter a legend's color. Click the Format Legend panel's "Effects" icon to reveal special effects you can apply to the legend.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...