close

I have colored lines every other row and when I sort the colors go with the
text. How do I lock the formatting?

Maybe you could use format|conditional formatting to do the shading.

Chip Pearson shares a technique:
cpearson.com/excel/banding.htm

krolfe wrote:
gt;
gt; I have colored lines every other row and when I sort the colors go with the
gt; text. How do I lock the formatting?

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()