横向倒置

hqhl2008

<br /><br /><P>横向倒置，方法不限。</P>
<P>
<TABLE style="WIDTH: 714pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=952 xstr="">
<COLGROUP>
<COL style="WIDTH: 51pt" span=14 width=68></COL></COLGROUP>
<TBODY>
<TR style="HEIGHT: 19.5pt; mso-height-source: userset" height=26>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; WIDTH: 51pt; HEIGHT: 19.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=26 width=68><FONT face=宋体>数据</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68 xnum=""><FONT face=宋体>0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>e<FONT class=font5>f</FONT></FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>ghf fgh</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>hfh</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68 xnum=""><FONT face=宋体>4255</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>中华</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68 xnum=""><FONT face=宋体>5454</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=68><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68 xnum=""><FONT face=宋体>7778</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=68><FONT face=宋体>中2</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=68><FONT face=宋体>　</FONT></TD></TR>
<TR style="HEIGHT: 19.5pt; mso-height-source: userset" height=26>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; BORDER-TOP-COLOR: windowtext; HEIGHT: 19.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=26><FONT face=宋体>结果</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 xstr=""><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>中2</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>7778</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 xstr=""><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>5454</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>中华</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>4255</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>hfh</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 xstr=""><FONT face=宋体>　</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>ghf fgh</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>ef</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66><FONT face=宋体>0</FONT></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 xstr=""><FONT face=宋体>　</FONT></TD></TR></TBODY></TABLE></P>

lxgexcel

<p>=INDEX($B$1:$L$1,COLUMNS($B$1:$L$1)-COLUMNS($B$1:B1)+1)</p><p>{=INDEX($B$1:$L$1,COLUMNS(B1:L1)-TRANSPOSE(ROW(INDIRECT(COLUMNS(B1:L1)&amp;":1")))+1)}</p>

迎客松

<p>=OFFSET($B$1,,COLUMN(OFFSET($B$1,,COUNTA($B$1:$N$1)-1))-COLUMN())</p><p></p><p></p>

我是哈哈

=OFFSET($C$1,,COLUMNS($C$1:$M$1)-COLUMN(A:A))

一剑惊心

<p><font style="BACKGROUND-COLOR: #b3b34d;">在工具、选项、国际里，使用从右向左查看工作表</font></p><p>&nbsp;</p><p>这个算不算？</p>[em01][em01]

tkgg93

<br/>

faliming7

[em17][em17]

啊诺

<table cellspacing="0" cellpadding="0" width="72" border="0" xstr="" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="40" style="HEIGHT: 30pt;"><td class="xl24" width="72" height="40" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font face="Wingdings" size="6">C <table cellspacing="0" cellpadding="0" width="72" border="0" xstr="" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="40" style="HEIGHT: 30pt;"><td class="xl24" width="72" height="40" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font size="6"></font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="72" border="0" xstr="" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="40" style="HEIGHT: 30pt;"><td class="xl24" width="72" height="40" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 30pt; BACKGROUND-COLOR: transparent;"><font size="6"></font></td></tr></tbody></table></font></td></tr></tbody></table>

万杰

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>一剑惊心</i>在2008-6-15 11:14:00的发言：</b><br/><p><font style="BACKGROUND-COLOR: #b3b34d;">在工具、选项、国际里，使用从右向左查看工作表</font></p><p></p><p>这个算不算？</p>[em01][em01]</div><p>一剑总能想出些稀奇古怪的东西了！</p>

万杰

楼上用行排序，果然高明啊！学习了