Methods/steps
1
Step 1: Right-click on the blank space of the computer desktop, click New, move the mouse to the Excel worksheet, and click the left mouse button, thus creating a new worksheet.
2
Step 2: Move the mouse to the Excel worksheet icon and right-click to display the function buttons such as open, print, cut, copy, rename and delete. Move the mouse and click the corresponding command to perform the corresponding operation on this worksheet.
three
Step 3: Double-click Open or execute the "Open" command to open this worksheet;
four
Step 4: If you are worried that the computer will suddenly lose power during use, you can open the option →→→→→→→→→→→→ Step 2 →→→ Step 3 →→→→→→→ Step 4 →→→→ Step 5 →→→→→→ Step 5 →→→→→→ Step 5 →→→→→→ Step 6.
five
The fifth step, if we modify the original worksheet, but don't want to change the original worksheet, we can use the "save as" command to complete this operation;
six
Step 6: If we want to convert the contents of the worksheet into PDF format, we can do this: Save as → Export to PDF format → OK → Export finished (note: this function is only applicable to the advanced version).
Question 2: How does Microsoft Excel make tables? Those grids are network lines and will not be affected when printing. When you do this, these tables can be resized without being affected. If you don't want to see these grids, just remove the checkmark in front of the network lines in Tools-Options. If you want to make a form, it is much more convenient than word. Just use it more often, the foundation is still very easy to learn.
Question 3: How to mark in EXCEL table? When we need to have special marks in the table, but it can't affect the overall effect, we can choose to insert comments in the text.
Right-click where you want to insert a note, and then select Insert Note.
Enter the content that needs special annotation in the pop-up text box.
When finished, a small red logo will appear in the upper right corner of the text. Only when we move the mouse to the small red logo will our specially marked content appear.
Question 4: How to make a "spreadsheet scheme" for "insertion" in an excel spreadsheet? In fact, forming such a table is very simple and does not require macros. Take the reimbursement form as an example: first, you insert a "spreadsheet scheme"-the reimbursement form. Click the menu Tools-Protection-Unprotect Sheet to help you understand this form.
To put it simply, to make this form, first fill in the name of each item according to the format position and decorate it with a border. During this time, several functions were used. It is worth mentioning that 1, and the term of the bill is MIN() MAX (). These two functions are the minimum function and the maximum function, respectively. The range of cells in brackets is B 13:B23, which is the cell in the date format that needs to be filled in manually. TODAY () function is used for the reimbursement date. This function has no parameters and directly returns the current system time. Needless to say, these two items are just another addition, subtraction and SUM () function.
Finally, some formatting is worth mentioning: 1, select all the cells in the table area-right click-set cell format-lock and hide all the boxes in front of the protection tab, so that cell protection can take effect. Please pay attention to the part of the form that needs to be filled in manually later. Don't check these two items, or you can't fill them in normally after protection. 2. Protect the table by clicking Menu Tools-Protect-Protect Worksheet, so that you can realize the hidden and locked functions you set before. 3. Finally, briefly talk about the display of the table. Click Menu Tools-Options to find the View tab. In the window options, uncheck the boxes in front of "line number and column label" and "grid line" to see if it is similar to the display mode of reimbursement form. Of course, these operations must be done.
Take this opportunity to briefly explain, I hope I can help you.
Question 5: How to make an excelplus spreadsheet? Open the spreadsheet-first set the margins-and a dotted box will appear-you edit in the dotted box-don't go beyond the dotted box-otherwise the excess part can't be printed-the first line is usually the title line-starting from the second or third line-and enter your information, no matter how many columns there are. You must select the table content in the dotted box-after the input is finished (the title line is generally not selected because no border is needed)-click Format in the menu bar-Cell-Border-Outer border-this is to set the border for your input-you can also set the "alignment" mode in the cell dialog box-generally, both horizontal and vertical are set to center or normal.
Note: Almost all the formats to be set for the table are in the Cells dialog box on the Format menu. Open them yourself and practice them to know their purpose.
Question 6: How to make tables with optional contents in excel tables? The data validity penalty allows you to select a sequence from the drop-down box, enter what you want to display in the source, or refer to the location where you want to display the content.
Question 7: I want to make a horizontal Excel table. How? Do you want the form to be horizontal when printing?
Then you set the page setting direction to landscape. In addition, after you set the landscape orientation, pay attention to the content you edit must be within the size, and you can adjust the margins.
Question: How to enter 1- 1 in excel table making? In excel, 1- 1 will be the default date format.
Method: Format the cell as text before input.
Selected data area
Right-click cell format
Number-text
Question: How does Excel make that borderless table? Click the Tools menu, click Options, and then check the gridlines.