1. How to insert pictures into Excel files
We often use Excel to do some statistics and calculations in our daily work. Sometimes we use pictures to make the documents more convincing. Let’s explain how to add pictures in Excel and edit them.
Open the Excel file, click "Insert" on the menu bar, select "Illustrations", and click the "Picture" option.
After selecting the picture you want to insert in the pop-up menu bar, click "Insert" to insert the picture into the file.
Inserted pictures can be edited using "Picture Tools".
Click the left mouse button to select "Picture", and you can make adjustments in the picture tools on the menu bar.
2. Two excel tables match the same data
1. Open an EXCEL table and need to match the corresponding information in another table.
2. Enter "=VL" in the target cell and the vlookup function will automatically be displayed. Double-click the blue function part.
3. Select the cells in the first column that need to match data, just select one, and then enter the comma "," in English.
4. Return to the information table and select all data.
5. What is the information to be returned, so enter the position representing the corresponding information in the formula.
6. Use the bold black cross mark in the lower left corner of the cell to apply it to the entire column.
3. Where is excel’s automatic line wrapping?
You can wrap rows in cell formats in Excel tables.
1. Open the Excel table, select a cell and press CTRL+A to select all.
2. Click "right-click" and select "Format Cells".
3. Select the "Alignment" attribute, select "Text Control", and click "Automatic Wrap" to confirm.
4. Follow the above steps to wrap the line.
4. How to mark the maximum value in EXCEL chart
The steps are as follows:
1. Select a group of data ranges in Excel that you need to find the maximum value;
2. Click "Start" in the menu bar, then click "Conditional Formatting" and then click the "New Rule" button;
3. Select the third item in "Rule Type" "Only format the top or bottom values";
4. Select "Maximum" in the editing rule and change the value to one digit;
5. Click the "Format" button to set the color of the cells you want to fill, or you can use the font color to mark it;
6. After setting, click the ''OK'' button to find the maximum value.
5. How to batch copy and paste in Excel
As one of the Office software components developed by Microsoft, Excel provides users with table editing, data processing and various chart processing functions. This article introduces how to batch copy and paste in Excel. I hope it will be helpful to everyone.
Double-click the desktop Excel shortcut icon to start Excel.
After starting Excel, click Open and then click the document to be edited in the list of recently opened documents to open the document.
The conventional method is to press Ctrl+A to select all, or combine the Ctrl key to select multiple areas or cells, then right-click on the selected area and select Copy (or press Ctrl+C) to copy the selected content to the clipboard for later use.
In a new Sheet or workbook, press Ctrl+V to complete the batch paste.
If you want to copy the entire Shee page while retaining the format, you can right-click the Sheet name and select "Move or Copy" in the pop-up menu.
In the Move or Copy Worksheet dialog box, select the workbook and place it at the location of the corresponding worksheet, check "Create" copy, and click OK to copy the Sheet page content and format to the location of the specified worksheet.
At this point, Excel switches to the copied Sheet page. You can right-click the Sheet page name to rename it.
