1

I am looking for a way to add default or constant value to a column in macOS Numbers? When I want to create a new row based on previous row I should always copy and paste the values after adding which is a bit annoying.

Paul R
  • 208,748
  • 37
  • 389
  • 560
Soheil Novinfard
  • 1,358
  • 1
  • 16
  • 43

1 Answers1

0

It seems to be possible, a bit tricky though

  1. add an initial value to column
  2. add in the next row formula referencing cell above it
  3. copy this formula to below cell using dragging (is's important)
  4. now when you duplicate row (via popup menu, sorry I have Russian Numbers) or increasing table height you'll get automatically copied values

enter image description here

schmidt9
  • 4,436
  • 1
  • 26
  • 32