Re: Excel Question?
- From: "Dave Durber" <d.durber@xxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2010 07:07:32 -0500
Dave:
Where you have columns that do not contain the same number of cells, just
adjust the command accordingly, as in:
A1:A225,C1:C300,F1:F300
You can use the same formula to select portions of a column or columns.
As you can see, very flexible.
HTH
Sincerely:
Dave Durber
----- Original Message -----
From: Dave Carlson
To: jfw@xxxxxxxxxxxxx
Sent: Wednesday, March 03, 2010 11:30 PM
Subject: Re: Excel Question?
Dave,
Mea culpa. I didn't take heed of your warning to make sure to select the same
number of cells in each column. So it appears tat the selection must end up
being a nice clean quadrangle to work.
Very neat little tip, and I never knew about this. I can think of a number of
times this would have saved me a lot of time.
Not necessarily JAWS-related, but nice to know, nonetheless.
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:
