[gui-talk] Excel Formulas

[John De Witt]

When at the cell on Sheet 1, where you want to have the formula 
from the other pasted:

Press Alt and the equal sign

Press Control Page Down twice to get to the third sheet

Press Control G to go to the cell which contains the data you 
want to paste (you will need to know the cell coordinates first 
since JAWS will not speak if you try to navigate to that cell)


Press Enter twice.

The Sheet 3 cell reference is now pasted into the cell you wished 
to look at.

The same principle applies when copying a cell's data or formula 
from a different workbook. In that case, have the new workbook 
open. Use Control F6 to switch to the new workbook rather than 
Control Page Down (above), and follow the same procedure, 
replacing  Control F6 for Control Page Down.

Good luck.

John De Witt, President
De Witt & Associates
john at 4dewitt.com
877/447-6500 Extension 212

----- Original Message ----- 
From: "Steve Cook" <STCook at sccb.sc.gov>
To: "'NFBnet GUI Talk Mailing List'" <gui-talk at nfbnet.org>
Sent: Wednesday, December 05, 2007 2:43 PM
Subject: [gui-talk] Excel Formulas


Good Afternoon,

Using Excel 2003 and JAWS 9.0.

Does any one know how to use  a formula that is on work sheet 3 
in a formula that is currently on work sheet 1?  Basically we 
want to access information on another sheet for training 
purposes.  I know you can do this, it just has been a long time 
since I have done this.  Thanks in advance for your help.


Steve Cook
Instructor/Trainer
SC Commission for the Blind
Phone: (803) 898-8788
Fax: (803) 898-8882
E-Mail: stcook at sccb.sc.gov

IMPORTANT NOTICE This transmission may contain information that 
is privileged, confidential, legally privileged, and/or exempt 
from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein 
(including any reliance thereon) is STRICTLY PROHIBITED. Although 
this transmission and any attachments are believed to be free of 
any virus or other defect that might affect any computer system 
into which it is received and opened, it is the responsibility of 
the recipient to ensure that it is virus free and no 
responsibility is accepted by SCCB., for any loss or damage 
arising in any way from its use. If you received this 
transmission in error, please immediately contact the sender and 
destroy the material in its entirety, whether in electronic or 
hard copy format. Thank you.
_______________________________________________
gui-talk mailing list
gui-talk at nfbnet.org
http://www.nfbnet.org/mailman/listinfo/gui-talk


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.14/1172 - Release Date: 
12/5/2007 8:41 AM