2513 results for how to lock formatting in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2513 results for how to lock formatting in excel
How to lock and unlock cells in WPS Spreadsheet
01:35How to lock and unlock cells in WPS Spreadsheet
If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....
How to convert Excel to PDF
02:50How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
How to set the background in WPS Presentation
01:38How to set the background in WPS Presentation
Do you think the slideshow with a blank background is a little boring? If you want to make the slideshow look more beautiful, we can try to use the Background function in WPS Presentation. First, we click the Design tab above and then click the Background drop-down menu. Here, you can choose your favorite gradient fill preset. If we want to make more settings for the background, we can click Background. In the Object Formatting task pane that pops up on the right side of the screen, we....
How to create a Form in spreadsheet
01:26How to create a Form in spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....
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 set the text outline in WPS Presentation
01:49How to set the text outline in WPS Presentation
When creating slides with WPS Presentation, adding outlines to the specific text can beautify the text and make the presentation file look more professional. So, how can we add the text outline? Select the text, click the Text Tools tab, and click the Text Outline drop-down button. Here, we can set the Colors, Weight, Dashes of the Text Outline with just one click. If we want to further set the Text Outline, we can click the More Text Outline button. Then, the Object Formatting task pa....
How to use OCR in PDF
02:12How to use OCR in PDF
Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....
How to group objects in WPS Spreadsheet
01:20How to group objects in WPS Spreadsheet
In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....