This post will show you how to locate Merged Cells in Excel. Knowing how to find merged cells will help you remove them if you need to.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells. The easiest way to identify or extract a ...

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.

Even if you've never created a merged cell in a business spreadsheet, you may receive a spreadsheet that has one. Excel allows you to combine multiple cells into a single cell by clicking a button ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

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.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.