Repeat sorting with F4 in 2007

G

Guest

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

Repeat function in Excel 2007 not working when sorting data 5
How do I get F4 function to repeat entire last word 1
sorting customer name and IP with value 1
Why doesn't my repeat key (F4) work all the time in 2007? 3
Repeat Sort in Excel 2007 4
pivot table in Excel 2007 & 2000 (backward compatibility problem) 3
Excel 2007 Pivot Table Sorting 1
Excel 2007 Sort Order not working 1

Top