Download WPS Office for your device
Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

Download WPS Office for All Platforms
Find your device and get the right version
- Choose your platform
- Download WPS
- Install and launch
Search Results
465 results for how to show gridlines in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
465 results for how to show gridlines in excel
How to add gridlines and guides in WPS Presentation
01:31How to add gridlines and guides in WPS Presentation
When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....
Customize the formats to show data changes
01:28Customize the formats to show data changes
Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....
Use slash header to show the title name
01:25Use slash header to show the title name
Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....
Show or hide editing marks
02:27Show or hide editing marks
All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....
How to convert Excel to PDF
02:50How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
The Rehearse Timings feature of Slide Show
01:21The Rehearse Timings feature of Slide Show
It is very important to limit the length of your speech in some speech contests or formal speech occasions. WPS Presentation provides the Rehearse Timings feature for us to rehearse the speech. Take this slide as an example. 1. Head to the Slide Show tab, and click the Rehearse Timings button to enter the rehearse mode. In the upper left corner, there is a timer that can be moved freely. 2. Click the inverted triangle icon on the left or click to jump to the next slide, and then the sl....
How to insert pictures in Document
02:05How to insert pictures in Document
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....
How to use OCR in PDF
02:12How to use OCR in PDF
Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....