Whether you work with documents day-to-day or only from time to time need them, DocHub is here to assist you take full advantage of your document-based projects. This tool can set name in form, facilitate user collaboration and create fillable forms and valid eSignatures. And even better, every record is kept safe with the highest security requirements.
With DocHub, you can access these features from any place and using any platform.
from the menu select formulas and then from the ribbon choose name manager click new and in the name field type list sheets in the refers to formula field type in this formula ill copy this formula to description for you click ok click close now create a new worksheet in column a enter some values say 1 to 10 or 1 to 15 then in cell b1 enter the following formula equals index open your brackets or parentheses then list sheets comma a1 close brackets or present parenthesis press enter return on your keyboard copy your formula down and when youve docHubed the end of your list of worksheet names you will see the ref error simply delete those and you can see the names of your current worksheets thanks for watching bye