2797 results for how to assign a macro to a button
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2797 results for how to assign a macro to a button
How to add watermarks to a table
02:19How to add watermarks to a table
Watermarking a document can prevent it from being misused by others; the good news is that watermarks can be added to an excel table.We'll look at two different ways to add watermarks to your table today.The first approach is merely adding a single watermark, which can be utilized for a single-page table.Click Insert, and then click WordArt. Select a style to be inserted, and input the watermark content.The font style can be changed further by clicking Setting in Text Tools. You ca....
How to insert a signature in a PDF file
02:16How to insert a signature in a PDF file
We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....
How to edit a picture in a PDF file
01:54How to edit a picture in a PDF file
When editing a PDF file, do you know what to do if you want to make a secondary modification to the picture on the page?Go to WPS Premium, and you will be able to use the editing feature. Take this document as an example. Click the picture you want to modify, then a small icon will appear in the upper right corner of the picture. Click it to enter the picture editing mode.At this point we use the mouse to drag the picture to move its position. As we move the picture, auxiliary lines wi....
How to group data in a spreadsheet
02:01How to group data in a spreadsheet
When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....
How to insert a watermark in a PDF file
01:47How to insert a watermark in a PDF file
We use powerful PDF in our daily life nearly everyday. We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article.You can use the “insert watermark” feature of WPS Premium. Take this PDF as an example. Click the Insert tab, then click Watermark. WPS Office has provided us with some preset styles. We can click to use them directly. We can also customize the wa....
How to merge multiple worksheets into a worksheet
01:28How to merge multiple worksheets into a worksheet
By the end of the year, the Indonesian branch needs to make statistical analysis on the sales performance of the whole year. Now, we need to merge all the sales records from January to December into a worksheet, making the PivotTable function possible to use. What can we do? Go to the Data tab, click the Merge Sheet drop-down button, and click the merge multiple worksheets into a worksheet option. Click the Add File button in the pop-up dialog box, select the files from January to Dece....
How to add a watermark
02:14How to add a watermark
WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....
How to crop a PDF file
01:41How to crop a PDF file
PDF is a common file format at work, which cannot be easily modified. If we want to delete a part of the page quickly, we can use the Crop function for WPS VIP members. Take this file as an example. We can see the proportion of the text and margins is obviously out of harmony. How can we adjust it? · Step 1You can find crop page in the Edit tab. Also, you can click crop page in the Page tab. When the dotted lines appear around the page, click Auto Cropping, and WPS Office will automati....