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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |