(iWork) Numbers: Cut and Paste, macros

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?


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.