For example, if I have =B1+A1 in a cell, can I drag it across to fill the adjacent cell, but have the formula increase to =C1+A2, instead of C1+B1??
no, it is impossible,
except for using INDIRECT function, like that
=C$1+INDIRECT("A"&(COLUMNS($A:B)))