+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Rearrange columns in Excel 2010 (Windows version) (/showthread.php?tid=137164)
Pages:
1
2
Rearrange columns in Excel 2010 (Windows version) - kap - 06-06-2012
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?
Re: Rearrange columns in Excel 2010 (Windows version) - Rolando - 06-07-2012
So column A has several pages of numbers, so it is going on and on?
Re: Rearrange columns in Excel 2010 (Windows version) - WHiiP - 06-07-2012
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.
Re: Rearrange columns in Excel 2010 (Windows version) - space-time - 06-07-2012
WHiiP wrote:
...
But your description of what you have and what you want is not very clear.
almost always the case with OP
Re: Rearrange columns in Excel 2010 (Windows version) - space-time - 06-07-2012
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?
Re: Rearrange columns in Excel 2010 (Windows version) - kap - 06-07-2012
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.
Re: Rearrange columns in Excel 2010 (Windows version) - space-time - 06-07-2012
drag it, just drag it
Re: Rearrange columns in Excel 2010 (Windows version) - WHiiP - 06-07-2012
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.
Re: Rearrange columns in Excel 2010 (Windows version) - kap - 06-07-2012
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.
Re: Rearrange columns in Excel 2010 (Windows version) - wowzer - 06-07-2012
Copy the entire column. Drop the resulting data into MS Word. Select as many columns in MS word that you want.