Click Kutools > Show / Hide > View Options.Ģ.
Full feature free trial 30-day, no credit card required! Get It Nowġ. Kutools for Excel- Includes more than 300 handy tools for Excel. Display/hide the headings in each worksheet one by one? No, that's too tedious! Here I will introduce Kutools for Excel's View Options utility to batch display/hide the Row & Column headings in all worksheets together.
But sometimes, you need to display/hide the Row & Column headings in all worksheets. The above method can only display/hide the Row & Column headings in one worksheet at a time.