Filling in empty cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I would like to fill in the blank space (A2:A8) below Allan Flanagan's name (A1) all the way down until it gets to the next name (Allan Matthews). I need to populate the whole of Column A in this manner. I don't want to drag as it will take for ever and is prone to making manual errors

Allan Flanagan MG43100 Plant Maintenance-MG 03000391 Flanagan Alla
03002359 Spooner Philli
03002360 Fullerton Barne
03002362 Turley Pau
03002364 Gates Michae
03002365 Van-Der-Meer Leonardu
03002540 Richardson Wayn
03002545 Munro Glen
Allan Matthews SK66145 Aust Exp -Commercial 03001269 Morgan Sara
03001388 Matthews Alla
03001479 Chee Adely
 
Steve said:
Hi, I would like to fill in the blank space (A2:A8) below Allan
Click to expand...
Flanagan's name (A1) all the way down until it gets to the next name
(Allan Matthews). I need to populate the whole of Column A in this
manner. I don't want to drag as it will take for ever and is prone to
making manual errors.
Allan Flanagan MG43100 Plant Maintenance-MG 03000391 Flanagan Allan
03002359 Spooner Phillip
03002360 Fullerton Barney
03002362 Turley Paul
03002364 Gates Michael
03002365 Van-Der-Meer Leonardus
03002540 Richardson Wayne
03002545 Munro Glenn
Allan Matthews SK66145 Aust Exp -Commercial 03001269 Morgan Sarah
03001388 Matthews Allan
03001479 Chee Adelyn
Click to expand...


Steve,

Select A2:A100 (or however many rows your data has)

Press Control + G to bring up the Go To dialog box

Click the Special button

Select blanks and click OK

Type =A1 and then press Control + Enter


Hope this helps,

Mike
 
Steve

Once you have done this, it will leave the cells containing formulas, rather
than values. To change these to actual values, select the column, Edit /
Copy then Edit / Paste Special . . . Values.

Andy.
 
Back
Top