Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default sort part of a filtered spreadsheet

A user has an issue trying to sort on a selected range of data in a filtered
spreadsheet. Says she was able to do this in Excel 2003 and now cannot in
Office 2007. Data was originated from a query.
Data is in sections and wants to just sort a particular section. When
trying to do this, it sorts entire worksheet.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 118
Default sort part of a filtered spreadsheet

Can't imagine why you would want to do this but:
Select the range of data that she wants sorted. Then "sort and filter" and
select criteria. When the "Sort Warning" window pops select "Continue with
the current selection".

Be careful doing this because it "unsynchronises" your database.

If this helps please click "Yes"
<<<<<<<<<<

"jfaulks" wrote:

A user has an issue trying to sort on a selected range of data in a filtered
spreadsheet. Says she was able to do this in Excel 2003 and now cannot in
Office 2007. Data was originated from a query.
Data is in sections and wants to just sort a particular section. When
trying to do this, it sorts entire worksheet.

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
Inserting part of a Spreadsheet into the Current Spreadsheet nytwodees Excel Discussion (Misc queries) 3 April 22nd 09 06:16 PM
Filtered spreadsheet performance mckzach Excel Worksheet Functions 1 April 9th 09 10:01 PM
Sort by part of a number sacredarms New Users to Excel 2 July 25th 06 06:48 PM
Data Sort 2 part question Roman Excel Discussion (Misc queries) 0 March 3rd 06 08:00 PM
How sort filtered file. Rao Ratan Singh New Users to Excel 1 December 26th 05 01:54 PM


All times are GMT +1. The time now is 06:51 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"