George, Adam was asking for a copy that had relative references. Your example of absolute reference is correct, but not relevant to the current question.
Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- From: "George Martinez" <george.martinez...@gmcpa.net> To: <jaws-users-list@jaws-users.com> Sent: Friday, December 16, 2016 05:35 Subject: Re: [JAWS-Users] Another Excel question Hi Adam, If I understand what you are saying, what you want to do is use Absolute references in your formula. For instance c1 * G10 will become c1 * $g$1. This means that it will always use g1 no matter where you copy the formula. You can use the $ for only the row or only the column or both. HTH George -----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Adam Ferguson Sent: Friday, December 16, 2016 6:28 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Another Excel question Hello. Thank you to everyone who has shared information relating to my question about copying columns in Excel. I now have a different question which I can't find an answer for online. Is it possible to copy a formula so that its references are relative to where it is placed? A simple example would be if I had a formula in C1 so I could add together A1 and B1 but then wanted to repeat this for all rows to 20. I don't really want to keep typing out the same formula 20 times. Many thanks, Adam. On 15/12/2016, Reed <reed.poyn...@telus.net> wrote: > Hi Adam, > > Another way to select your data is to use the Go To command. > Hit control-G. In the edit box that appears, type the first cell and last > cell you want to select with a : between. > For example, If you want to select from cell A3 to A99, you would type > A3:A99. If you want to select A3 to U3 you would type A3:U3. > So, in your case, I suspect you have column headings that go over more > than > 1 column. So, you have merged, for example A1 through C1. If you only > want > to copy the data in column B, you could select B2:b99. You could then > copy > to the clipboard and paste into your second spreadsheet. Before you do > your > paste, you should select the area into which you want to paste the data. > The receiving area has to be the same size as the data you are pasting. > In > this case, you could select A2:A99 in your second sheet and do your paste. > > When you are googling, try to think of the most basic things you want to > do. > Here, you have to start by selecting your data to copy. So, search for > example "excel 2016 selecting data". > > Hope this makes sense, > > Reed > > > -----Original Message----- > From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On > Behalf Of Adam Ferguson > Sent: December 15, 2016 7:52 AM > To: jaws-users-list@jaws-users.com > Subject: Re: [JAWS-Users] Another Excel question > > Unfortunatley that doesn't work either; it still picks up the merged > cell. In the end I have gone for going to the start of the cell and > pressing shift+down arrow until I have what I need and then doing the > usual copy and paste process. > > Thanks again for all of your help. > > Adam. > > On 15/12/2016, Gene Warner <genewarn...@gmail.com> wrote: >> Hi Adam! >> >> Try to find a cell that isn't merged with another cell and try selecting >> the column from that cell. >> >> Cheers! >> >> >> >> >> On 12/15/2016 10:29 AM, Adam Ferguson wrote: >>> I think that I have an answer to my own questions, although it doesn't >>> really help with the problem. >>> >>> I think that multiple columns are being selected as columns are merged >>> together for titles/headings etc. >>> >>> Adam. >>> >>> On 15/12/2016, Adam Ferguson <adamfergus...@gmail.com> wrote: >>>> Thank you for clearing that up Gene. Unfortunatley it is still really >>>> confusing me as pressing control+space appears to be highlighting >>>> columns A through U rather than just the one I need. This problem is >>>> really beginning to bug me! >>>> >>>> Cheers, >>>> >>>> Adam. >>>> >>>> On 15/12/2016, Gene Warner <genewarn...@gmail.com> wrote: >>>>> I do wish people would check their facts before posting. One person >>>>> say >>>>> control + space selects columns, another person says it's shift + >>>>> space. >>>>> >>>>> So here it is, copied directly from JAWS help on Excel: >>>>> >>>>> Select the entire column, use control plus space bar >>>>> Select the entire row, use shift plus space bar >>>>> >>>>> Cheers! >>>>> >>>>> >>>>> >>>>> On 12/15/2016 9:53 AM, Adam Ferguson wrote: >>>>>> Hi. >>>>>> >>>>>> sorry to be such a nuisance but neither control+space nor >>>>>> control+shift works. Is it possibly something to do with the way the >>>>>> spreadsheet has been created? >>>>>> >>>>>> Adam. >>>>>> >>>>>> On 15/12/2016, patti <bbk...@comcast.net> wrote: >>>>>>> Hi >>>>>>> 1, be at the top of the column you want to copy >>>>>>> 2, press shift+space bar >>>>>>> That selects the whole column >>>>>>> Ctrl+space bar selects the whole roll >>>>>>> Then you can copy to the clipboard >>>>>>> >>>>>>> >>>>>>> Hi Adam! >>>>>>> >>>>>>> The brute force method would be to make a copy of the entire sheet, >>>>>>> then >>>>>>> delete the columns you don't want. >>>>>>> >>>>>>> A more elegant approach, would be to select each column you want to >>>>>>> copy, >>>>>>> then use copy and paste to copy it to the new sheet. Unfortunately I >>>>>>> don't >>>>>>> think there's a keyboard equivalent to clicking the column header >>>>>>> buttons >>>>>>> to >>>>>>> select the entire column, so you'll have to locate the end of each >>>>>>> column >>>>>>> and select all the cells from there to the beginning of the column, >>>>>>> then, >>>>>>> use copy and paste to copy the column to the new sheet. >>>>>>> >>>>>>> I'd love to be proven wrong by someone who knows how to select >>>>>>> entire >>>>>>> columns or rows. >>>>>>> >>>>>>> hth >>>>>>> >>>>>>> Cheers! >>>>>>> >>>>>>> >>>>>>> On 12/15/2016 6:10 AM, Adam Ferguson wrote: >>>>>>>> Hi again everyone. >>>>>>>> >>>>>>>> I have another question regarding Excel which I can't find a >>>>>>>> solution >>>>>>>> for. >>>>>>>> >>>>>>>> I have to copy certain columns from a spreadsheet onto another, >>>>>>>> smaller spreadsheet. How would I go about doing this? If it makes >>>>>>>> the question easier to answer I require columns A, I, J, K and L. >>>>>>>> >>>>>>>> Many thanks in advance for your wonderful help. >>>>>>>> >>>>>>>> Adam. >>>>>>>> >>>>>>> >>>>>>> For answers to frequently asked questions about this list visit: >>>>>>> http://www.jaws-users.com/help/ >>>>>>> >>>>>>> >>>>>>> --- >>>>>>> This email has been checked for viruses by Avast antivirus software. >>>>>>> https://www.avast.com/antivirus >>>>>>> >>>>>>> >>>>>>> For answers to frequently asked questions about this list visit: >>>>>>> http://www.jaws-users.com/help/ >>>>>>> >>>>>> >>>>>> >>>>> >>>>> For answers to frequently asked questions about this list visit: >>>>> http://www.jaws-users.com/help/ >>>>> >>>> >>>> >>>> -- >>>> Adam Ferguson >>>> Tel: 01942 674931 >>>> Mobile: 07803 594185 >>>> >>> >>> >> >> For answers to frequently asked questions about this list visit: >> http://www.jaws-users.com/help/ >> > > > -- > Adam Ferguson > Tel: 01942 674931 > Mobile: 07803 594185 > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > -- Adam Ferguson Tel: 01942 674931 Mobile: 07803 594185 For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
