Author: Debra Dalgleish

Data Validation Selection Popup Tool – Contextures

With the free Data Validation Select Popup (DVSP) tool from Contextures, you can add popup lists to Excel workbooks.

Set the rules you’d like for the pop-up lists — allow single item selection in some columns, and allow multi-selection in other columns.

Continue reading “Data Validation Selection Popup Tool – Contextures”

Troubleshoot Excel Formulas with ERROR.TYPE Function

Did you know that you can use the Excel ERROR.TYPE function to identify specific types of errors on a worksheet? And after the error type is identified, you can use that information to provide help with error troubleshooting.

There’s a short video below, that shows an example, and there’s a list of the Excel error values that this function can identify.

Continue reading “Troubleshoot Excel Formulas with ERROR.TYPE Function”

Excel Text in Multiple Rows – No Merged Cells

I add lots of screen shots to my Excel tutorials, so it’s easier to follow the steps. And if I’m explaining a formula, it’s helpful to show that on the worksheet too.

However, some Excel formulas can get pretty long, and I found a way to fix that problem! You can see all the solutions that I tried, or skip to the end, to see the final solution.

Continue reading “Excel Text in Multiple Rows – No Merged Cells”