How can we change the font in a cell

When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

How to change the table format

When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

Change paper orientation and size for printing

How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....

Change horizontal data to vertical and make data clearer

In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

How can we check word count in the Document

When we are editing a document, we want to check how many characters we have entered in total. Or if we want to check the number of words in the selected paragraph, we can use the word count function. It can quickly help us count the pages, words, etc. in the document. For all, easy your work with WPS office suite. Taking this document as an example, in the status information area on the status bar at the bottom of the interface, we can get general information about the word count, the....

How to use the spell-check function

The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....

Quickly replace the content and font in WPS Presentation

When using WPS Presentation, we want to make changes to the specified content or font of the text. Take this slide as an example. If we want to quickly replace WPS in the text with WPS Office,Click the Home tab, then click the Replace drop-down button and choose Replace.Or use the shortcut key Ctrl+H.In the pop-up dialog box, enter WPS in the edit box. We can also set the replacement conditions as needed, such as Match case and Find whole words only.In the Find what box, enter WPS. Whi....

How to find the specified text content in WPS Presentation

When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....