Excel Advanced Editing Tips

Excel Editing tips:

(1) score Input

If you enter "1/5" directly, the system will change it to "January 5", the solution is: first enter "0", then enter a space, and then enter the score "1/5".

(2) sequence "001" Input

If you enter "001" directly, the system will automatically judge 001 to Data 1, the solution is: first enter "'" (Latin single quotes), and then enter "001".

(3) The input of the date

If you want to enter "April 5", enter "4/5" directly, and then hit enter the line. If you want to enter the current date, click the "CTRL +;" Key.

(4) padding stripes

If you want to add beautiful horizontal stripes to your workbook, you can take advantage of the padding in the alignment. First fill in a cell with the symbol "*" or "~", and then click the cell, drag the mouse to the right, select the horizontal several cells, click the Format menu, select the Cells command, in the cell Format menu that pops up, select the Alignment tab, select Fill in the horizontal Align Drop-down list, click OK button.

(5) Enter the same content on multiple worksheets

When you fill in the same data in the same location on several worksheets, you can select a worksheet, hold down the CTRL key, and then click Sheet1, Sheet2 ... in the lower-left corner of the window. To directly select multiple worksheets that need to enter the same content, and then enter the same data on either worksheet, and the data will automatically appear in the other selected worksheets. When you are finished, press the CTRL key on your keyboard again, and then use the left mouse button to click on the selected worksheets to dismiss the worksheets, otherwise the data entered in one form will then appear on the other selected worksheet. (  tutorial)

(6) discontinuous cells fill the same data

Select a cell, hold down the CTRL key, and click the other cells with the mouse to select all the cells. Enter the data in the edit area, and then hold down the CTRL key while tapping the carriage return, which appears in all selected cells.

(7) displays a formula in a cell

if the data in the worksheet is mostly generated by a formula, to quickly know the form of a formula in each cell so that you can edit the changes, do this by right-clicking the Tools menu, choosing Options, and clicking the Options dialog box , click the View tab, and then set the formula item under the window options bar to work, and click OK. At this point each cellThe Division of labor is shown. If you want to restore the results of the formula calculation, you can then set the formula item under the window options bar to fail.

(8) Select text using ctrl+*

If you have many data tables in a worksheet, you can select the entire table by selecting a cell in the table and then pressing the ctrl+* key. Ctrl+* the selected range is: The largest area of data cells that is involved in radiation from the selected cell to the perimeter. This allows us to easily and accurately select data tables, and effectively avoid using the drag mouse method to select a larger range of cells when the screen rolling phenomenon.

(9) quickly clears the contents of a cell

if you want to delete the content in the cell of the content and its formatting and annotations, you cannot simply apply the selected cell, and then press the DELETE key. To completely clear a cell, you can select the cell or range of cells you want to clear, and then click the All command in the clear item on the Edit menu to get the cells back to the way they are.