EVALUATE FORMULA in Excel to find errors
How to find errors in a complex formula, step by step, using Excel’s EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.
Excel General Tips
Sum values if cells contain specific text in Excel
How to search a range of cells for specific text, and then sum another range of cells based on the search results. Worked examples using a combination of ISNUMBER, SEARCH, SUMPRODUCT, SUMIF.
Excel formula not calculating automatically
How to fix Excel when formulas are not automatically calculating and flash fill doesn’t fill the formula down the column.
Create, format, resize and rename Excel TABLES
Using Tables in Excel has many benefits (we’ve listed our 10 favourite reasons), and this topic page shows you how to create, format, resize, rename, add totals and summarize data, and use data entry forms with Excel Tables.
Data entry form in Excel
How to create and use a data entry form in Excel
Customize the ribbon in Excel
How to customize the ribbon in Excel – add commands, create a new tab and group of commands in the ribbon
FORMULATEXT function in Excel – display formulas
It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
Add, move, group, copy, hide and protect Excel worksheets
How to add, move, group and copy worksheets within and between Excel workbooks, and how to navigate between sheets in large multi-worksheet file, and how to hide and unhide worksheets.
Add a DATA LABEL to ONE POINT on a chart in Excel
How to add a data label to just one data point on a chart in Excel.
Remove BLANK CELLS in chart data table in Excel
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.