Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how to go to next line in excel cell

      469 results for how to go to next line in excel cell

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      469 results for how to go to next line in excel cell

      How to set the line numbers in WPS Writer

      How to set the line numbers in WPS Writer

      01:56

      How to set the line numbers in WPS Writer

      The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

      Writer 782 views
      How to set the cell alignment in WPS Spreadsheet

      How to set the cell alignment in WPS Spreadsheet

      02:31

      How to set the cell alignment in WPS Spreadsheet

      To ensure the beauty of the spreadsheet, sometimes we need to align the contents of it. How can we quickly set the alignment of the spreadsheet?This video could help to solve the problem of How to set the cell alignment in WPS Spreadsheet. There are several alignment shortcut buttons in the ribbon, which are commonly used in the workplace. Now let's demonstrate them one by one.Top Align: Align text to the top of the cell.Middle Align: Align text so that it is centered between the t....

      Spreadsheet 1,876 views
      Wrap text in a cell

      Wrap text in a cell

      00:53

      Wrap text in a cell

      When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....

      Spreadsheet 4,096 views
      Conditional Formatting for data virtualization

      Conditional Formatting for data virtualization

      01:23

      Conditional Formatting for data virtualization

      Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

      Spreadsheet 32 views
      Adjust row height and column width of tables in word

      Adjust row height and column width of tables in word

      02:02

      Adjust row height and column width of tables in word

      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....

      Writer 330 views

      How to insert a line break inside a cell in WPS Spreadsheet

      1. Use WPS Office to open the spreadsheet first. 2. Select the cell where we want to insert a line break in, then place the mouse cursor where we start a new line, and double-click.3. Now click the Home tab, and click the Wrap Text button.Then we can see that a line break has been successfully added in the cell. We can also use the shortcut key Alt+Enter to start a new line.This skill could be also used in Microsoft Office Excel and Openoffice.

      Spreadsheet 1,930 views
      Create an area chart to display data trends

      Create an area chart to display data trends

      02:00

      Create an area chart to display data trends

      Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....

      Spreadsheet 63 views
      Use slash header to show the title name

      Use slash header to show the title name

      01:25

      Use 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....

      Spreadsheet 71 views
      Prev 123...5859 Next
      WPS Academy