Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Take a column of numbers and automatically make them into a row
I want to take a column of numbers and instead of them being in a vertical
line, make them across the top without cutting and pasting each individual cell is there a function to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Take a column of numbers and automatically make them into a row
Select a range on one row with as many columns as your original data has
rows. Then type =TRANSPOSE(A1:A5) (change A1:A5 to your data range) and press CTRL SHIFT ENTER rather than just ENTER. If you do this properly, Excel will display the formula in the formula bar enclosed in curly braces {}. Another method is to use the following formula: =OFFSET($A$1,COLUMN()-COLUMN($D$8),0,1,1) Change $A$1 to the first cell of your original data and change $D$8 to the cell in which you enter this formula. Then, copy this formula across for as many columns as your original data has rows. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "AAD" wrote in message ... I want to take a column of numbers and instead of them being in a vertical line, make them across the top without cutting and pasting each individual cell is there a function to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Take a column of numbers and automatically make them into a row
Hi
Copy the cellsPaste SpecialTranspose. If you are using XL2003 or lower, then your column of cells can't be greater than 256, otherwise it won't transpose. -- Regards Roger Govier "AAD" wrote in message ... I want to take a column of numbers and instead of them being in a vertical line, make them across the top without cutting and pasting each individual cell is there a function to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i make a list of numbers automatically | Excel Worksheet Functions | |||
How do I invert a column of numbers? (make the 1st last, etc) | Excel Discussion (Misc queries) | |||
HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS | Excel Discussion (Misc queries) | |||
how do I automatically add row numbers in column | New Users to Excel | |||
How do I format a column to automatically make it a negative numbe | Excel Worksheet Functions |