Fill
Fill helps you quickly enter repetitive or patterned data in WPS Sheets. It provides the tools you need to copy values across a selected range, making data entry more efficient and helping you accomplish tasks with ease. With Fill, you can fill down, right, up, or left by copying the edge cell in the selection, calculate and enter rankings for a data range, fill blank cells using values from above, below, left, or right, insert the current system date in multiple date formats, and fill the selected area to other worksheets in the same group. Shortcuts for Fill Down and Fill Right are also supported. Whether you're copying repeated values, completing rankings, filling gaps, or entering dates, 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.