1

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?

1 Answer 1

1

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.

4
  • This is basically the only thing I came up with, however, such method is unfortunately very ineffective if I need to copy a whole table with equations, text etc.
    – Josh E.
    Apr 23, 2021 at 5:54
  • If you 'came up' with this before asking the question it would have been nice if you worded your question differently. If you need to copy a whole table then you can duplicate it with ⌘ + D and move it where needed. If there are references to cells outside of the table then they should be made absolute before duplicating table. Apr 23, 2021 at 15:40
  • Well, I though that copying just the formula to any other cell was obvious as a solution, you can do that in any table's editor. I will look at the post formulation, but to me, the problem is specified correctly. Duplicating a table is also another thing. To put my issue in a simplified way, what I try to achieve is a direct equivalent (if any exists) to cut & paste in MS Excel no matter the size of an area I am moving elsewhere. Thanks for all the suggestions though.
    – Josh E.
    Apr 23, 2021 at 16:17
  • 1
    My English may let me down but if question is 'Is there a way to "cut" certain cells and paste them to another cells or sheet without losing formulas with references to other cells' then for me it means that questioner don't even know whether such way exists. Numbers has also drag-and-drop (press and hold, drag) which in functionality is pretty similar to Excel's cut-and-paste. Apr 23, 2021 at 18:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .