Get WPS Office on Mac

As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

When using WPS Office to print Spreadsheets, Documents, Presentations, and PDF files, we will often encounter various printing problems. So in this video, we are going to briefly explain the functions of each small feature in the print panel. Take this table as an example. 1. First of all, we need to make sure that the printer is in good condition and also ready to print. 2. In addition, we need to make sure the computer we are using can find the printing device in the local area netwo....

When making tables in word, we often need to set their accurate row height and column width. In this video, you'll learn how to adjust table row height and column width in word. · Row height:Select the table for settings. Next, get into the Table Tools tab and click Table Properties. Go to the Row tab of the pop-up dialog. Then, we can adjust the row height at Size. After checking the Specify height option, enter ’0.5’ in the input box. In the category of Row height is..., we can c....

When using WPS Office to print various files, we often encounter different small problems. This video will briefly explain the function of each small feature of the printing interface, and it could be compatible with Microsoft Office powerpoint. If you want to learn more printing skills, you can search printing in our WPS Academy to enjoy more related videos. Take this slide as an example. First, we need to determine that the printer hardware can work properly and is now running. We al....

When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently? Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three....

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

When we use WPS Document to edit documents, we sometimes may want to highlight the key contents in the document. In order to do this, we can add shading colors to the text. So how can we set the shading colors? Take this text as an example. Select the sentences that need to be highlighted, click the drop-down button on the right side of Shading in the upper taskbar, select color, then you can highlight the text you want. If you don't want to select any of the colors above, click Mo....