Quickly insert all sheet names in cells with VBA If you want to inset all sheet names in cells, VBA macro is a good choice Step 1 Hold down the Alt F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window Step 2 Click Insert >If there are only few worksheets in your workbook, and you can get a list of all worksheet tab names by manually Let's see the below steps #1 open your workbook #2 double click on the sheet's name in the sheet tab Press Ctrl C shortcuts in your keyboard to copy the selected sheet #3 create a notepad file, and then press Ctrl V toThen select Data in a range option from the Sheet names based on list box, and click button to select the cell values that you want to use 3 And then click Ok button, the worksheets have been created with the names of the cell values in a new workbook, see screenshot
Is There A Google Sheets Formula To Put The Name Of The Sheet Into A Cell Stack Overflow