close

Hi all!

Is there a way to exclude more than one column header row from the
Data-gt;Sort function?

I have a sheet which uses the first three rows for header information,
but Data-gt;Sort only allows me to exclude the first one.

Your help would be much appreciated

eZee--
eZee
------------------------------------------------------------------------
eZee's Profile: www.excelforum.com/member.php...oamp;userid=30837
View this thread: www.excelforum.com/showthread...hreadid=504985
You can either

1) Only select the bottom most header row when selecting you range for
sorting

2) Merge the three header cells into one cell and use the merged cell
as your
header row--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=504985

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

    software

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