Excel is used in a wide range of work, and it is not clear to newcomers how to start. Today we are going to learn 12 tips that can reduce many detours for newcomers who are new to Excel and make your operation more efficient.
Tip 1: Ctrl+A to select all of the current data
Scenario: As shown in the figure above, we need to select all the data regions, when the data volume is relatively small, we can use the mouse to select, when the data volume is very large, more than the current page, it is very cumbersome to use the mouse.
Operation: Click anywhere in the data region and press CTRL+A to select all the data in the current contiguous region.
Tip 2: Quickly switch cells to input data in landscape and portrait
Scenario: When we are entering data, we don't need to click on the next cell with the mouse every time, we can quickly jump by pressing the key.
Operation: Enter data, you can press the tab key to switch horizontally, and press the eenter key to switch vertically across rows.
Tip 3: How to quickly adjust the width and height of a cell
Scenario: When we enter data of different length types, we find that the width of the cell does not match the width of the cell, and there is a mismatch, we can adjust the cell adaptation width in batches.
Operation: Click the upper left area to select all cells. Double-click the line between the cells after selecting them to adjust all the cells with content to fit the width and height.
Tip 4: Ctrl+Shift+Down arrow keys to quickly select to jump to the last piece of data
Scenario: When the amount of data is too large, if we want to select the last piece of data down, many people drag down to select it, and here we can directly and quickly select the last piece of data.
Operation: Click the first cell content with the mouse, press the shortcut key combination: Ctrl+Enter + Down arrow key, we can understand the adjustment selection to the last cell. In the same way, we can use a combination of different arrow keys to select the last piece of data in different directions.
Tip 5: Ctrl+Enter enter data in batches for non-contiguous blank cells without overwriting the original data
Scenario: As shown in the figure above, we need to quickly fill in the above information according to the list on the right without overwriting the previous data for non-contiguous blank cells. There are 2 ways here:
Operation: Method 1: Select the department column data, press Ctrl+G to locate the blank cell, enter =A2 in the first blank cell, that is, the previous content cell, press Ctrl+Enter, so that all the blank cells can be filled according to the above data.
Method 2: Select the department column data, press CTRL+G to locate the blank cell, and enter the function in the first blank cell
vlookup(b3,g:h,2,0), press :ctrl+enter after input, so that you can also fill the blank data in batches without overwriting the previous data.
Tip 6: How to quickly filter data
Scenario: Due to the problem of sorting the input data, when we need to view different groups of data through filtering, we usually use the filtering operation, we can click the menu bar: Start - Sort and filter to operate, but every time this operation is turned on and unfiltered, it is more troublesome.
Operation: We can select any position in the data region, press CTRL+SHIFT+L to quickly start the filtering operation, and press the key combination to quickly close the filtering operation. This allows for a quick increase in operational efficiency.
Tip 7: How to force wrap and autowrap when the text content is too long
Scenario: When we see that the address of a person is too long, we can use line breaks to display the data. There are two ways to operate: automatic word wrap and forced line wrap.
Operation: Method 1: Word wrap, we click on the corresponding cell, click Start - Word Wrap, so that the text content will be automatically separated to the next line according to the cell length;
Method 2: Force line wrapping, we click on the back of Wuhan City in cell d4, press alt+enter to quickly achieve line wrapping operation.
Tip 8: How to Quickly Convert Data into Charts
Scenario: As shown in the figure above, we need to display the data score of the person in a chart. Here we can operate through the chart function that comes with Excel.
Operation: After selecting all the data with the mouse, click the menu bar: Insert - Chart - Histogram (you can select it as you need), so that the chart we need will be automatically generated. Click on the chart so that we can do all kinds of things with fonts, colors, etc.
Tip 9: How to copy-paste the same data
Scenario: As shown in the figure, we need to fill in the back of the corresponding personnel according to the bonuses of each department. Since the bonus value is the same, we can do it by copying and pasting.
Operation: Press Ctrl+C, copy the bonus value of 1500, select the blank area of each of our bonuses, and press Ctrl+V to paste all the bonus values into it.
Tip 10: Quickly insert multi-row and multi-column cells
Scenario: As shown in the above figure, when we need to add a new person or add multiple information, we need to insert rows or columns in the original **.
Operation: Click the mouse to select multiple rows at will, click the right button - insert, so that you can insert multiple rows of cells; Select the multi-column data with the mouse and right-click - Insert, so that you can insert multiple columns of cells.
Tip 11: How to hide cell rows and columns quicklyScenario: As shown above, when we need to hide the CD column, you can choose the following two ways to quickly hide the cell row.
Operation: Method 1: Select the two columns of c d that need to be hidden, click the middle column line and drag it to the left, which can quickly hide the data of these two columns;
Method 2: Select the two columns of C d that need to be hidden, and click right-click - Hide to hide the data. Right-click to unhide to display the data.
Tip 12: How to quickly adjust the position of two columns of dataScenario: When we need to put data such as sales in front of the conversion rate, we can do this thing.
Operation: Select the sales column, press the shift key and drag the border line to the front of the conversion rate data column to quickly convert.
Related Articles: What should I do if the computer suddenly loses power and shuts down, **What should I do if it is not saved? One trick to teach you to recover data quickly.
Excel commonly uses 8 conditional statistical functions to solve 80% of daily work, and say goodbye to overtime and tables.
The sum will only be out of the sum function, and the 5 common summation functions in excel are here.