Fill

Fill helps you quickly enter repeated data or data that follows a pattern in WPS Sheets Collaboration Mode. It provides the tools you need to batch copy values and continue sequential data, making data entry more efficient and helping you accomplish tasks with ease. With Fill, you can select a cell range with source data at the top, activate fill, and drag the arrows that appear to fill down or fill right. You can also use Copy Fill to copy values only without applying sequential incrementing. Whether you're copying repeated entries, extending sequences such as 1, 2, 3, or filling data in a filtered sheet where only visible cells are affected, 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.