Insert an elegant table quickly in Excel

Sometime we may need to insert a table in Excel. Here are the steps.1. Open an Excel document, click the Insert > Table.2. In the pop-up dialog, you can select the cell range where you want to create a table. You can also check My table has headers according to individual needs. 3. You can also change its style in the toolbar. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

How to export a document to PDF?

1. Option 1: Click Export to PDF icon at the top left as below. Option 2: Click Menu → Export to PDF. 2. After setting as you need, click Export to PDF. 3. When the output is complete, you can use WPS Office to open the PDF file. Tips: PDF to Word/Excel/PPT: free of chargePDF to Word/Excel/PPT: only for membership For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

How to set the cell color to change as the data changes？

1. Open the table in WPS Office, select the cells that you want to set. 2. Click Home → Conditional Formatting → Highlight Cells Rules. 3. Select one of the rules as you need. Here we select Equal to for example. Fill a "5" in the text box, and select Light Red Fill with Dark Red Text. Then click OK. In the same way, we set "6" as Yellow Fill with Dark Yellow Text, and "7" as "Green Fill with Dark Green Text". 4. When the data in other cells is changed to 5, the changed cell will becom....

How to convert Word to PDF quickly

An editable Word document is convenient for us to revise and update, but what if we want to protect the content in that document? It would be a wise choice to convert Word documents to PDF files so that both the text and layout can be prevented from careless changes. · Steps to convert Word to PDF quickly in WPS Office.1. Open your Word document in WPS Office.2. Click Menu > Export to PDF. In the Export to PDF dialog:3. Check the document that you need to convert to PDF.4. Input the Ex....

Easy steps to crop PDF file in WPS Office

Are you ready to master easy steps to crop PDF file? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. Sometimes we may need to crop the PDF file to make it look better or remove the redundant content. WPS Office provides the Crop Page function, allowing you to crop PDF files quickly. · Steps to crop PDF file in WPS Office1. Open your PDF file in WPS Office.2. Head to the Edit tab, and click Crop Page to enter the cropping mode. 3. Here are four bu....

How to reduce size of PDF in WPS Office

Are you wondering how to reduce the size of a PDF file when printing? WPS Academy is here to introduce you to a quick and practical method of changing Page Size. · Quick steps to reduce size of PDF in WPS Office.1. Open your PDF file in WPS Office.2. Click the Menu button in the upper left corner > Print.3. In the Page Setup area, choose the desired size at the Page Size drop-down menu. Here we choose A5 for demonstration.4. Then click Print to save the settings. Note: No change can b....

How to split PDF quickly in WPS Office

Are you ready to master how to split PDF quickly in WPS Office? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. · Steps to split PDF quickly in WPS Office.1. Open the PDF file you need to split.2. Go to the Page tab > Split PDF. 3. Select the PDF file to split.4. Set the Page range, and set the splitting method at Split by.5. Set the location to save the split PDF file at Save as location.6. Click Split. With these steps, you are able to split P....