Excel automatically running absolute reference within same workbook

Hi @Riny thanks for the reply! So I was having the issue I describe. Say I had two sheets: sheet1 and sheet 2. in sheet1 cell b4 I wanted to reference sheet2 cell c7, so I'd simply click on sheet1 b4, enter "=" then I click on sheet2 c7, and excel automatically would do this: "'Sheet2'!$c$7" which actually had never happened to me in excel. So I thought I had unintentionally done something (first time on Mac excel -- so feeling like a newbie entirely in excel) to change such settings which would have been a total pain in the butt going forward. But it corrected itself. What I am finding is that excel in Mac is a bit wacky so lots of little things like this. Thanks for answering.

I have another question: do you have a recommendation for Mac excel users -- trying to speed up my mental switch between the two 🙂

Thanks!