If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Although Excel 2013 offers many options for performing calculations in new cells using data from existing cells, sometimes you want to work on data in the original cells.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Click one of the column headers in the document that has values. The word "Count" appears in the status bar's bottom right corner. The number of cells that contain values appears next to that word.

Discover why merged cells in Excel cause more harm than good and learn practical alternatives to improve your spreadsheets today.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's how to use it.

Need to find cells with specific text? The COUNTIF formula in Excel has got you covered.