Shortcut recipe: fill in missing data

I have a spreadsheet that contains music data.

To fix this, I need to add the correct values for each blank cell.

On the surface, this looks like a really tedious job.

But, there’s actually a really easy way to add the missing data using a simple shortcut recipe.

For this, use Control Enter.

Now all blank cells have a value.

This works because it creates a chain of formulas that all get a value from the cell above.