Re: Excel Question?
- From: "Dave Durber" <d.durber@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2010 23:13:29 -0500
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:
