Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat sorting with F4 in 2007
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat sorting with F4 in 2007
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) "G-Master" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat sorting with F4 in 2007
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "G-Master" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by color Excel 2007 | Excel Discussion (Misc queries) | |||
sorting on imported Data Excel 2007 | Excel Discussion (Misc queries) | |||
Repeat a sort in Excell 2007 | Excel Discussion (Misc queries) | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) |