GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2011-08 > 1313773545


From: "Eldon Wade" <>
Subject: Re: [DNA] Rotating Firefox?
Date: Fri, 19 Aug 2011 13:05:45 -0400
References: <2F4BAA9DAB2C42FDAAB9A8C9272EA49B@kenPC> <004701cc5e87$cfd3ec70$6f7bc550$@cfl.rr.com><D817201BD3A145A59BA3CF1BF7068AEB@kenPC> <004b01cc5e8c$0625ba70$12712f50$@cfl.rr.com><A86A0E855932407B83976F51D25FCA35@kenPC>
In-Reply-To: <A86A0E855932407B83976F51D25FCA35@kenPC>


Ken,

I was assuming that you had went to somewhere in Column A, inserted a new
column, and then did the paste of the new data in the new Column A .

These are the detail instructions using Excel 2010:

If data is entered in columns or rows, but you want to rearrange that data
into rows or columns instead, you can quickly transpose the data from one to
the other.

1.On the worksheet, do the following:
To rearrange data from columns to rows, select the cells in the columns
that contain the data.
To rearrange data from rows to columns, select the cells in the rows that
contain the data.
2.On the Home tab, in the Clipboard group, click Copy . Keyboard shortcut
To copy the selected data, you can also press CTRL+C.
Note You can only use the Copy command to rearrange the data. To
complete this procedure successfully, do not use the Cut command.
3.On the worksheet, select the first cell of the destination rows or columns
into which you want to rearrange the copied data.
Note Copy areas and paste areas cannot overlap. Make sure that you
select a cell in a paste area that falls outside of the area from which you
copied the data.
4.On the Home tab, in the Clipboard group, click the arrow below Paste, and
then click Transpose.
5.After the data is transposed successfully, you can delete the data in the
copy area.

Eldon


-----Original Message-----
From:
[mailto:] On Behalf Of Kenneth Nordtvedt
Sent: Friday, August 19, 2011 12:40 PM
To:
Subject: Re: [DNA] Rotating Firefox?



-----Original Message-----
From: Eldon Wade
Select the data you want to transpose, move the cursor to top leftmost cell
you want the data transposed to, right click in that cell and chose Paste
Special, then choose the Transpose radial box, and click okay.

right clicking in cell and chosing paste special, I am NOT given a transpose
option --- only text, html, and unicode text


-------------------------------
To unsubscribe from the list, please send an email to
with the word 'unsubscribe' without the
quotes in the subject and the body of the message


This thread: