0You need to know about these following functions which are based on Microsoft Excel 2010.
1. Speedily Move and Copy Data in Cells:-
If you want to move one column of data in a spreadsheet, the fast way is to choose it and move the pointer to the border, after it turns to a crossed arrow icon, drag to move the column freely. & if you want to copy the data then You can press the Ctrl button before you drag to move; the new column will copy all the selected data.
2. Compose Text with &:-
Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below.
Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.
3. One Click to Get More Status:-
Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value.
But for more status you can move the pointer to the bottom tab and right click to get more status, as shown in the image.
4. Hide Data Thoroughly:-
Almost all users know how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data. The best and easiest way to hide data thoroughly is to use the Format Cells function. Choose the area and go to Home->Font->Open Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all the values in the area will be invisible, and can only be found in the preview area next to the Function button.
1. Speedily Move and Copy Data in Cells:-
If you want to move one column of data in a spreadsheet, the fast way is to choose it and move the pointer to the border, after it turns to a crossed arrow icon, drag to move the column freely. & if you want to copy the data then You can press the Ctrl button before you drag to move; the new column will copy all the selected data.
2. Compose Text with &:-
Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below.
Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.
3. One Click to Get More Status:-
Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value.
But for more status you can move the pointer to the bottom tab and right click to get more status, as shown in the image.
4. Hide Data Thoroughly:-
Almost all users know how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data. The best and easiest way to hide data thoroughly is to use the Format Cells function. Choose the area and go to Home->Font->Open Format Cells->Number Tab->Custom->Type ;;; -> Click OK, then all the values in the area will be invisible, and can only be found in the preview area next to the Function button.
