|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 7th, 2005, 11:43 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Change/Reverse the table
Hi. There's the table: A1 A2 B1 B2 C1 C2 1) I would like to make the table upside-down, ie: C1 C2 B1 B2 A1 A2 How to do? 2) This time I would like to mirror my table  , ie:A2 A1 B2 B1 C2 C1 How to do? -- Additional information: - I'm using Office XP - I'm using Windows XP 
|
|
#2
December 7th, 2005, 11:56 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change/Reverse the table
Do you mean permanently, or to be able to toggle between them?
-- Ian -- "0-0 Wai Wai ^-^" wrote in message ... Hi. There's the table: A1 A2 B1 B2 C1 C2 1) I would like to make the table upside-down, ie: C1 C2 B1 B2 A1 A2 How to do? 2) This time I would like to mirror my table , ie:A2 A1 B2 B1 C2 C1 How to do? -- Additional information: - I'm using Office XP - I'm using Windows XP
|
|
#3
December 7th, 2005, 02:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change/Reverse the table
"Ian" ¦b¶l¥ó ¤¤¼¶¼g .... Do you mean permanently, or to be able to toggle between them? Permanently. But if I can toggle between them, I would like to know too.
|
|
#4
December 7th, 2005, 02:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change/Reverse the table
I assume this isn't your real data which would be really simple.
1) Create a helper column after your data and number it 1,2,3 etc. Select the data and go to DataSort using this new column to Sort by. Sort ascending or descending depending on the order you want. 2) Create a helper row below your current data and sort using this row. When you go to DataSort select Options and click Sort left to right. If you need to have both row and column helpers in place at the same time, make sure that where to row and column coincide you use the higher of the 2 numbers. So your data would look something like this A1 A2 1 B1 B2 2 C1 C2 3 1 2 4 -- Ian -- "0-0 Wai Wai ^-^" wrote in message ... "Ian" ¦b¶l¥ó ¤¤¼¶¼g ... Do you mean permanently, or to be able to toggle between them? Permanently. But if I can toggle between them, I would like to know too.
|
|
#5
December 7th, 2005, 02:58 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change/Reverse the table
WoW! A clever way of using "sort"  Thanks a lot. "Ian" ¦b¶l¥ó ¤¤¼¶¼g .... I assume this isn't your real data which would be really simple. 1) Create a helper column after your data and number it 1,2,3 etc. Select the data and go to DataSort using this new column to Sort by. Sort ascending or descending depending on the order you want. 2) Create a helper row below your current data and sort using this row. When you go to DataSort select Options and click Sort left to right. If you need to have both row and column helpers in place at the same time, make sure that where to row and column coincide you use the higher of the 2 numbers. So your data would look something like this A1 A2 1 B1 B2 2 C1 C2 3 1 2 4 -- Ian -- "0-0 Wai Wai ^-^" wrote in message ... "Ian" ¦b¶l¥ó ¤¤¼¶¼g ... Do you mean permanently, or to be able to toggle between them? Permanently. But if I can toggle between them, I would like to know too.
|
|
#6
December 7th, 2005, 03:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change/Reverse the table
Glad to help. Thanks for the feedback.
-- Ian -- "0-0 Wai Wai ^-^" wrote in message ... WoW! A clever way of using "sort" Thanks a lot. "Ian" ¦b¶l¥ó ¤¤¼¶¼g ... I assume this isn't your real data which would be really simple. 1) Create a helper column after your data and number it 1,2,3 etc. Select the data and go to DataSort using this new column to Sort by. Sort ascending or descending depending on the order you want. 2) Create a helper row below your current data and sort using this row. When you go to DataSort select Options and click Sort left to right. If you need to have both row and column helpers in place at the same time, make sure that where to row and column coincide you use the higher of the 2 numbers. So your data would look something like this A1 A2 1 B1 B2 2 C1 C2 3 1 2 4 -- Ian -- "0-0 Wai Wai ^-^" wrote in message ... "Ian" ¦b¶l¥ó ¤¤¼¶¼g ... Do you mean permanently, or to be able to toggle between them? Permanently. But if I can toggle between them, I would like to know too.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
| Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
| Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
| Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
| COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Linear Mode
