view list of worksheets contained within a workbook

[Guest]

how do i view list of worksheets contained within a workbook in excell?

 

[Peo Sjoblom]

Right click one of the sheet tab arrows at the left hand side
Only other option is to us VBA (macro)

 

[Gord Dibben]

A macro to list the sheets on a new worksheet.

Private Sub ListSheets()
'list of sheet names starting at A1
Dim Sh As Worksheet
Dim Rng As Range
Dim i As Integer
Worksheets.Add
Set Rng = Range("A1")
For Each Sh In ActiveWorkbook.Sheets
Rng.Offset(i, 0).Value = Sh.Name
i = i + 1
Next Sh
End Sub


Gord Dibben Excel MVP

 

[Guest]

how do i view list of worksheets contained within a workbook in excel?

You can also click on "File", drop to "Properties" and then click on the
"Contents" tab to see the list of worksheets