| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make the auto fill handle to input data from left to righ
My data is currently stored vertically. January Total is in column A, Feb is
in B, March is in C, etc... I want to convert it so that Jan Total is in row 1, Feb in 2, March in 3, etc... Instead of dragging each month from it's current column to be in vertical order, I would like to use the fill handle to automatically grab the data in the next column. However, when I attempt to do this, it automatically grabs the data in the row below since I am dragging the fill handle to the next row. Is there any way for me to get the fill handle to grab the data in the next column when I drag it to the next row? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make the auto fill handle to input data from left to righ
What you are asking for is not supported. Perhaps you could copy the range
and Paste Special - Transpose to reorg your data. -- HTH... Jim Thomlinson "Jason" wrote: My data is currently stored vertically. January Total is in column A, Feb is in B, March is in C, etc... I want to convert it so that Jan Total is in row 1, Feb in 2, March in 3, etc... Instead of dragging each month from it's current column to be in vertical order, I would like to use the fill handle to automatically grab the data in the next column. However, when I attempt to do this, it automatically grabs the data in the row below since I am dragging the fill handle to the next row. Is there any way for me to get the fill handle to grab the data in the next column when I drag it to the next row? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make the auto fill handle to input data from left to
That worked. Thanks!
"Jim Thomlinson" wrote: What you are asking for is not supported. Perhaps you could copy the range and Paste Special - Transpose to reorg your data. -- HTH... Jim Thomlinson "Jason" wrote: My data is currently stored vertically. January Total is in column A, Feb is in B, March is in C, etc... I want to convert it so that Jan Total is in row 1, Feb in 2, March in 3, etc... Instead of dragging each month from it's current column to be in vertical order, I would like to use the fill handle to automatically grab the data in the next column. However, when I attempt to do this, it automatically grabs the data in the row below since I am dragging the fill handle to the next row. Is there any way for me to get the fill handle to grab the data in the next column when I drag it to the next row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make excel auto fill in date and current time | Excel Discussion (Misc queries) | |||
| how to copy down formulars into same column by a row left to righ | Excel Discussion (Misc queries) | |||
| Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
| Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
| fill handle | Excel Discussion (Misc queries) | |||
Linear Mode
