- All Tutorials
- Video Tutorials
- Quick Tutorials
95 Search results
How can we change the font in a cell01:09
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 format00:51
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 horizontal data to vertical and make data clearer01:06
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....
Change paper orientation and size for printing01:20
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....
How can we set the character spacing in Documents01:32
How can we set the character spacing in Documents
When using WPS Writer for typesetting, we often need to adjust the spacing between characters. How can we adjust the character spacing?Take this document as an example. Select the text content, click Home in the upper menu bar, and choose Settings → Font. Then we can see the Font window. We can also press the shortcut key Shift+D to pop up the dialog. Get into the Character Spacing tab, and change the setting of Spacing. Here, we can choose one of the three default character spacing e....
How can we add underline and strikethrough01:02
How can we add underline and strikethrough
When using WPS Writer to review the manuscript, we sometimes add underline or strikethrough to highlight or delete the content. In this document, we can underline or emphasize the sentence. Select the corresponding part, click the Home tab, and then the Underline drop-down button. Then, we can change the types and colors for the underline. For more underline styles, click More Underlines to bring up the Font dialog. In the category of All text - Underline style, we can select more oth....
Quickly create dynamic charts01:12
Quickly create dynamic charts
We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....
How can we resize the images in Documents01:21
How can we resize the images in Documents
When using WPS Writer, we often insert pictures for instructions. Sometimes we need to resize the picture precisely. How can we adjust the size of picture in a document? In this document, insert a picture and adjust its layout. For example, we can change the layout to Behind Text in the Wrap Text catalog. Then, set the font color as white. Then right-click the image and choose More settings. In the pop-up interface Layout, click the Size tab. If we need to scale the picture proportion....