Jan 31 2023 01:24 PM
Hi, my excel is automatically running absolute references when I reference within the same workbook. For example, I am in sheet1 and I reference a cell in sheet2, excel will automatically do absolute reference. I want my excel to reference cells within same workbook as relative reference. Does anyone know how I can change that setting in excel? (I have excel on Mac)
Jan 31 2023 10:11 PM
@mscnpeace Can't remember ever having seen a setting that puts Excel for Mac (or Windows) in absolute reference mode (i.e. entering $ signs to fix row numbers and column letters) By default, references are relative (i.e. no $ signs). However, when working with pivot tables, charts, conditional formatting and data validation, references are often absolute by default. Perhaps there may be other instances as well.
Can you show what exactly you are doing when the references default to absolute?
Feb 01 2023 10:23 AM
Feb 01 2023 07:34 PM
@mscnpeace I've never experienced the behaviour you describe on Excel for the Mac. So, I don't have any tips/recommendations to get used to it.