Re: Excel Question?
- From: "Dave Durber" <d.durber@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2010 06:59:09 -0500
Dave:
I did not mention that the method I suggested might not work in Excel 7.
Please accept my apologies for not writing that.
I do not have Office 2007 on my system, so I cannot duplicate why my suggestion
will not work. I have not installed that version of MS Office, to avoid those
bloody ribbons, which seem to annoy so many people, not only those of us who
are visually impaired.
I am using Office 2003.
I have heard rumors to the effect, that Microsoft are to include an option in
the upcoming version of MS Office, which will allow users to choose between
using the ribbons or the classic menus. Let us hope and pray that it is more
than a rumor.
Sincerely:
Dave Durber
----- Original Message -----
From: Dave Carlson
To: jfw@xxxxxxxxxxxxx
Sent: Wednesday, March 03, 2010 11:26 PM
Subject: Re: Excel Question?
Dave,
I just tried this, since I never knew about it, but when I press Ctrl-C or
open the context menu to copy, I get the error:
"That command cannot be used on multiple selections."
Excel 2007, if that makes a difference.
Dave
----- Original Message -----
From: Dave Durber
To: jfw@xxxxxxxxxxxxx
Sent: Wednesday, March 03, 2010 20:13
Subject: Re: Excel Question?
Claudia:
If columns A, C and F have the same number of cells containing data, for
example, A1 to A400, C1 to C400, F1 to F400, then do the following:
Press the F5 key and type:
A1:A400,C1:c400,F1:f400
followed by ENTER.
JAWS will tell you that 3 areas of your spreadsheet have been selected and
will tell you the range of each column that has been selected.
Use the Copy command, CTRL+C to copy the selected cells to the clipboard.
Now, you can either move to a blank area of the same spreadsheet or, you
can open a new spreadsheet and use the CTRL+V command to paste the text from
the clipboard.
The 3 columns of data will be pasted into 3 consecutive columns.
HTH
Sincerely:
Dave Durber
----- Original Message -----
From: Claudia
To: jfw@xxxxxxxxxxxxx
Sent: Wednesday, March 03, 2010 10:28 PM
Subject: Re: Excel Question?
no Unfortunately,
The columns are column 1, 3 & 6!
Claudia
----- Original Message -----
From: George B
To: jfw@xxxxxxxxxxxxx ; 'Technology list for the Blind and Vision
Impaired'
Sent: Wednesday, March 03, 2010 9:16 PM
Subject: RE: Excel Question?
Are the collums together or in different locations on the sheet you
need ot copy then I can help
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Claudia
Sent: Wednesday, March 03, 2010 19:01
To: Technology list for the Blind and Vision Impaired; jfw@xxxxxxxxxxxxx
Subject: Excel Question?
Hi All,
I'm using JFW 9 & Excel.
Is there a way to do the following?
I need to take three columns from four different Excel documents d
paste them all into one. The reason I can't just copy & paste all four
documents into one is because there are 8 total columns on each doc, but I only
need to create a report from three!
So, can this be accomplished?
My program at work has an audit next Tuesday, and I need to create this
report by then!
Thanks.
Claudia
__________ Information from ESET Smart Security, version of virus
signature database 4910 (20100302) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus
signature database 4910 (20100302) __________
The message was checked by ESET Smart Security.
http://www.eset.com
Other related posts:
