1.

Solve : sorting Excel tabs alphabetically?

Answer»

Is there a command to sort Excel tabs alphabetically or numerically without manually moving each tab?

Thanks!it's pretty complicated and it only applies to columns not rows.

1. Select the row you want sort

2.Click the data tab in between formulas and review

3.Click filter, a tab will appear on the first row of the column.

3.there will be your options.
 Thank you! I'm embarrassed to say I misstated what I was looking for. How to sort the worksheet tabs at the bottom of the screen. 
 [EDIT] cross-posted.

I THINK the OP might have MEANT the tabs for individual worksheets, and if so, there is no built in sorting feature but you can do it by a VBA macro or a 3rd party addon...

http://support.microsoft.com/kb/812386

http://www.extendoffice.com/documents/excel/629-excel-sort-sheets.html

QUOTE from: johncyn70 on JUNE 12, 2014, 03:45:35 PM

I misstated what I was looking for

You didn't misstate anything.

Sorry for giving the wrong information. Thank you dodomut and salmon trout! I appreciate you taking the time help!


Discussion

No Comment Found

Related InterviewSolutions