Hi Adam, You can copy the formula and paste it in as many of the cells in that column. As long as the relationship between the cell with the formula and the cells the formula is using to perform the calculation stay the same you will be fine.
So if you have a formula in f2 that adds the values of cells a2, b2, c2, d2 and e2, no matter where you move the cell with the formula, it will always add up the values from the 5 cells to the left of it. If you use the $ sign before any column or row reference in your formula, then they will not change when you paste the formula into another cell. Annette -----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Adam Ferguson Sent: Friday, December 16, 2016 8: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 tyimes. Many thanks, Adam. On 15/12/2016, Reed <reed.poyn...@telus.net> wrote: > Hi Adam, > > An other 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 >>>>>> control+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/
