Ditch the paintbrush! Get powerful, selective formatting in seconds.

This guide describes how to grey out unused cells in Excel in Windows 11/10, apply a solid fill color, use Conditional Formatting, or hide unused rows/columns.

Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...

Conditional Formatting in Excel can be considered a valuable utility that can help visually enhance the data analysis and presentation in the spreadsheet by applying particular formatting based on pre ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options. Update the format to help make ...

When you enter a date that's formatted with slashes, Excel will recognize it as a date. For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set ...

This guide explains how to generate barcodes in Excel without any additional installations, using both the desktop and web versions of Excel. It covers formatting cells to preserve leading zeros, ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...