Smart Fill
Smart Fill helps you quickly complete data entry by recognizing patterns in existing cells and filling adjacent cells automatically. It provides the tools you need to apply example-based filling in WPS Sheets, making your work more efficient and helping you accomplish tasks with ease. With Smart Fill, you can enter one or two sample values, select the sample cells, and let the feature detect the pattern and fill the remaining cells. It supports text splitting and merging, date format conversion, number patterns, and text extraction, and also offers the Ctrl + E shortcut. Whether you're standardizing dates, extracting text, combining text, or extending number sequences, Smart Fill helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.