Download WPS Office for your device
Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

Download WPS Office for All Platforms
Find your device and get the right version
- Choose your platform
- Download WPS
- 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
465 results for how to insert date and time in excel
Insert date and time in the header or footer
00:55Insert 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....
Create a countdown calendar & Insert current time and date
02:14Create 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. · ....
How to insert and set pictures in WPS Spreadsheet
02:19How 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....
How to insert and find bookmarks in WPS Writer
01:13How 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....
How to insert pictures in Document
02:05How 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....
How to insert and set a text box
01:44How 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....
Quick to learn the time and dates functions
11:58Quick 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
How to insert shapes in WPS Writer
01:25How 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....