You can access a copy of this workbook here. I have seen many people handle a spreadsheet like this by copying cell A3 down to A15, then copying cell B3 down to B7, copying cell B8 down to B12, and so ...

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.