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

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

    software

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