Custom Sort Multiple Tabs

Resolved · Low Priority · Version 2003

Thu 22 Jul 2010, 16:56 Delegate Virginia said...

Virginia has attended:
Excel Advanced course

Custom Sort Multiple Tabs

Can you custom sort multiple tabs at the same time. If you group tabs it wont let you enter the custom sort parameters, is there anyother way of doing it?

Tue 27 Jul 2010, 13:09 Trainer Simon said...

RE: Custom Sort Multiple Tabs

Hi Virginia,

Thank you for your question.

As far as I am aware, there is no way of doing this using the front end of Excel.

It would have to be a VBA routine.

If I do come across an answer I will email you back.

Regards

Simon

Tue 3 Aug 2010: Automatically marked as resolved.

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

Custom Sort Multiple Tabs

Custom Sort Multiple Tabs

RE: Custom Sort Multiple Tabs

Excel articles

Excel tip:

Switch on smart tags – Excel 2007