sort a [group] of sheets

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

rbraxton

Board Regular
Joined
Oct 17, 2002
Messages
197
sorry, i wasn't very descriptive...

I have like 200 sheets in a workbook and I'd like to reorganize them in alphabetical order.

Also,
Is there a way to quickly 'Go to...' a sheet without scrolling through a list to find the sheet?

Thanks,
Rob
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,062
Office Version
  1. 365
Platform
  1. Windows
Rob

Do you mean sort the order of the sheets?

Or sort the data in every sheet?

If you right click the navigation buttons in the bottom left you'll get a list of worksheets to navigate to.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
To create a list of navigable worksheet names, check
Table of Contents
http://www.tushar-mehta.com/excel/software/maketoc/index.html

For an add-in that supports workbook navigation (in addition to right-clicking the VCR controls near the bottom left of the XL environment) see
Workbook Navigator for Excel
http://www.tushar-mehta.com/excel/software/utilities/wb_nav.html

To actually sort the sheets see Chip Pearson's
http://www.cpearson.com/excel/sortws.htm

rbraxton said:
sorry, i wasn't very descriptive...

I have like 200 sheets in a workbook and I'd like to reorganize them in alphabetical order.

Also,
Is there a way to quickly 'Go to...' a sheet without scrolling through a list to find the sheet?

Thanks,
Rob
 

rbraxton

Board Regular
Joined
Oct 17, 2002
Messages
197
Thanks tu!

(that's what I was talking about...sorting sheet names)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,911
Messages
5,575,001
Members
412,633
Latest member
simon_elvin
Top