Repeat sorting with F4 in 2007

G

G-Master

Hi,

when I was using excel 2003, I could repeat a sorting order on comparable
data using the F4-function.

E.g. I sorted data in 2 columns based on the values in column B for example
(from high to low). Then I could select other data and just press F4 to
repeat the same sorting order.

Has this feature been removed from excel 2007, because I can't repeat a
sorting action?
 
B

Bob Phillips

I have just tried it and you are right. Bit naff isn't it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Jon Peltier

The F4 key has lost much of its functionality in Excel 2007 charts. It used
to repeat everything done in a trip to a formatting dialog, but now at best
it remembers only the latest action. Hardly a timesaver anymore.

- Jon
 

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 Repeat Using F4 0
Repeat function in Excel 2007 not working when sorting data 5
F4 Repeat Action -- not fully functional in Office 2007 5
Sorting a column based on required order 2
How do I get F4 function to repeat entire last word 1
how can I insert code for F4 function key? 0
Sorting order of foreign languages 0
sorting customer name and IP with value 1

Top