Archive May 2019

How to select data in excel

word image 1452 - How to select data in excel

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    

How to Change Text Direction in A Table in Word

doc-change-text-direction-11

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

Read More

How to make a stacked bar chart in Excel

C:\Users\Administrator\Desktop\新建文件夹 (6)\0530\-- (4)\1559201987(1).jpg

  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

Read More

How to copy comments in excel

word image 1379 - How to copy comments in excel

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    

How to find absolute value in excel

word image 1341 - How to find absolute value in excel

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

C:\Users\Administrator\Desktop\新建文件夹 (6)\0530\-- (7)\1559203202(1).jpg

  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

Read More

How to make a nine-square photo in Excel

C:\Users\Administrator\Desktop\新建文件夹 (6)\0530\-- (2)\1559200223(1).jpg

  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

Read More

How to hide gridlines in excel

word image 1396 - How to hide gridlines in excel

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.    

How to make flow chart in excel

word image 1427 - How to make flow chart in excel

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.