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
=MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,255)
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
