Why can't I repeat a sort on another range of a worksheet?

D

DistantFlier

In previous versions of Excel (through 2003), you could set up a sort on one
range of a worksheet and then use it on a another similarly set up range in
the same worksheet by using CTRL-E R or CTRL-Y.

Is there a way to enable that functionality in Excel 2007? I have several
workbooks with that set up. This would cut down on having to reenter a 3 or
4 step sort every time I want to use it.
 

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

Top