How to Convert Selected Cells into Images via Excel

Except for editing numbers and charts, Excel has many other hidden features. And today we explore the Excel tips on generating images.

 Sometimes we need to save Excel tables as images. Normally we will use the “Print Screen” key to generate a picture. But once the size of table is very big, the screen of your computer cannot show all the information. In addition, it is very troublesome to see several pictures. Thus, in this article we will introduce two Excel tips to convert selected cells for you.

In this Excel files, there are totally 30 students. However, only 25 of them can be seen without scrolling down the page.A Sample of 30 Students

Apparently, using the “Print Screen” cannot save the scores as a whole image. Here are the steps of generating the image.

The First Way: Paste as an Image

  1. Select the area that you want to save as an image.
  2. Press the keyboard shortcut “Ctrl+C”.

You can also right click and choose “Copy”. You will see a dashed box surround the selected area.A Dashed Box Surround the Area

  1. In the “Ribbon”, click the arrow under the button of “Paste”.
  2. In the choices of paste, select “Picture”. Then you will get a picture in the worksheet.Select Paste and Picture

You may notice that the numbers become thicker. And moving your mouse to the area, you will see the shape of the cursor changed. It means that the image has been generated. And you can drag the image to anywhere of the Excel file as you like.Move Your Mouse to the Area

Second Way: Copy as an Image

  1. Select the area that you want to save as an image.
  2. Click the arrow next to “Copy” in the “Ribbon” area.
  3. In the pop-up box, click “Copy as Picture”.Click Copy as Picture
  4. In the pop-up window, keep the default setting. You can also choose your own setting through your need.
  5. Click “OK”.Keep the Default Setting
  6. Press the keyboard shortcut “Ctrl+V”. You can also right click and choose “Paste”. And then a new image will appear.

Save the Image as a File

Through either of the above two ways, you can convert selected cells and get a picture in the worksheet. And the following comes how to save the image as an independent image file.

  1. Click the picture.
  2. Press the keyboard shortcut “Ctrl+C”.
  3. Open the software of “paint” that the computer carries.
  4. Press the keyboard shortcut “Ctrl+V”.Save as a File
  5. Click the button “Save”.
  6. In the pop-up window, choose your specified path. Thus you can always view this image.

Solve Excel File Corruption

The above Excel tips are the steps to convert selected cells to an image. In addition, you will probably meet with some Excel corruption. You can use an Excel recovery tool to recover your files. This tool can be very helpful in handling data disaster.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

 

Comments are closed.