stay Excel In the table , We locate objects in a blank worksheet , It will pop up below “ Can't find object ” A hint of .
Or we can click the Insert tab object , It might pop up again “ Cannot insert object ” A hint of .
But what is the object ？ stay Excel in , There are two types of objects ： One is a chart 、 illustrations 、 Controls, etc. Excel Elements in a table that are independent of cells , We call them intratable objects . The other is Excel Out of the form PPT、Word、PDF Wait for the documents , We call them off the table objects . The first object is each Excel People who use . The second object is usually used less , But his role should not be underestimated , Now let's take a look at the operation of these two objects together with Xiaobian ！
01 In table objects
One ： Chart . A chart called an object is a chart that is not in cells , A sparkline is a miniature chart in units of cells , So it can't be called an object .
There are many ways to build a chart ：
1.alt+F1 A shortcut key can be created in the current chart .
2.F11 Shortcut keys can create a chart in a new sheet .
3. Insert tab —— Chart , You can choose the recommended chart or all the charts .
4.Ctrl+Q In the quick analysis tool, you can choose to create charts or mini graphs .
Two ： illustrations .
In the illustration area of the Insert tab （ The red box area below ）, You can insert pictures 、 shape 、smartart Graphics, etc . These are all Excel Objects in the .
Although pictures and screenshots belong to Excel Out of table elements , But in terms of function, it is similar to the elements in the table , So they are also introduced in the table objects .
The shape of the illustration 、 Pictures can be inserted directly as needed , There's no more demonstration here .
and Excel Screen shots in are used less frequently , The following screenshot shows the motion picture ： Select the drop-down option for the screenshot —— Screen editing , You can choose to intercept Excel Areas outside the table , And paste the intercepted results in Excel It's in the form .
And use Excel After many screen shots , Will be saved in the window where the screenshot drop-down option is available , You can choose the right one after many screenshots Excel In the table .
3、 ... and ： Control .
stay Excel Development Tools tab —— Select Insert , In the drop-down menu , You can see the check box 、 Button 、 Scroll bar and other controls , These controls also belong to Excel Objects in the .
If Excel There are no development tool tabs in the table , So open the file —— Options —— Custom ribbon , Check the development tools check box on the right .
Through the insert option in the development tool , After inserting the corresponding control , With the right mouse button —— Format control , So as to realize the dynamic control of the table 、 The effect of making dynamic charts .
02 Off the table objects .
The insertion of out of table objects is on the right side of the Insert tab ,（ In the red box below ）.
What's the use of off table objects inserted from here ？ One side Excel If there is a hyperlink to add Word、pdf Or other documents , It's very likely that you can't open these documents when you send them to others , And after inserting the file through the object here , When you send it to others, you won't be unable to open it Of the link problem . On the other hand , Through this kind of insertion, the object can be in Excel A preview is shown in the table , Double click the preview image to open the file .
The following diagram shows ： Insert —— object —— Created by file —— Choose from the computer PDF file —— Check to show as icon （ You can change the icon style and title in the change icon ）—— determine , An out of table object is inserted , You can color objects through the Format tab 、 Contour light settings . Double click here to open the inserted PDF file .
We can also select the file without checking the check box shown as an icon . For example, insert directly PPT object , Will be in Excel Insert in the table ppt Preview of , Double click the preview image to open it directly PPT file . Even if you delete files from your computer ,Excel Objects in the table can still be opened .
03： Select objects or hide objects .
One ： Select and delete objects .
The objects in the figure below include objects in the table and objects outside the table . Let's press F5 location —— Choose the location condition —— After choosing the object , All objects will be selected , Hold down delete Key to delete all selected objects . Press again F5 Locate the object , It will pop up “ Can't find object ” A hint of .
? Two ： Hide objects .
We choose files in turn —— Options —— senior —— stay “ For the object , Show ” in Check “ There is no content （ Hide objects ）” after —— determine .
Now in the Insert tab , See that the area of the illustration is all gray , Can't operate . Then click the Insert tab object , Plug in the PPT After the document , It will also pop up “ Cannot insert object ” A hint of . So after hiding the object , Both in table and out of table objects cannot be used .
This is it. Excel The object problem in , Do you understand ？