How to auto fill cells in column

C

Carmen Bauer

Is there an efficient way to auto fill blank cells in between populated cells
in a column all at once? I have a list of countries with blank rows in the
column between each country name. I want each country's name to auto fill in
the column.

Can someone help, please?
 
R

RagDyer

Select your range.
Hit <F5>
Click "Special".
Click "Blanks".
Then <OK>.
Type the equal ( = ) sign.
Hit the UP Arrow.
Hit <Ctrl> <Enter>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
How do I get cells auto fill typing 2
Linking columns for auto fill 1
Auto update row numbers after inserting new row 4
auto fill options (copy cell, not create series) 4
Fill cells 9
Auto Fill Cells 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Top