Excel Trick – Fill sporadic text in blanks in a list

When you have sporadic data in a list and want to fill the blank cells with the data preceding them F5 and Ctrl+Enter comes to your help


for the data as shown above

select the entire data set (Alpha to Total), press F5 -> Special… -> Blanks

you will see all the blank cells are selected

then enter ‘= first text in the list’, in this case cell no. containing “Alpha”

press Ctrl + Enter

All the blank cell will be populated with the text preceding them






Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s