WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to allow downloads on mac

    403 results for how to allow downloads on mac

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

    403 results for how to allow downloads on mac

    How to insert footnote in word document on Mac or Windows

    In our daily life and work, it is a necessary skill to insert footnote in Office software. When we want to explain some words or sentences, we can insert footnotes in one or a new page in word document on Mac or Window. It is a good choice to insert footnotes in Microsoft Office Word or WPS Office Writer on Mac or Windows. However, many users don't know the methods of inserting footnotes. Today, this article will introduce to you how to insert footnotes in word document on Mac or W....

    Writer views

    How to insert a checkbox in word document on Mac or Windows

    It is more than common to insert checkboxes in word document when we need to do application forms, tick boxes, and to-do lists in word document on Mac or Windows. You can click or fill in the checkboxes. It is a good choice to insert checkboxes in Microsoft Office or WPS Office Writer. There are two main types of checkboxes: the first one is the interactive checkbox that let a user check the box while in the Word document on their computers, and the other one is not interactive that y....

    Writer views

    How to insert PDF in Word documents on Mac or Windows

    When it comes to inserting multiple PDF files into a page in word documents, it is a good choice to place a PDF file as an image into word documents in Microsoft Office or WPS Office Writer. If you want to place a PDF file as an image into word documents, where you can easily crop, resize, or duplicate. Today, this article will introduce you to how to insert PDFs in word documents in WPS Office Writer. l How to convert .doc files to .pdf files?1. Head to the Tools tab and click the Exp....

    Writer views

    How to insert table of contents in word document on Mac or Windows

    Graduation coming, the most important thing for students is to writer a paper and how to insert table of contents in their paper. It is an indispensable part of long documents, helping readers to sort through the overall structure of the article and quickly locate and find the content in the document. What's more, a table of contents also creates links for each section, allowing you to navigate to different parts of your document.It is a good choice to use Microsoft Office and WPS ....

    Writer views
    Set Allow Users to Edit Ranges in a protected sheet

    Set Allow Users to Edit Ranges in a protected sheet

    02:04

    Set Allow Users to Edit Ranges in a protected sheet

    As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

    Spreadsheet views
    Use Validation to restrict date entries

    Use Validation to restrict date entries

    01:10

    Use Validation to restrict date entries

    When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....

    Spreadsheet views
    Set formulas as the validation condition

    Set formulas as the validation condition

    00:59

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

    Spreadsheet views
    Use Validation to prevent duplicate values

    Use Validation to prevent duplicate values

    01:23

    Use Validation to prevent duplicate values

    Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

    Spreadsheet views
    Prev 123...5051 Next
    WPS Academy
    Products
    Partners