Hi, No. If you use option-arrow to add rows or columns before/after, all you are doing is adding a blank row/column. You'll need to copy/paste or fill to maintain formula structure within that new row/column.
Later... Tim Kilburn Fort McMurray, AB Canada On 2013-10-09, at 1:25 PM, Alex Hall <[email protected]> wrote: > So, say i add a formula to a cell. If I then use option-down while on that > cell, my formula will be copied? Do I have that right? I'd still like a way > to apply a formula to a column of any length without filling, but this might > make things easier if I cannot do that. > On Oct 9, 2013, at 12:02 PM, Eugenia Firth <[email protected]> wrote: > >> Hi there >> Yes, I think I know at least part of your problem. Remember if you add a row >> above or below the one euro and it will have the same characteristics as the >> one you're sitting on. So, get on a road that has the same characteristics >> as the one you want to add. Then press option down arrow or option Apero, as >> the case maybe. You may have already figured this out by now, and I may be >> responding to an earlier message and now you know what's what. If that's the >> case sorry I'm a little late. >> Regards, >> Gigi >> >> Sent from my iPhone >> >>> On Oct 8, 2013, at 10:23 PM, Alex Hall <[email protected]> wrote: >>> >>> Hi all, >>> I don't think I phrased my Numbers question very well, so here's another >>> shot. >>> >>> I have a spreadsheet with one header row. I've used this to label my >>> columns, so I know what goes where. I want to add a forumla to some >>> columns, and I have discovered that if I put the formula in the header >>> cell, it will automatically apply to all cells in that column. When i do >>> this, though, Voiceover reports the cell as being blank. So, I not only >>> lose my title text, I also have no idea what my formula is, and the cell >>> appears to be toally blank. Does anyone know why this is happening and how >>> I can fix it? Do I need a second row of header cells? Thanks. >>> >>> >>> Have a great day, >>> Alex (msg sent from Mac Mini) >>> [email protected] >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/groups/opt_out. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/groups/opt_out. > > > > Have a great day, > Alex (msg sent from Mac Mini) > [email protected] > > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
