Insert/Delete Cell

Insert/Delete Cell helps you add or remove cells in WPS Sheets while automatically adjusting the spreadsheet structure. It provides the tools you need to modify specific cells, entire rows, entire columns, or selected ranges, making your work more efficient and helping you accomplish tasks with ease. With Insert/Delete Cell, you can insert cells and shift existing cells right or down, insert rows above or below, insert columns to the left or right, delete cells and shift surrounding cells left or up, delete entire rows or columns, and delete empty rows when multiple rows are selected, with some options requiring membership. Whether you're reorganizing data or cleaning up blank rows, Insert/Delete Cell helps formula references adjust automatically and supports undo with Ctrl + Z. Choose the documentation below that best matches your needs to learn more.