How to shift among multiple spreadsheets

· Option 1: We can shift among different sheets with shortcut keys Ctrl + PageDown and Ctrl + PageUp on the keyboard.· Option 2: Click on the sheet tabs (e.g. sheet1, sheet2, sheet3) at the bottom of the interface to shift among different spreadsheets.WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.

How to hide zero(s) in a worksheet

1. Click Menu at the upper-left corner → Options2. Get into the View tab in the pop-up window.3. In the category of Window options, uncheck the Zero Values option4. Press Enter. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

Quick access to insert date and time into a sheet

lShortcut to insert the date: CTRL + semicolom(;)lShortcut to insert the time: CTRL + quotation mark(") WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

How to shade every other row in WPS Spreadsheet

Take this table as an example. 1. Set the color of part of the table according to our needs. 2. Select this area and double-click the Format Painter. 3. Then select the table areas we want to shade. In this way, we can quickly shade every other row in WPS Spreadsheet. This skill could also be used in Microsoft Office Excel and OpenOffice.

Present formulas as text in a sheet

1. Double-click the target cell.2. Insert a single quote (‘) at the beginning of the cell.3. Press Enter.As we can see, the complete formula presents in the original cell.To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to change cell formats

1. Select the cell range.2. Right-click on it and choose Format Cells... (Shortcut keys: Ctrl+1) 3. Then we can change the cell format in the Format cells pop-up window. In this example, we choose the Currency tab and set '2' Decimal places for the data. WPS Spreadsheet could be an alternative to Microsoft Office Excel, including more than 100 built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and supports for video, images, audio, and e....

How to split the merged cells

In WPS Spreadsheet, we can unmerge the cells that has been merged.1. Select the cell rage for recovery.2. Go to the Home tab → Merge and Center dropdown button → choose Unmerge and Fill Remember to change the cell format after you unmerge the cells. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to clear the format of cell in WPS spreadsheets?

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.To clear the format of all your slides at once, using the Clear option is probably the best idea, who has the final say about how your spreadsheet will look: the contents should have the same fonts, size, colour, etc. Let's learn how to do that. 1. Open your table in WPS Spreadsheets. It is no exaggeration to say that the format of this table is a me....