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/
