Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy values available in different cells of a column into d
How to copy values (or data) available in different cells of a column into
different cells of a row? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy values available in different cells of a column into d
Once you have selected the cells in the column, right-click on the
destination cell and select Paste Special, then click the checkbox Transpose. Columns will be transformed in rows and vice versa. -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy values available in different cells of a column into d
Copy
Edit/ Paste Special/ Transpose or =OFFSET([absolute ref of first cell of source column],COLUMN()-COLUMN([absolute ref of first cell of destination row]),0) -- David Biddulph "Satish" wrote in message ... How to copy values (or data) available in different cells of a column into different cells of a row? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy values available in different cells of a column into d
Hi,
There are two scenarios illustrated below: Scenario 1: If the cell are in different location in columns. You can select each cell value by pressing the Crtl key. But you cannot copy the cell values. The following message will display: "That command cannot be used on Multiple selections" Note: You have manually rearrange the cells in a row or columns and then do the following: 1. Select the all the cell values, right-click and then select Copy. 2. Click and select a new cell location. 3. On the Edit menu, click Paste Special. The Paste Special dialog box is displayed. 4. Select the Transpose check box. 5. Click Ok. This will display all rows in cloumn. Scenario 2: If the cells values are adjacent to each column then you can do the following: 1. Select the all the cell values, right-click and then select Copy. 2. Click and select a new cell location. 3. On the Edit menu, click Paste Special. The Paste Special dialog box is displayed. 4. Select the Transpose check box. 5. Click Ok. This will display all rows in cloumn. Challa Prabhu "Satish" wrote: How to copy values (or data) available in different cells of a column into different cells of a row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to copy a column of values, NOT the formula | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
How can I copy values from one cell in a column down to the next c | Excel Discussion (Misc queries) | |||
how do i copy values that are in a column into a row elsewhere? | Excel Discussion (Misc queries) |