A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

A cell reference is simply a way of identifying a specific cell in your spreadsheet.

How to Use the Clean Function in Excel for Multiple Cells. Microsoft Excel's Clean function strips nonprintable characters from cell text. These nonprintable characters constitute the first 32 ...

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

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.

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.

When you want to fill a column in Excel with a given formula or value, you can do it the old fashioned way (select cells or the column header, CTRL+V ...

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

In Microsoft Excel, the SIGN number is a math and trigonometry function that returns the sign of a number. Learn how to use it.