Is there a way to "cut" certain cells and paste them to another cells or sheet without losing formulas with references to other cells (such as MS Excel does with command+X).
Numbers does not support Excel macros at all?
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
One way to cut formula and paste in new location with references 'in tact and relative' is following:
Alternatively one can make references in formula absolute with ⌘ + K and then cut-paste whole cell.