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

Insert Sheet Name in a Cell in Excel using VBA
Call Now Button