If my formula is A1=B1 and A2=B1 and A3=B1, then why can't I drag this
formula all the way down column A. A column cells keeps picking up the
corresponding B column cells instead of staying with the value in B1. I also
turned off the Extend Data Range Formats and Formulas and this didn't work
either. Please help.
Thank you so much.