The View Options utility of Kutools for Excel makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scroll bar, Horizontal Scroll bar, Sheet Tab, … etc.
(2) For only displaying/hiding the Row & column heading in active worksheet, please do not click the Apply to All sheets button. (1) For displaying the Row & column headings, please check the Rows & column headers option In the opening View Options dialog box, please uncheck the Rows & column headers option to hide the headings, and then click the Apply to all sheets button and Ok button successively. 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.
