WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
        Related: wps downloadwps for windowswps for macwps linux download
        Official downloads for every device

        Download WPS Office for your device

        Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

        Free for personal use Cross-platform Microsoft Office compatible
        Download WPS for Windows .exe installer · 64-bit Download WPS for Mac .dmg installer · macOS
        Need a hand? View setup guide
        WPS Office official logo

        Download WPS Office for All Platforms

        Find your device and get the right version

        Compare All Versions

        Windows

        Windows 10/11
        64-bit

        Download .exe

        Mac

        macOS 10.12+

        Download .dmg

        Linux

        Debian / Ubuntu
        64-bit

        Download .deb

        Chromebook

        ChromeOS

        Use Linux Version

        Android

        Android 5.0+

        Google Play

        iOS

        iOS 12.0+

        App Store
        New to WPS Office? 3-step Setup Guide
        1. Choose your platform
        2. Download WPS
        3. Install and launch

        Search Results

        465 results for how to insert date and time in excel

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

        465 results for how to insert date and time in excel

        Insert date and time in the header or footer

        Insert date and time in the header or footer

        00:55

        Insert date and time in the header or footer

        WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

        Writer 24.3K views
        Create a countdown calendar & Insert current time and date

        Create a countdown calendar & Insert current time and date

        02:14

        Create a countdown calendar & Insert current time and date

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

        Spreadsheet 13.4K views
        How to insert and set pictures in WPS Spreadsheet

        How to insert and set pictures in WPS Spreadsheet

        02:19

        How to insert and set pictures in WPS Spreadsheet

        When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....

        Spreadsheet 28.1K views
        How to insert and find bookmarks in WPS Writer

        How to insert and find bookmarks in WPS Writer

        01:13

        How to insert and find bookmarks in WPS Writer

        No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....

        Writer 19.5K views
        How to insert pictures in Document

        How to insert pictures in Document

        02:05

        How to insert pictures in Document

        When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

        Writer 48.5K views
        How to insert and set a text box

        How to insert and set a text box

        01:44

        How to insert and set a text box

        When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....

        Presentation 36.9K views
        Quick to learn the time and dates functions

        Quick to learn the time and dates functions

        11:58

        Quick to learn the time and dates functions

        1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other

        Spreadsheet 16.6K 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 27.5K views
        Prev 1 2 3 ... 58 59 Next
        WPS Office
        Join 600M+ Users Worldwide Free · Powerful · Cross-Platform Office Suite
        Download WPS Office

        Quick Links

        • All Download Pages Choose your platform
        • Version Comparison Compare features
        • System Requirements Check compatibility
        • Installation Help Step-by-step guides

        WPS Office FAQ

        Which WPS Office version should I download?

        Choose the platform that matches the device where you want to install WPS Office.

        Can WPS Office open Microsoft Office files?

        Yes. WPS Office supports common document, spreadsheet, presentation, and PDF workflows.

        Popular Searches

        wps downloadwps for windowswps for macwps linux download

        Why choose WPS Office?

        • Lightweight & Fast
        • Compatible with Microsoft Office
        • Works Offline
        • Cross-Platform
        • Trusted by 600M+ Users
        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

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube