214 results for validity powerpoint
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
Set formulas as the validation condition
00:59Set formulas as the validation condition
Sometimes we need some preconditions to improve the validity when inputting data. Today we will learn how to set formulas as the validation condition.For example, we only need to enter the spouse's name if the marital status in column D is "married."First, select the cell area E3: E11, click "Validation" in the "Data" tab to enter the "Data Validation" dialog, where we can select "Custom" at the "Allow" drop-down box.Then, enter the formula =D3="married." It means that people can ....
How to attach Excel file to PowerPoint
1. Click the Insert tab → the File Object button.2. Select the Excel file we want to insert, and click the Open button. Then, we can attach this Excel file to PowerPoint.3. Click the left mouse button to move the attachment icon, then we can change the location of the attachment. And, drag the small white dots around the icon, then we can change the size of the icon.4. Click the Slide Show from Current button to start the slide show. And we can click the attachment icon to pop up the c....
Typewriter effect in WPS Office PowerPoint
Welcome to WPS Official Academy to check the contents of Typewriter effect in WPS Office PowerPoint. The Typewriter effect is one of the amazing animations to make a perfect presentation. So how can we make a typewriter effect? Let’s have a try step by step. If you want to make a vintage typewriter look, we recommend going with a Courier New font in black.1. Insert a text box and input the content that you need.2. Set the font size as needed, and then set font style and font color. 3.....
More features in Split or Merge
02:26More features in Split or Merge
Sometimes we may need to split or merge documents when creating presentations. So how can we do that? In Microsoft PowerPoint1. To merge the editing PowerPoint with new slides, we can enter the "Home" tab, click ”New Slide," and click "Reuse Slides." Select a desired PowerPoint document on the right to insert it.2. In this way, only one document can be inserted at a time, and multiple documents require repeated operations to be merged.3. Besides, Microsoft PowerPoint doesn't suppor....
How to rename a hyperlink in WPS Office PowerPoint
Are you ready to master how to rename a hyperlink in WPS Office PowerPoint? With the help of this free tutorial in WPS Official Academy, you will become advanced from a beginner in PowerPoint designing. Now let's explore how to rename a hyperlink in WPS Office PowerPoint step by step.lHere are the steps to rename a hyperlink in WPS Office PowerPoint1. Open your PPT in WPS Presentation and locate the hyperlink you want to rename.2. Right-click the hyperlink, and select Hyperlink > E....
How to make video play automatically in PowerPoint
1. Click the video and get into the Video Tools tab.2. In the Start area, select Automatically in the box.3. Click the Slide Show from Current, or use the shortcut Shift+F5 to start the slide show from the current slide.4. Then we can make video play automatically in PowerPoint. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.
Add connection points to connectors in PowerPoint
To make the joint of a connector and a shape more clear, we can add connection points.1. Open your PowerPoint in WPS Office.2. Select the connector, and you can see four icons appear on the right of the shape. 3. Click the Shape Outline icon > Arrow Style. Then we can change its style to those with connection points as needed. We can also customize the connection points. 4. Double click the connector, and an Object Formatting pane pops up. 5. We can choose a desired size and shape for....
How to create magnifying glass effect in PowerPoint?
How to create magnifying glass effect in PowerPoint?Sometimes we need to highlight a specific area in our presentation pictures. Then we can create the magnifying glass effect in our slides.Now let’s explore the techniques step by step.1. Create a duplicate of the original picture with the shortcut key Ctrl+D. Then select the duplicate picture and click the Picture Tools tab. Then click Crop drop-down button and choose an oval shape preferably. 2.Next, narrow the cropped area as you wi....