In our daily office, Word, Excel and other office software have some use tips. If you usually accumulate more, more practice, you can improve work efficiency.
Today to share some Excel tips, really very good! Hurry up to learn it!
1. The use of conditions to locate the function to check the data differences
The use of Excel's conditions to locate the function, you can locate different data: first press [Ctrl + G], open the location of the conditions of the window,convert scanned pdf to word online free and then select the "line of content difference cells", and then select the different values, then fill in the color, that is, will be displayed.
In this way, the data they need at a glance, very clear! Save time to find data.
2. Form transposition
Sometimes we may need to transpose the form of rows and columns in order to better analyze and present data. In Excel, you can use the "transpose" function to achieve this operation scanned pdf to word converter online.
This operation is also very simple, first copy the entire form, and then select the target cell click "right-click" - "Selective Paste" - "Transpose" on it.
3. Pull down the table always show the title line
Sometimes too much data in the form, so that when you pull down the form can not see the header row. This is troublesome when you are organizing data or need to compare.investintech free online pdf to word converter In fact, we can always show the header row.
First of all, select the table header row - click [View] - click [Freeze Pane] drop-down menu [Freeze First Row] can be. So that no matter how much data you Excel, slide down when you can see the title line, very convenient!
4. Jump to a specified location
In the use of large workbooks, you may encounter the need to quickly jump to a specific location of the situation. Excel provides a "jump to" function that allows you to quickly navigate to the specified cell or named range, so that it is easy to find data in the data-rich Excel table.
Simply press the [Ctrl + G] shortcut key, enter you want to jump to the cell or named region of the reference, Excel will immediately jump the cursor to the specified location.
5. Selected form data area
When you need to operate a large amount of data in the Excel table, are you dragging the mouse one after another to select the box?Excel provides a quick way to select the entire data area.
You can use the shortcut key "Ctrl + A", you can select the table area with one click. Very convenient, no longer need to drag the mouse to select one by one! No need to worry about dragging the mouse, accidentally causing data errors ~