Hi Barry and Phil, Thanks both for your help.
Barry, your tip of first VO-spacing on the column reference tab took me further than I had gotten before, but still no success. The results were a bit flaky. I'm not sure I exactly understood your instructions. After VO-spacing on the column reference tab for the column I wanted to move, I pressed mouse down with VO-command-shift-space. Sometimes doing this caused the menu to pop up with the sort and filter options etcetera. Other times it didn't. But it never said anything about moving, and moving to another column and pressing mouse up didn't have any effect. Pressing VO-comma would still announce, 'Marked column X for drag', or whatever, but when I'd try and drop it would often say the marked item is no longer in view, even though I had only tried to move it one column over, and other times it would say 'column X inserted', but would actually not have moved the column at all. Phil, the formulas are my own but the column I want to move is in a data table and the formulas and functions I have in the summary tables are quite complicated, and I don't really want to look through every one to find if any use relative references and would break. In any event, I'd like to learn how to move columns (as opposed to copying and pasting) to enhance my Numbers toolbox and ensure that for this time and for the future I am able to move columns without upsetting formulas. Having said that, I appreciate your pragmatic suggestions and might ultimately have to resort to that or to asking for sighted assistance. many thanks again and if you have any other help, thoughts or suggestions I'd love to hear them. On 7 Aug 2014, at 11:15 pm, Phil Halton <[email protected]> wrote: > A simpler method would be to simply copy the column, then insert a new column > where you want the data, and then do a paste. Move to the top of the column, > then do a shift command down arrow to select the entire column. Then do an > option right arrow at the column after which you want the data to appear. Of > course, don't forget to copy the selected fcolumns first, then paste into the > newly created column. This may still mess up your formulas depending on > whether you used relative or absolute addressing. > > That gets fairly tricky. I don't know if you're writing your own formulas, or > if these are someone else's. But, the addressing system they use will > determine if the formulas can be moved from one position to another without > screwing them up. > Sent from my IPhone > > >> On Aug 7, 2014, at 12:10 AM, Nicholas Parsons >> <[email protected]> wrote: >> >> Hi all, >> >> I'm trying to work out how to move columns in Numbers without upsetting >> formulas etc. Sighted people can just click on the column reference tab and >> drag the column left or right to the new location. >> >> I've tried getting into the column reference tab with VO-shift-backslash and >> then selecting column reference tab, and then using the VO commands to drag >> and drop. However, this never works. It seems more than just the usual >> flakiness, it just never seems to have any effect, even though VoiceOver >> announces that the column has been inserted. >> >> Any ideas? >> >> -- >> 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/d/optout. > > -- > 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/d/optout. -- 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/d/optout.
