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
      • excel lower case to upper case shortcut

      67 results for excel lower case to upper case shortcut

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

      67 results for excel lower case to upper case shortcut

      How to change case in Excel

      There are three relevant functions can help a lot. Here we take a name table as an example.1. UPPER functionWe can use this function to convert the whole word to upper case. Enter the formula “=UPPER(A2)”, and drag the mouse to fill the following cells. 2. LOWER functionWe can use this function to convert the whole word to lower case. Enter the formula “=LOWER(B2)”, and drag the mouse to fill the following cells. 3. PROPER functionWe can use this function to convert the first letter t....

      Writer 1,923 views
      How to download pictures in batches in WPS Writer

      How to download pictures in batches in WPS Writer

      01:04

      How to download pictures in batches in WPS Writer

      When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

      Writer 5 views
      How to find the specified text content in WPS Presentation

      How to find the specified text content in WPS Presentation

      01:06

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

      Presentation 368 views
      Quickly replace the content and font in WPS Presentation

      Quickly replace the content and font in WPS Presentation

      01:40

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

      Presentation 558 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 1,546 views
      How to use the document comparison function

      How to use the document comparison function

      01:40

      How to use the document comparison function

      After modifying the document, we can compare it with the original document and generate the revised document if we want to view the modification trace. Next, I will show you how to use the comparison function through a case. Take "Document 2" as an example. Click the Review tab and the Compare drop-down button, and choose Compare. Then, a dialog box will pop up. In the Original document box, select "Document 1". In the Revised document box, select "Document 2". In the Label changes wit....

      Writer 647 views
      Use CONCAT function to merge data

      Use CONCAT function to merge data

      01:16

      Use CONCAT function to merge data

      We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....

      Spreadsheet 118 views
      How to insert shapes in WPS Writer

      How to insert shapes in WPS Writer

      01:25

      How to insert shapes in WPS Writer

      Inserting patterns and shapes can increase the aesthetics of the document. Take this document as an example. We can add shapes to make workflow diagrams. For all, easy your work with WPS Writer. First, click the Insert tab, and click the Shapes button. In the selection list, we can see different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners and Callouts. These shapes can be selected according to personal needs. In th....

      Writer 918 views
      Prev 123...89 Next
      WPS Academy