Adam, While I was out walking this morning that very thing came to me. If you have cells that are merged in any row touching on the column you are copying that will happen, it will select all columns across the merged row. I have never found any way to get around that except manual selection, sorry. George
-----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Adam Ferguson Sent: Thursday, December 15, 2016 8:30 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Another Excel question 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 > -- 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/
