Copy Paste

[niting]

Hi forum,


I used a formula in cell F2 like IFERROR((SEARCH(F$1,$A3)>0)*$D3,""). Now copying it across from col F till Col AZ is not a issue. However, i have to copy the formula down till row no 300.


Do i have to copy the formula down individually for all columns for col F till Col AZ. or is there a shorter way of just copying it across the whole range???


Thanks in advance

Nitin

 

[Luke M]

You can just copy cell F2, then select range F2:AZ300, paste.