Select the range to fix (as many columns as you want)

Say B1:x1234 for example
Edit|Goto|special|check blanks
Notice that just the empty cells in that original selection are now selected.

Type an equal sign and hit the downarrow key (don't look at the screen!):

Hit ctrl-enter to fill the selected cells with a formula that points to the cell
directly below.

Now look at the screen.

You may want to select the original range and
edit|copy
edit|paste special|values

Debra Dalgleish explains how to do this:
http://contextures.com/xlDataEntry02.html

But her example uses the cell above (not below).

wrote:

i m unable to progrm this problem as i m novice
i have data in some columns ,

one column have values in all rows [ say in row 1 to row 15] while
its adjacent column2 have some missing data [say in row 6 no data ]

so i want to chk from column 1 if in the 6th row data is present n in
colmn2 6th row data missing then
copy the data from row7 to row6 in column2

likewise in case of all columns where ever data is missing above
procedure left adjacet column shud b checked

hope some of u find time to help me out
waitng for ur replys

many thanx in advance

--

Dave Peterson