Rearrange columns in Excel 2010 (Windows version)

[kap]

There are several columns of numeric data. At this point each page contains a column to the far most left margin. How do I contain (wrap around?) all the columns on one page?

[Rolando]

So column A has several pages of numbers, so it is going on and on?

[WHiiP]

Sounds like you need to resize the columns and set a new print area.

But your description of what you have and what you want is not very clear.

[space-time]

WHiiP wrote:
...

But your description of what you have and what you want is not very clear.

almost always the case with OP

[space-time]

I think I get it

Page 1:

A B C

1 2 3

4 5 6

Page 2:

D E F

7 8 9

and you want to wrap around to have them all on one page like

A B C D E F

1 2 3 7 8 9

4 5 6

Is this what you want? has it occured to you to select a portion of the EXCEL worksheet and drag it to a different place?

[kap]

WHiiP wrote:
Sounds like you need to resize the columns and set a new print area.

But your description of what you have and what you want is not very clear.

I know what I want; I am just lousy at describing it :biggrin:

Let me try again. There is a single long column of numeric data (student ID #) that runs several pages of paper. We want to be able to chop off the columns into several sections and cramp those same sections on a couple of pages of paper.

Hope that is clearer now.

[space-time]

drag it, just drag it

[WHiiP]

Sounds like it is time to use cut and paste.


I think you have this:
999
999
999
999
999
999
999
999
999
999
999
999


And you want this:


999 999 999
999 999 999
999 999 999
999 999 999


Cut and paste.

[kap]

WHiiP wrote:
Sounds like it is time to use cut and paste.


I think you have this:
999
999
999
999
999
999
999
999
999
999
999
999


And you want this:


999 999 999
999 999 999
999 999 999
999 999 999


Cut and paste.

We had thought of having to do just that. However, we were hoping there was an Excel feature/function that would allow the data to be "snaked" or rearranged into newspaper style columns. Transpose feature produces somewhat of a desired result.

[wowzer]

Copy the entire column. Drop the resulting data into MS Word. Select as many columns in MS word that you want.