Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Thursday, September 10, 2015 – Permalink – Sort worksheetsOrder tabsWorksheets can be dragged and dropped into any order required. They can be set up in numeric or alpha order, but doing it by hand is a bother. Chip Pearson has written some macros that will do the job for you:
Here's the code to sort by tab color: Sub GroupSheetsByColor() Sorting Worksheets In A Workbook (The colorindex variable chooses one of the 56 colors in Excel's basic palette. Here are all the colors and numbers as compiled by F. David McRitchie:Excel Colors ) See all Topics excel <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
|