How to insert a check box in WPS Spreadsheet

After we use WPS Office to open the spreadsheet, click the Insert tab, then click the Check Box button. Now place the mouse where we want to add a check box and click.This skill could be also used in Microsoft Office Excel and Openoffice.

How to delete the check box in WPS Spreadsheet

1. Open the file in WPS Spreadsheet.2. Click the Home tab → and then click the Find and Replace button.3. In the popup drop-down menu, choose Select Objects. 4. Now we can select the check box. Place the mouse on the check box, and click on it when the cursor turn into a 4-arrow symbol.5. Then press the Delete key. This skill could also be used in Microsoft Office Excel and OpenOffice.

How to switch rows and columns in WPS Spreadsheet

How to switch rows and columns in WPS Spreadsheet1. First use mouse to select all table contents.2. Use the shortcut key CTRL+C to copy cell contents. 3. Click the sell where we want to put the table.4. Then right-click Paste Special → Transpose. Now the horizontal data is changed to vertical. Remember to select the original data and right-click to delete.This skill could also be used in Microsoft Office Excel and OpenOffice.