Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
eZee
 
Posts: n/a
Default Exclude more than one row from data-Sort


Hi all!

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

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

Your help would be much appreciated

eZee


--
eZee
------------------------------------------------------------------------
eZee's Profile: http://www.excelforum.com/member.php...o&userid=30837
View this thread: http://www.excelforum.com/showthread...hreadid=504985

  #2   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default Exclude more than one row from data-Sort


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: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=504985

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 12:45 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"