WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up

      144 results for install openoffice ubuntu

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

      144 results for install openoffice ubuntu

      Change paper orientation and size for printing

      Change paper orientation and size for printing

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

      Writer 29.8K 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 32.4K views
      SUBTOTAL function: Calculate the data with the hidden value

      SUBTOTAL function: Calculate the data with the hidden value

      02:33

      SUBTOTAL function: Calculate the data with the hidden value

      Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

      Spreadsheet 12.0K views
      The SUMPRODUCT function for quick calculation of total sales

      The SUMPRODUCT function for quick calculation of total sales

      01:44

      The SUMPRODUCT function for quick calculation of total sales

      When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

      Spreadsheet 6.1K views
      Set the page printing area in WPS Office Spreadsheet

      Set the page printing area in WPS Office Spreadsheet

      00:47

      Set the page printing area in WPS Office Spreadsheet

      What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

      Spreadsheet 13.2K views
      Basic settings on footer and header

      Basic settings on footer and header

      01:44

      Basic settings on footer and header

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

      Writer 31.7K views
      How to customize draw borders for tables

      How to customize draw borders for tables

      01:19

      How to customize draw borders for tables

      When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

      Spreadsheet 28.1K views
      How to use Name Manager

      How to use Name Manager

      01:13

      How to use Name Manager

      We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

      Spreadsheet 7.7K views
      Prev 1 2 3 ... 17 18 Next
      WPS Academy
      Products
      WPS Office for Windows
      WPS Office for Mac
      WPS Office for Android
      WPS Office for iOS
      WPS Office for Linux
      Partners
      Links
      OEM Partners
      Strategic partners
      Office Version
      Office

      Follow us

      WPS Office Official Twitter

      WPS Office Official Facebook

      WPS Office Official YouTube