325 results for how to set up an excel spreadsheet for taxes
- All Tutorials
- Video Tutorials
- Quick Tutorials
Set password to protect privacy in WPS spreadsheet02:03
Set password to protect privacy 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. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....
How to change the page orientation00:48
How to change the page orientation
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....
Set the date format cells01:40
Set the date format cells
In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....
How to use Name Manager01:13
How to use Name Manager
We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....
How to set the paper size of the table01:06
How to set the paper size of the table
When printing tables in WPS Spreadsheet, to preview, we need to set the paper size first. So how can we set the paper size?First, click the Page Layout tab above, and then click Size. WPS Spreadsheet has already provided us with a variety of paper sizes. We can click to preview.If we need to adjust more settings for the paper size, we can click More Page Sizes. In the popup Page Setup dialog box, we can set Page Size and Print Quality according to different printers. In general, the hi....
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. ....
Set Allow Users to Edit Ranges in a protected sheet02:04
Set Allow Users to Edit Ranges in a protected sheet
As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....
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....