Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis ...

First, select the cells in question, and click the "Number Format" dialog box icon in the bottom-right corner of the Number ...

Excel is well known as a program that allows you to create complex tables of data. However, some people are less familiar ...

You find Excel's highlight function under the "Conditional Formatting" button in the Styles section under the Home tab. When you click it, a drop-down menu appears with a "Highlight Cell Rules ...

For instance, to cause Excel to highlight any cell that contains the word "profit," press "Ctrl-A" to select all cells and follow the steps described to navigate to the "Format Cells" text box.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

If you can't click on cells in your Excel workbook, try reopening the workbook or click on another window and then back to Excel; if that doesn't work, follow these methods.

If you use Excel your text will sometimes spill over. This article will show you how to get Excel cells to fit Text. Make cells expand to fit Text!

When you need to select several cells with a similar attribute, you can use Excel's Find feature to make the process eaiser.

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

You may have used Excel for years without delving into Styles (or stylesheets). We’re going to cover Cell Styles, and Smart Art, Drawing, Graphics, Picture, and Chart Tools.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.