10 tips for Excel to use in easy to ignore

The most common skill in office skills is Excel. Here are some frequently overlooked Excel tips, do you see any use?

"End+ Arrow" for quick positioning to the top edge of the cell

If the current cell is in the C3 position, press the end key and then press the ↑ key, the current cell jumps to the top C1 cell, and if you press the ↓ key, it jumps to the C5 cell, and the ← key jumps to the left cell, pressing the → Key jumps to the right-hand cell. That is, no matter where the current cell is, pressing the END key and then pressing the arrow key will position the cell on the edge. If there is a blank cell in the middle, it will first be positioned to a blank cell. The effect is that if you have many rows or columns in your worksheet, you can quickly find empty cells or navigate to cells on the edge.

The row and column quick paste

When you press the CTRL key and then select A1, E1, A5, and E5 four cells, copying and pasting will find the copied content connected together. This allows for rapid replication without connecting cells. Of course, if there is a blank cell in the middle, it cannot be selected.

Fill content #与 Fill content @ Cell format type

When you need to enter a lot of the same content in the previous or later sections, you can set the cell type in cell format to fill content #或 # Fill content, where "fill content" is the contents of the same part that is automatically populated, and "#" is the part that is entered manually. Use "#" when entering numbers, and "@" when entering characters.

Chinese and English input auto switch

When you edit a table, you have to type in English in some cells, some cells to enter Chinese, and repeatedly switch input method is inconvenient, you can select the need to enter the Chinese cell range, the implementation of the "Data → validity" command, open the Data Validation dialog box, switch to the "Input mode" tab, press "mode" The Drop-down button on the right, select the open option and make sure to exit. The Chinese input method is automatically turned on when you are elected to enter a cell in Chinese, and the Chinese input method automatically closes when other cells are selected.

Merge text with hyphen "&"

If you want to combine the contents of multiple columns into a column without using a function, you can easily fix it with the hyphen "&". Enter the formula in the last cell you merged: = Cell 1 & cell 2, and you can merge after you enter.

Position in the same cell after pressing the "Ctrl+enter" key combination

Sometimes, in order to test a formula, you need to repeatedly enter multiple test values within a cell. However, once you enter a value and press ENTER to view the results, the active cell is moved to the next cell by default, and it is extremely inconvenient to select the original cell with the mouse or the UP arrow. If you press the "Ctrl+enter" key combination, the active cell is still the current cell.

Automatically open a workbook

Put the shortcuts to the workbooks you want to open automatically in the C:\ProgramFiles\MicrosoftOffice\Office10\XLStart folder, and Excel will automatically open the workbook each time you start.

Enter content in selected cells

If you want to switch to the next line when you have finished typing on one line, it's cumbersome to move around with the mouse and navigate to the cell you want to enter before you start typing. However, we can first select the area to enter, and then press the TAB key to switch, if you want to return to the original cell can use the Shift+tab key.

Print multiple worksheets quickly

When you print multiple worksheets without a single print, you can select the label of the worksheet you want to print, and then click the Print button on the toolbar.

Quickly convert rows and columns with the "transpose" feature that you paste selectively

Sometimes we need to convert the ranks of a table in Word, and then we can copy it and perform "selective pasting → transpose" in Excel to quickly convert, accurate and convenient.