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 ...

Hide a sheet if you want, rather than delete it, making its data still available not only for reference, but also for formulas on other sheets in the workbook. Right-click the tab and select Hide.