Change only a part of formula when drag drop in Excel

New Contributor

So I was just doing a HEX to RGB converter in excel, but when I pull it to the other cells, there's a part of the formula that I didn't wan't it to change.



Bold=don't want to change

But Excel decided to change it anyway, and I have absolutely no idea how to fix this...

Any help will be appreciated. Thanks!

2 Replies
best response confirmed by Hans Vogelaar (MVP)

@Km100 Use $C$1 to make the reference to C1 absolute.