So long as the column didn't contain data which was referenced by a formula
somewhere else in your spreadsheet, that would work fine. But if there is a
formula somewhere referring to the data in that column, then that formula will
no longer be able to get the data once you copy, paste and delete
Hi there
I have done this by inserting a column where I want the new one to go. Then
copied or cut the column I want to move, then deleted the column that I don't
need any more. To me, that's easier, and it doesn't take long either.
Regards,
Gigi
On Aug 29, 2014, at 8:09 AM, Phil Halton wr
I'll have to re-read that when my head clears a bit. You could make a living as
a flimflam artist with that patter.
On Aug 29, 2014, at 1:25 AM, Nicholas Parsons
wrote:
> Phil,
> It actually makes sense when you think about it. Say you have a cell in table
> 2, say cell A1, which references a
Bary,
Agree completely. There's often so many variables and things that can go wrong
that it's very difficult to explain how to do things via email. However, just
knowing that you're not wasting time by trying is often valuable enough, and
then if you're persistent enough and are told how it sho
Phil,
It actually makes sense when you think about it. Say you have a cell in table
2, say cell A1, which references a column in another table, say column 1 of
table 1. Now whether or not our cell A1 of table 2 uses absolute or relative
references, if you were to copy column 1 of table one, past
Hey Nicholas.
Glad you were able to make that work. I knew you would if you stuck with it.
That's just what it takes some times, and on OS X you can get rewarded for it
more often than not.
I didn't feel I was able to help much more than throw out a bunch of
suggestions, but it sounds like th
how about that! That's strange and makes very little sense to me. It kind of
undercuts the whole concept of relative and absolute addressing, and implies
that numbers is correcting for the addressing depending on the method of moving
involved.
Oh well, good to know, thanks.
On Aug 9, 2014, at 1
Hi Phil,
With respect, I think you're wrong. I experimented by creating the same formula
referencing the same data table, with one version using relative references and
a second version using absolute references. When I moved one of the data
columns with the mouse method, both formulas continue
Hi Barry,
I finally got it to work. Thanks, Barry, for your help and patients! First of
all I got it to work in a different spreadsheet, after first rearranging the
tables and ensuring none of the tables were overlapping. Then I tried it in the
original spreadsheet I was working with. At first
Hello Anders,
You can move the mouse with any device that allows a person to move the mouse
pointer. I use the track pad on my MBA. However, there is also Mouse keys which
you configure in System preferences/Accessibility. Once configured, you press
the Option key 5 times and you can then move
Hi!
Just a question which might be stupid but can you use a magic mouse or other
with voiceover?
Or how do you move the mouse?
/A
8 aug 2014 kl. 09:55 skrev Barry Hadder :
> Some tabs are the letter indexes and some are the headings. I don't think
> that matters though. It's just a miner bug t
Regardless of the method you used to move a column, the formulas contained
there in will be affected. The addressing method holds whether you copy and
paste the formula or whether you drag-and-drop it, or whether you use some
other method. Regardless of how you move it, if there is relative or a
Some tabs are the letter indexes and some are the headings. I don't think that
matters though. It's just a miner bug that doesn't seem to affect anything.
The mouse should read what the voiceover cursor reads in the reference tabs.
I don't think that the mouse is moving to the tabs for whateve
After checking VO Utility turns out I didn't have the mouse pointer following
the VO cursor. I changed this so now it is. I checked and the magnification was
set to 1.
I tried again but still got the same result with the mouse down opening the
menu.
When you bring the mouse pointer to the colu
Well, unfortunately it sounds to me like you are doing everything right. I've
noticed the funk sound myself and it doesn't seem to matter. I've tried it
myself in full screen and regular and both with mouse following vo and not but
all with the same results. I just can't make it fail.
If you
Hi Barry,
In that case I did understand you correctly. Yes, I routed the mouse to the VO
cursor with VO-command-F5 before pressing mouse down (even though this is often
not necessary when I have the mouse pointer to always follow the VO cursor). I
also tried bringing the active window to front
Hello Nicholas.
After you selected the tab with vo-space, did you route the mouse to vo with
vo-command-f5? You want to do that before you lock the mouse. That is the
only reason I can come up with as to why the menu was activated.
You might try hiding any other open windows with command-optio
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 refere
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
In the column reference tab, move vo to the column you want to move and select
it with vo-space. Then route the mouse and move vo to the position you want to
move to and release the mouse. You should hear vo announce something to the
affect that column was move to position of some other column
20 matches
Mail list logo
