Assume the formula is A1+B1, and you want to keep B1 fixed for other rows, then use A1 + $B$1 写作助手，把中式英语变成专业英文 Want to receive new post notification? 有新文章通知我
Don’t forget the splited versions: $B1 and B$1