Excel - Populating blank columns

  • Thread starter Thread starter ehibinitie
  • Start date Start date
E

ehibinitie

Hi,
I am trying to populate blank cells in my spreadsheet with value
from another column. For example I have a column J with some blan
fields in it. I am looking for a formula I could use to populate thes
fields with the corresponding column value in DQ.
Any help with this will be greatly appreciated.

Thank
 
Hi

Select column J. Then Edit / Go To / Special / Blanks
This will select all blank cells in the column, with the first one
highlighted. Type = and then enter the corresponding reference in DQ. You
can then hit Ctrl Enter to populate all of the cells with their relative
values.

Andy.
 
Back
Top