Re: Numbers: mirroring columns

2015-03-16 Thread Jürgen Fleger
Hi Tim and Phil, worked like a charm. Thanks for your support. That helped me a lot. :-) I’m totally stunned how easy it is to work with Numbers. How cool. All the best Jürgen > Am 16.03.2015 um 19:45 schrieb Phil Halton : > > Rather than pasting b1 into each individual cell B2 through be 37,

Re: Numbers: mirroring columns

2015-03-16 Thread Tim Kilburn
Hi, Thanks Phil, that would be easier. I don’t know what exactly I did different, but the Auto-Fill Down feature was working for me now. So, after entering the proper Table/Cell reference in B1, just using arrow and shift keys, navigate to B1, then hold down shift and arrow down to B37 then t

Re: Numbers: mirroring columns

2015-03-16 Thread Phil Halton
Rather than pasting b1 into each individual cell B2 through be 37, first copy be one and then select B2 through B37 and then do the paste. Numbers will auto fill B2 b37 with the contents of B1 and automatically adjust the cell references for you. Check the cell references to make sure their co

Re: Numbers: mirroring columns

2015-03-16 Thread Tim Kilburn
Hi, Using Cell References, you should be able to do what you’re asking. So, for example, in your case, I’d do the following: • move to cell B1 inn Table B. • Enter the formula “=Table C::B1”. Assuming your wanting to mirror the same cell reference in the other table. • Normally, we’d just do