714 results for how to stop rounding in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to convert Excel to PDF02:50
How 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 create a Form in spreadsheet01:26
How 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 apply accounting number format in WPS Spreadsheet00:56
How to apply accounting number format in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....
How to use tabs to align text quickly in WPS Writer01:40
How to use tabs to align text quickly in WPS Writer
The function of Tabs in WPS Writer allows us to adjust the position of the text when typing by setting the horizontal Ruler, in order to align the text and symbols. And, it could be also used in Microsoft Office Word and Openoffice. How can we use the function of Tabs? If the ruler is not displayed in the document, we can click the View tab and check Ruler. The number on the Ruler represents the number of characters, and the page width on the current page is 41 characters width. Take t....
How to insert pictures in Document02: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....
How to use Notes Master in WPS Presentation01:30
How to use Notes Master in WPS Presentation
If slides show everything that a speaker says, the slides are dull and the speech is boring for audiences. Therefore, when making slides, we can present the necessary contents on the slides and put the supplementary contents on the notes page to print them out. In order to unify the style of each notes page, we can use the Notes Master feature. With this feature, we can have a unified format for all notes pages, including new notes pages after setting for it. Click the View tab on the ....
How to delete blank rows of table in batches00:51
How to delete blank rows of table in batches
When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....
How to insert attachments in WPS presentation01:07
How 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....