Tuesday, August 13, 2013

FW: End of the Week Helpful Hints: ASAP Utilities: Insert sheet(s) name in selected cell(s)

Insert sheet(s) name in selected cell(s)

Did you know…you can inserts the name of the worksheet into your selected range in each of your selected worksheets?

 

In the Excel menu choose ASAP Utilities » Fill » Insert sheet(s) name in selected cell(s)


You can for example use this to insert the sheet name into cell A1 on every selected worksheet.

Screenshots

Example screenshot: 1 Insert the name of each selected sheets in the selected cell on each worksheet

Example screenshot: 2 The sheetname is entered in cell A1 of every selected sheet

 

 

No comments:

Post a Comment