(iWork) Numbers: Cut and Paste, macros Is there a way to &quot;cut&quot; 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?
One way to cut formula and paste in new location with references 'in tact and relative' is following:

navigate to desired cell containing formula
⌥ + ⏎ ('enter cell edit mode', same as F2 in Windows Excel)
⌘ + A ('select all')
⌘ + X ('cut')
⏎ ('exit cell')
navigate to destination cell
= (opens popup window for entering formula)
⌘ + V ('paste')

Alternatively one can make references in formula absolute with ⌘ + K and then cut-paste whole cell.