Hi Adam and George!
I've never had a situation where I needed to copy a column with merged
cells in it, so I wasn't aware of that behavior. Now I know.
Cheers!
On 12/15/2016 11:17 AM, George Martinez wrote:
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
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
