| 0 |
Subject: changing the axis on Excel
Posted by: rockafellerskank
- Dude [27652109] Thu, Oct 28, 2004, 10:20
I think there is a way to "flip" the axix headings in a spreadsheet. My spreadsheet is too wide, I want the column A,B,C axis to change with the row 1,2,3.. axis.
Anyone know how to accomplish this? |
| 1 | Richard
Dude
ID: 204252420
Thu, Oct 28, 2004, 10:34
|
I'd highlight the whole block of data, copy it and then paste it onto a new page using the Paste Special-Transpose option.
Richard
|
| 2 | Guru
ID: 330592710
Thu, Oct 28, 2004, 10:36
|
Copy the area to be transposed, and then reposition the cursor to where you want the upper left cell to be and select edit/Paste Special. Then click the transpose option near the bottom of the selection box.
|
| 3 | Perm Dude
ID: 2343587
Thu, Oct 28, 2004, 10:39
|
Obviously one way to change the "Axis of Excel" is to invade on of the countries in question. Oh, sorry. I thought you said "Axis of Evil."
|
| 4 | rockafellerskank
Dude
ID: 27652109
Thu, Oct 28, 2004, 13:51
|
Thanks Richard/Guru. That was much easier than invading Bill Gates' homeland. ;)
|
| 5 | biliruben
ID: 441182916
Thu, Oct 28, 2004, 14:35
|
I will defend Redmond with every macro at my disposal, until my diseased virus-ridden kernal can not longer execute a simple sort.
Man the firewalls, gentleroms!
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|