2552 results for how to do subscript in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2552 results for how to do subscript in excel
How to add text superscript and subscript
01:11How to add text superscript and subscript
When editing chemistry and mathematics data, we often use superscript or subscript to represent special symbols. Take this document as an example, m2 represents the square in the unit area. How can we set the number 2 as a superscript? Select the number 2. In the Home tab, click the Superscript button. Or we can use the shortcut key Ctrl+Shift+= to set the number as a superscript.Numbers in some chemical symbols need to be set as subscripts, such as O2, N2. Select the number 2 in O2. I....
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 print the notes in PDF
01:21How to print the notes in PDF
We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....
How to insert calculated fields in PivotTable
01:06How to insert calculated fields in PivotTable
Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....
How to download pictures in batches in WPS Writer
01:04How to download pictures in batches in WPS Writer
When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....
How to insert attachments in WPS presentation
01:07How to insert attachments in WPS presentation
When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....
How to insert envelopes in WPS Writer
02:30How to insert envelopes in WPS Writer
Large enterprises will make envelopes with company addresses printed on them and mail documents to cooperative partners. If you are the HR of an enterprise, do you know how to make and print envelopes in WPS Writer? The steps are as follows:1. Insert envelopes into the word document.2. Click the Insert tab, and click the Envelopes button to pop up a dialog.3. Input the corresponding address in the Delivery address and Return Address text boxes. If we don't require the return lette....
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....