Convert Excel table contents directly to pictures

In general, to copy the table contents of Excel into a picture in a Word document, in addition to the use of capture H software H is to press the keyboard on the Printscreen key to crawl, the two methods of the former to use Third-party software to achieve, although the latter is simple, but the capture of the picture will be cut, Scaling, and so on. In fact, in Excel also provides a more convenient way to copy the contents of the table to the image of the method, the operation is very simple, the following people follow me to see.

1. Copy a selection into a picture

The Chinese computer Education newspaper has described the two commands--"Close all" and "Save All"--when you hold down shift in the Word window and click the File menu, which is very useful. When you work in Excel, only the "Close all" command is in the File menu. But when I hold down SHIFT and then click the Edit menu, I find the original copy and Paste commands in the Edit menu changed to copy picture and paste picture respectively. Two commands made me accidentally find this way to copy the contents of a table into a picture in Excel.

First select the range of cells you want to copy into the picture, Shift-Click the Edit menu, select the Copy Picture command, eject the Copy Picture dialog box, press the system defaults (the "H appearance h" and "format" are selected, respectively), and click the OK button. The selected table area is then copied to the picture. If you need to paste it out, just hold down the SHIFT key and click the Edit menu, select the Paste Picture command (or do not press SHIFT, choose Paste from the Edit menu, paste in pictures), and paste it into other software.

2. Selection of photographic operation

In addition to using the above method to copy a range of cells into a picture, in addition to the Excel also provides a very simple scratch tool, this is the "photography" tool. This button can be dragged and dropped onto the toolbar by right-clicking the toolbar and selecting the Custom command. From the custom dialog box that pops up, click the Commands tab, select Tools in the H category h in the left box, locate the photography tool in the command in the right box, and drag and drop it to the toolbar for backup.

Action, first select the range of cells that you want to copy into a picture, click the Photography button in the toolbar, and then a dashed box is selected around the selection, and the mouse pointer changes to a "+" intersection, where you click and the selection is pasted as a picture. A picture copied in this way, if the data in the source data table changes, the corresponding data in the corresponding graph will also change. But after pasting into other software, the data in the corresponding position is fixed and no longer changes.