There are 8 free training classes of how to use office suite for WPS
How to turn off automatic numbering in WPS Writer
When editing documents, we sometimes don't want WPS Office to automatically number list for us every time we press the Enter key. So how can we turn off automatic numbering?1. First open the file in WPS Writer.2. Click the Menu button in upper lefter corner.3. Then select Options in the drop-down menu. Now a Options dialog box will pop up.4. Click Edit → and then check Auto numbered lists.5. Finally click OK.This skill could also be used in Microsoft Office Word and OpenOffice.
Top 10 Excel Construction Schedule Templates
Top 10 Excel construction schedule templates Top 10 Excel construction schedule templates are used for detailed overview of the given task in any project. It includes all the phases of an entire project that are required to complete that. It helps in summarizing all the information step by step by including the schedule, cost and timeline of whole project. Excel construction schedule sheet templates include all the necessary data calculation formulas and charts. These templates are fre....
Add a drop down list in Excel with multiple selections
How to add a drop down list in excel? You need to know to add a drop down list in excel because it is an easy way to control all the values you enter in a cell. You can make a drop-down list in Excel in several ways to handle this program perfectly. If you don't know much about using Excel, don't worry, you can learn with various easy methods like add a drop down list in excel quickly. You must practice each step of how to add a drop down list in excel so that you become a ....
Excel dark mode add on mac
Excel dark mode add on The excel dark mode add on allows you to make the appearance of your spreadsheet more pleasing to the eye. In addition, the dark mode will help you focus on your work at any time of the day. The screen becomes more comfortable to read, especially with high contrast settings. If you want to darken the Excel interface using the excel dark mode add on you are in the right place. Below are the steps you need to follow to enable dark mode and how to properly darken ce....
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 wrap text in WPS Writer
1. Use WPS Office to open the document.2. Place the mouse cursor at the position where you want to wrap the text.3. Press the Enter key on the keyboard.4. We finish the text wrapping. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.
How We Can See File Extension in Excel Windows
The extension of an Excel file provides you with important information about that file before you open it. It also lets you organize the files you save into your directories as template files, macro-enabled files, and more. With just a glance at the Excel file extension, you know more about the Excel file and what it’s used for. Excel file extensions tell you: Whether macros or VBA are included. If the file was saved with an older version of Excel. Whether the file format is base....
How to select text color
Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.1. Use WPS Office to open the document.2. Then select the text that we want to change color.3. Click the Home tab and then click the Text Color Bottom.Users can select the color they want here. But if users still can’t find the color they want, click More Font Colors.1. Also, first select the text that we want to change color.2. Select Advanced in the Colors popout box.3. Click a....