How to use the SUM function
· Option 1:1. Select the cell range with data to sum up. 2. Click Formula → AutoSum You can also use the SUM function for multiple rows at the same time. · Option 2: 1. Choose the cell for sum up result.2. Input =SUM(B2:E2) .3. Press Enter on the keyboard.* If you want to get the rest of the results quickly, place the cursor at the down-right corner of F2 until symbol “+” present. Then, change the selected range with the mouse. To be office excel advanced, you could learn how to use W....
How to quickly merge and center cells in WPS Spreadsheet
After we use WPS Office to open the spreadsheet, select the cell that needs to be manipulated.Then click the Home tab and find the Merge and Center button. By clicking this button, we can quickly merge and center cells. Its shortcut key is Ctrl+M.This skill could be also used in Microsoft Office Excel and Openoffice.
Find and replace functions in Spreadsheet
· Option 1:[Find]1. Click Home → Find and Replace → Find 2. Enter the keyword you want to find. [Replace]1. Click Home → Find and Replace → Replace2. Enter the keyword you want to find in the first box, with contents to replace with in the second box. 3. Click Replace to replace the items one by one. 4. You can also click Replace All to replace all items. · Option 2: Use short keys [Find] Ctrl + F [Replace] Ctrl + HTo be office excel advanced, you could learn how to use WPS O....
How to display two pages of a PDF file side by side
1. Use WPS Office to open the PDF file.2. Click the Home tab → the Two Page button. For all, easy your work with WPS office suite.
How to convert PDF files as pictures
1. Open the PDF files in WPS Office. 2. Click the Home tab → PDF to Picture3. Customize your options in the popup dialog and click Export. Free PDF converter help to convert PDF to Word or Writer (doc/docx), Split or merge PDF documents. Save documents to PDF and send them through email right from WPS Office. Added built-in PDF reader to open PDF documents in WPS Writer Online.
Can users use WPS for free
Users can use WPS for free by downloading it from our official website (www.wps.com). After users activate their account, they can sign in and use WPS without payment. It is free and convenient.For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Android, iOS online.
How to repeat the table header on subsequent pages in WPS Writer
Take WPS Office for PC as an example.1. Select the cell range that need to be set to repeat the header rows on each page.2. Click Table Tools → Repeat Header Rows on the top menu bar. Notes: 1. This only affects tables that extend beyond a single page. If you insert tables separately on different pages, this function will not take effect. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.