Quick LinksSplit Cells by Delimiter to Isolate ValuesReplace Errors for Use in CalculationsUnpivot Data to Aid AnalysisFill Blank Cells Based on the Cell Above (Or Below)Have you heard of Power Query ...

How to Convert True-False to Check Boxes in Excel. Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option.

How do you show errors in Excel? If you have lots of data or a large table containing data on your spreadsheet and you want to find errors in it, follow the steps below. Click the Formulas tab.