WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


WPS Spreadsheet basic editing

Uploaded time: September 13, 2021 Difficulty Beginner

WPS Spreadsheet basic editing

WPS Spreadsheet basic editing

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns.

Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click the up, down, left, and right keys on the keyboard to quickly switch cells to enter content.

Sometimes we encounter the data is too longthat cannot be displayed completely in the cell. At this time, we can double-click the intersection of the column headings to quickly adjust the appropriate column width to display the complete cell content.

What if we want to insert a new column between column B and column C? Select column C, click on the right mouse button and choose the Insert option in the pop-up menu to quickly insert a new column in front of the current column. Similarly, the method of inserting rows is in the same way.

If you want to hide a column or row, you can select the row or column that needs to be hidden. Here we select column C, right-click, and choose the Hide option in the pop-up menu. If you want to unhide a column, just select the columns on both sides of the hidden column, right-click, and choose the Unhide option. The method of hiding rows is the same as that of hiding columns.

When we want to delete a row or column, just select the row or column, right-click, and choose the Delete option in the pop-up menu.

All above is the basic editing operation of the spreadsheet. Easy your work with WPS Spreadsheet like Microsoft Excel.Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.