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/