220 results for how to put names in alphabetical order in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How we can use the settings of borders and shading01:43
How we can use the settings of borders and shading
When we are using WPS Document to edit text, we sometimes need to put a border around the text, or we may also want to add a special shading color to the text in order to highlight the keywords. So now the problem is, how can we do that? Take this resume as an example. If we want to highlight the border, we should select all the content first, and click the Home tab, and then lick the Outside Borders drop-down button. Here, we can see different styles of border lines. Click Borders and....
How to sort text in WPS Writer02:37
How to sort text in WPS Writer
When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....
How to use Notes Master in WPS Presentation01:30
How to use Notes Master in WPS Presentation
If slides show everything that a speaker says, the slides are dull and the speech is boring for audiences. Therefore, when making slides, we can present the necessary contents on the slides and put the supplementary contents on the notes page to print them out. In order to unify the style of each notes page, we can use the Notes Master feature. With this feature, we can have a unified format for all notes pages, including new notes pages after setting for it. Click the View tab on the ....
Insert a table into the text & convert between text and table02:48
Insert a table into the text & convert between text and table
When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....
How to put video in PowerPoint
1. Select the slide that we want to insert a video in.2. Click the Insert tab → the Movie drop-down button → the Local Video option.3. In the pop-up Insert Movie window, we select the video we want to insert, and click the OK button. Now, we have put this video in PowerPoint.4. By dragging the small white dots around the video, we can change the size of the video display. Then, we can place the video where we want by clicking the left-mouse button and dragging the video.5. We can clic....
Edit settings in WPS Spreadsheet03:47
Edit settings in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....
How to set up custom slide shows in WPS Presentation01:40
How to set up custom slide shows in WPS Presentation
When using WPS Presentation, how can we adjust the content and order of the slide show without deleting the original slides or even changing the page order of the original slides? The Custom Slide Shows feature can help us. Click the Slide Show tab at the top of the screen, and click the Custom Slide Shows button. In the popup dialog, click the New button to customize the settings for the slide show.In the popup Define Custom Show dialog, we can enter the name of the custom show in the....
Use conditional formatting to make data more intuitive04:46
Use conditional formatting to make data more intuitive
We often need to compare and mark the table setting conditions at work. But how can we see the trend of the data more intuitively? Take this table as an example. Suppose now we want to find out the names of milk tea with a quantity larger than 100 and mark the color.1. Select the quantity area, and click the Conditional Formatting drop-down button in the Home tab.2. Choose the Highlight Cells Rules option in it. Then, you can a popup window, where you can select Greater Than, Less than....