Editing WPS is fast and simple using DocHub. Skip downloading software to your computer and make adjustments with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and email documents for completion to other people. All of this, combined with a competitive price, makes DocHub the ideal choice to fill in brand name in WPS files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your data, as we securely keep 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