Crack the Code: Excel Sheet Formulas Every User Should Know: By Sudeshna Paul Anyone who spends time around spreadsheets eventually learns that Excel has two personalities. On the surface, it’s just ...

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook. Whether your Microsoft Excel workbook has three sheets or 50, knowing what you have is important.