一、excel表格如何建立索引目录
先可新建一个工作表《索引》，插入名称-定义，运用transpose(get,wordbook(1)提取足够多的工作表名再用超链接公式链接
用宏就比较简单了
我给你个宏的例子
根据你表格的情况 还要做部分修改
Sub mulu()
On Error GoTo Tuichu
Dim i As Integer
Dim ShtCount As Integer
Dim SelectionCell As Range
ShtCount = Worksheets.Count
If ShtCount = 0 Or ShtCount = 1 Then Exit Sub
Application.ScreenUpdating = False
For i = 1 To ShtCount
If Sheets(i).Name = "目录" Then
Sheets("目录").Move Before:=Sheets(1)
End If
Next i
If Sheets(1).Name <> "目录" Then
ShtCount = ShtCount + 1
Sheets(1).Select
Sheets.Add
Sheets(1).Name = "目录"
End If
Sheets("目录").Select
Columns("B:B").Delete Shift:=xlToLeft
Application.StatusBar = "正在生成目录…………请等待！"
For i = 2 To ShtCount
ActiveSheet.Hyperlinks.Add Anchor:=Worksheets("目录").Cells(i, 2), Address:="", SubAddress:= _
Sheets(i).Name & "!R1C1", TextToDisplay:=Sheets(i).Name
Next
Sheets("目录").Select
Columns("B:B").AutoFit
Cells(1, 2) = "目录"
Set SelectionCell = Worksheets("目录").Range("B1")
With SelectionCell
.HorizontalAlignment = xlDistributed
.VerticalAlignment = xlCenter
.AddIndent = True
.Font.Bold = True
.Interior.ColorIndex = 34
End With
Application.StatusBar = False
Application.ScreenUpdating = True
Tuichu:
End Sub
二、excel如何自动生成索引目录
第一步、用宏3.0取出各工作表的名称，方法：x0dx0aCtrl+F3出现自定义名称对话框，取名为X，在“引用位置”框中输入：x0dx0a=MID(GET.WORKBOOK(1),FIND("]",GET.WORKBOOK(1))+1,100)x0dx0a确定x0dx0ax0dx0a第二步、用HYPERLINK函数批量插入连接，方法：x0dx0a在目录工作表（一般为第一个sheet）的A2单元格输入公式：=HYPERLINK("#'"&INDEX(X,ROW())&"'!A1",INDEX(X,ROW()))x0dx0a将公式向下填充，直到出错为止，目录就生成了。
