Here is an easy way to insert the current worksheet’s name into a cell
Insert the following formula into any cell and press enter
In the below we have called the worksheet Sales Data. The formula above is in cell A1.
This could be used as a handy way to insert multiple headers at once across the workbook
For further information on this or anything else Excel related to do not hesitate to contact us or leave a comment below