LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Repeat Sort in Excel 2007

In Excel 2003 you can repeat sort parameters for different sections of a
worksheet by using the F4 function key after performing your 1st sort, but I
can't get that to work in Excel 2007. Anyone know if there is a way to "fix"
that or is there an alternate way to do this in 2007?

I frequently have to sort many different sections within one worksheet. The
sorts are always based off of the same columns and require the same
parameters (i.e. Sort range by column C from low to high and column J from
high to low), but the number of rows included change for each grouping. In
2003, I could highlight the rows and hit "F4" to repeat this.

Thanks for any ideas.
Kevin
 
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
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
Repeat sorting with F4 in 2007 G-Master Excel Discussion (Misc queries) 2 April 13th 07 02:36 PM
Repeat a sort in Excell 2007 reem01 Excel Discussion (Misc queries) 0 November 21st 06 11:56 PM
EXcel 2007 - Unable to sort by font and cell colors Mr. Low Excel Worksheet Functions 1 October 28th 06 03:49 PM
Excel 2007 Sort A-Z not working but did in 2000 JohnHamer1977 Excel Discussion (Misc queries) 0 August 29th 06 03:12 AM


All times are GMT +1. The time now is 01:30 AM.

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

About Us

"It's about Microsoft Excel"