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

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