Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

where is the button of Relative Reference in Developer Tab Excel In MAC

i have excel 2016 Mac version. i searching to find the icon User generated image   in Excel 2016 MAC.  but i cannot find it.

how can i record relative reference in MAC Excel 2016?
SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Flora Edwards

ASKER

thanks.

sometimes i automate some of data cleanups using macro recorder and then adding a loop into it.  if i do not have the option of relative reference, then my macros would not be recorded correctly in MAc excel.

is there any way to still be able to record macro in excel 2016 for MAC using relative reference?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you both.
Glad to help