Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I paste a column upside down?
When I copy a column, how can I paste a column upside down?
|
#2
|
|||
|
|||
Answer: How can I paste a column upside down?
To paste a column upside down in Microsoft Excel, you can follow these steps:
Alternatively, you can also use the "Transpose" function to paste a column upside down. Here's how:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I paste a column upside down?
Hi Sufian,
You can't do that in the paste operation, you need to Sort the column after it is pasted. If the column is already in an ascending or descending order, simply highlight the data, go to DataSort and check sort ascending or descending. If the data is fluctuating you will need to insert a helper column next to it, put 1 in the first cell, 2 in the second, then highlight both cells, grab the fill handle and drag down to the end of your data. Highlight both columns and go to DataSort select the helper column from the pulldown and check either ascending or descending. You can delete the helper column when you finish. HTH Martin "Sufian" wrote in message ... When I copy a column, how can I paste a column upside down? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I paste a column upside down?
Fill an adjacent column with consecutive numbers. Sort the data column and the numbers column descending, using the numbers column as the key. Copy the data column and paste it. Sort the numbers column and the data column ascending. Clear the numbers column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sufian" wrote in message When I copy a column, how can I paste a column upside down? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I paste a column upside down?
If you know the last cell row number in column A just enter this in B1 and
doubleclick on the fill handle of B1. =INDEX($A$1:$A$120,120-(ROW(A1)-1)) Adjust 120 in both cases to your last row number. Gord Dibben MS Excel MVP On Thu, 4 Oct 2007 13:49:01 -0700, Sufian wrote: When I copy a column, how can I paste a column upside down? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i turn text upside down? | Excel Discussion (Misc queries) | |||
print cell upside down | Excel Discussion (Misc queries) | |||
how to flip a column upside down | Excel Discussion (Misc queries) | |||
how do I print one side upside down? | Excel Discussion (Misc queries) | |||
I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel |