EXCEL TIPS

======================================

EXCEL TIPS: Fill Blanks Via a Formula

======================================

Let’s say you have a list of entries in column A, and within the list you have many blank cells. Here is a quick and easy way to fill those blanks with the value of the cell above.

(1) Select all the data in column A, then go to Edit>Go To…. Ctrl+G and then click Special.

(2) Now check the Blanks option and click OK. This will now have selected only the empty cell within the list.

(3) Now push the Equals (=) key,

(4) Push the Up arrow and

(5) Hold down the Ctrl key, push Enter.

 

 

Leave a Reply


*