[nfbcs] Slightly OT Pasting Formulas in Excel

[Bryan Schulz]

hi,

that's what i was thinking but you have to do it before the copy and you 
have to put a $ before the letter and another before the number.
Bryan Schulz


----- Original Message ----- 
From: "Steve Cook via nfbcs" <nfbcs at nfbnet.org>
To: "Nicole Torcolini" <ntorcolini at wavecable.com>; "NFB in Computer 
ScienceMailing List" <nfbcs at nfbnet.org>
Sent: Tuesday, February 17, 2015 7:37 AM
Subject: Re: [nfbcs] Slightly OT Pasting Formulas in Excel


> You can try putting a dollar sign in front of the cell coordinace.  HTH
>
> Steve Cook, CPM
> Assistive Technology Consultant
> SC Commission for the Blind
> 1430 Confederate Avenue
> Columbia, SC 29201
> Phone: (803) 898-8788
> E-Mail: stcook at sccb.sc.gov
>
> -----Original Message-----
> From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Nicole 
> Torcolini via nfbcs
> Sent: Tuesday, February 17, 2015 1:12 AM
> To: 'NFB in Computer Science Mailing List'
> Subject: [nfbcs] Slightly OT Pasting Formulas in Excel
>
> In Excel, when you copy and paste a group of cells that contain formulas, 
> the formulas are adjusted based on how far you moved the cells. This is 
> usually the desired behavior, but there are cases where I want to just the 
> copy the formulas as they are instead of adjusting them. Is there a way to 
> do this?
>
> Thanks,
> Nicole
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/stcook%40sccb.sc.gov
> AMD/ Low Vision Month- Age-related macular degenerations is the leading 
> cause of blindness in America for those ages 50 and over. The South 
> Carolina Commission for the Blind stresses the importance that you receive 
> a comprehensive eye exam that includes visual acuity tests, a dilated eye 
> exam and tonometry tests. For more information about how the SC Commission 
> for the Blind can help you or a loved one, please visit us at 
> www.sccb.state.sc.us or give us a call at 803-898-8731.
>
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/b.schulz%40sbcglobal.net