Filling Blank cells on a large spreadshet | Excel forum

Hi Ryan,

Thank you for the forum question.

You have several options also more than I could think about on the course.

Filling blank cells with the information from the cell above can be done efficiently using Excel's built-in features. Here's a step-by-step guide to help you:

Select the Range:

Highlight the range of cells that includes the blank cells you want to fill.
Go to the 'Find & Select' Menu:

On the Home tab, in the Editing group, click on Find & Select.
Choose Go To Special....
Select Blanks:

In the Go To Special dialog box, select Blanks and click OK. This will select all the blank cells in the highlighted range.
Enter the Formula:

Without clicking anywhere else, type = and then press the Up Arrow key. This will create a formula that references the cell above the active cell.
Press Ctrl + Enter to fill all the selected blank cells with the formula.
Convert Formulas to Values:

While the range is still selected, copy the range by pressing Ctrl + C.
Right-click on the selection and choose Paste Special....
In the Paste Special dialog box, select Values and click OK.

You have 3 more options in the link below

https://www.excelcampus.com/functions/fill-down-blank-cells/


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector