How to make a circular picture annotation in Excel Steps: 1. Click “Insert” and click on “Smartart”. 2. Click on “Picture” and click on “Circular Picture Annotation”. 3. Edit the text and edit the image.
This article introduces how to select data in excel. Steps: 1.open the document 2.choose the title and click filter 3.then you will find the icon 4.click it and you will see the data 5.then you can filter the data
Here are the steps: 1. Click Insert > Table to insert a table at the cursor position and type the text into the table, choose the cells that contain the text you want to change direction, click Layout on the ribbon bar >Text Direction. 2. Click the Text Direction to change the direction of text . 3. Alternatively, you also can Right click
How to make a stacked bar chart in Excel Steps: 1. Select the data area of the table – click Insert – Recommended Chart – Stacked Bar Chart. 2. Double-click on the axis – set the axis format – axis options. Set according to the actual situation. 3. Right click – add a data
This article introduces how to copy comments in excel. Steps: 1.open the document 2.choose the content and select copy 3.then choose paste special to paste in a cell 4.choose comments 5.then you will find it has comments not data 6.you can clear comments by click home-clear-clear comments
This article introduces how to find absolute value in excel. Steps: 1.open the document 2.enter the data -100 3.then enter ABS(number) 4.then you can enter B 5.you can try the formula 6.then you can see an error, it doesn’t suit for letter
How to make a matrix analysis chart in Excel Steps: 1. Select the data area, click “Insert”, click on “Recommended Chart”, and click on “Split Chart”. 2. Double-click “Axis” to set the axis format. The abscissa axis crosses 2.8 and the ordinate axis crosses 2.7. 3. Right click on “Add Data Tab” and set
How to make a nine-square photo in Excel Steps: 1. Open excel, click “Insert” and then “Shape” to insert a square. 2. Click on “Shape Outline” and select “No Outline”. 3. Hold down Ctrl and Shift to copy out a nine-square grid, select all. 4. Right click on “Combine” and right click on “Set
This article introduces how to hide gridlines in excel Steps: 1.open the document 2.click options 3.choose advanced 4.you can cancel ticking show gridlines as follow and click ok 5.and you will find gridlines is hided.
This article introduces how to make flow chart in excel. Steps: 1.open the document 2.find insert and click shapes 3.choose the shape to draw 4.then you can enter the text 5.in the format menu, you can set the color, outlines and effects and so on.