Editing spreadsheet is fast and straightforward using DocHub. Skip installing software to your PC and make changes using our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competitive cost, makes DocHub the ideal decision to take out suggestion in spreadsheet files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the protection of your data, as we securely store them in the DocHub cloud.
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 iamp;#39;ll 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 youamp;#39;ve 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