Repeat Sort in Excel 2007

G

Guest

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
 
R

Roger Govier

Hi Kevin

If you highlight any cell in your list and choose Insert tab>Table>OK.
Then you will have a table with dropdown arrows in each of the headers.
Click any dropdown and choose Sort A>Z or Z>A. the whole table is
elected automatically and will follow the sort the have selected for
each column in turn.
 
G

Guest

Roger, thanks for the Table tip, but my situation is a bit unique. I have to
resort multiple sections in a workbook with completely new data each time and
it doesn't always line up the same way. Also, I need to be able to sort by
at least 2 or 3 columns each time (one column is sales, but the other is a
coding system that take priority over sales yet has numbers that
repeat...there may be several items with a "3" for instance).

Any other ideas? Or, any way to get the "F4" function key to work with
sorting in 2007 like it does in 2003?

Thanks,
Kevin
 
C

Claudia Madero

Hi Kevin!!

Did u find out a shortcut to to repeat a data/sort in different worksheets in excel 2007????.. I mean did you foun a similar "F4" function that works in 2007 (sorting tables) ???

Thaaaaaaaaaaanks!
Claudia =D



Kevin wrote:

Roger, thanks for the Table tip, but my situation is a bit unique.
27-Jun-07

Roger, thanks for the Table tip, but my situation is a bit unique. I have to
resort multiple sections in a workbook with completely new data each time and
it doesn't always line up the same way. Also, I need to be able to sort by
at least 2 or 3 columns each time (one column is sales, but the other is a
coding system that take priority over sales yet has numbers that
repeat...there may be several items with a "3" for instance)

Any other ideas? Or, any way to get the "F4" function key to work with
sorting in 2007 like it does in 2003

Thanks
Kevi

:

Previous Posts In This Thread:

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

Hi KevinIf you highlight any cell in your list and choose Insert tab>Table>OK.
Hi Kevi

If you highlight any cell in your list and choose Insert tab>Table>OK
Then you will have a table with dropdown arrows in each of the headers
Click any dropdown and choose Sort A>Z or Z>A. the whole table is
elected automatically and will follow the sort the have selected for
each column in turn
--
Regard

Roger Govie


Roger, thanks for the Table tip, but my situation is a bit unique.
Roger, thanks for the Table tip, but my situation is a bit unique. I have to
resort multiple sections in a workbook with completely new data each time and
it doesn't always line up the same way. Also, I need to be able to sort by
at least 2 or 3 columns each time (one column is sales, but the other is a
coding system that take priority over sales yet has numbers that
repeat...there may be several items with a "3" for instance)

Any other ideas? Or, any way to get the "F4" function key to work with
sorting in 2007 like it does in 2003

Thanks
Kevi

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Callback and Manual Partial Page Rendering
http://www.eggheadcafe.com/tutorial...4-00afc3fb9222/callback-and-manual-parti.aspx
 
P

Peter Lingenfelter

If anyone figures this out, I'd like to hear as well. All I keep seeing in the various discussions are the same answers that don't apply. I think a macro could do it, but the sortfield would have to automatically update based on the selected data, i.e. it would always sort on the same column(s), but the row numbers would update. Anyone want to volunteer the appropriate macro text?



Claudia Madero wrote:

heeeelp
21-Jan-10

Hi Kevin!!

Did u find out a shortcut to to repeat a data/sort in different worksheets in excel 2007????.. I mean did you foun a similar "F4" function that works in 2007 (sorting tables) ???

Thaaaaaaaaaaanks!
Claudia =D

Previous Posts In This Thread:

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

Hi KevinIf you highlight any cell in your list and choose Insert tab>Table>OK.
Hi Kevi

If you highlight any cell in your list and choose Insert tab>Table>OK
Then you will have a table with dropdown arrows in each of the headers
Click any dropdown and choose Sort A>Z or Z>A. the whole table is
elected automatically and will follow the sort the have selected for
each column in turn
--
Regard

Roger Govie


Roger, thanks for the Table tip, but my situation is a bit unique.
Roger, thanks for the Table tip, but my situation is a bit unique. I have to
resort multiple sections in a workbook with completely new data each time and
it doesn't always line up the same way. Also, I need to be able to sort by
at least 2 or 3 columns each time (one column is sales, but the other is a
coding system that take priority over sales yet has numbers that
repeat...there may be several items with a "3" for instance)

Any other ideas? Or, any way to get the "F4" function key to work with
sorting in 2007 like it does in 2003

Thanks
Kevi

:

heeeelp
Hi Kevin!!

Did u find out a shortcut to to repeat a data/sort in different worksheets in excel 2007????.. I mean did you foun a similar "F4" function that works in 2007 (sorting tables) ???

Thaaaaaaaaaaanks!
Claudia =D


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Customized Find Control for FlowDocuments
http://www.eggheadcafe.com/tutorial...3-721a40cf910c/wpf-customized-find-contr.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort part of a filtered spreadsheet 1
rows to repeat at the top 4
Repeat sorting with F4 in 2007 2
Filter & Sort 3
2 dimensional date sort 1
excel 2007 sort problem 2
Excel Data Sort in Excel2000 2
Repeat function in Excel 2007 not working when sorting data 5

Top