WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How To Insert Picture In WPS Spreadsheet: A Step-by-Step Guide

October 1, 2023
2.9K Views

Get to know the creative potential of your WPS Spreadsheet! Whether you're a novice navigating the digital terrain or a seasoned user seeking clarity amidst the options labyrinth, inserting pictures into your WPS Spreadsheet can be a puzzle. Don't worry; we're here to help you solve the problem. In this article, we'll unveil the secrets of "How To Insert Picture In WPS Spreadsheet," offering a treasure trove of methods, insights, and tips to elevate your spreadsheet game. Let's put an end to confusion, and let's explore the world of visual data!

4 Easy Ways To Insert Images

How To Insert A Picture From Your Computer?

Step 1: Click Insert.

Step 2: Click the Picture button in the Illustrations group.

Step 3: In the pop-up window, click From File.

Step 4: Browse and select the picture file you want to insert.

Step 5: Click Open.

The picture will be inserted into the slide. You can then resize, crop, or format the picture as needed.

How To Insert From Excel Image Library?

Here are the steps to insert a picture from the Excel image library into a WPS Presentation slide:

Step 1: Select the Insert tab.

Step 2: Click the Picture button in the Illustrations group.

Step 3: In the pop-up window, click From Excel Image Library.

Step 4: Browse the available images and select the one you want to insert. Additionally, you can search for images.

Step 5: Click Insert.

The selected image will be inserted into the slide. You can then resize, crop, or format the picture as desired.

The Excel image library contains a collection of clipart, photos, and illustrations that you can use in WPS Presentation slides and other Office documents. These pre-formatted images can save time compared to searching online or on your computer.

Alternative Method Of Inserting: Copy-Pasting Images

Here are the steps to copy and paste an image in WPS Excel:

Step 1: Insert the image you want to copy into an Excel worksheet. You can insert an image by going to Insert > Picture and selecting the image file.

Step 2: Select the image. A border will appear around the selected image.

Step 3: Go to the Picture Tools Format tab at the top. Click on Copy in the Clipboard group or press Ctrl+C. Clipboard copies the image.

Step 4: Select the cell where you want to paste the image.

Step 5: Go to the Home tab and click Paste in the Clipboard group (or use the keyboard shortcut Ctrl + V).

Step 6: The image will be pasted into the selected cell. You can click and drag the corners to resize it if needed.

Step 7: To copy the image again, simply select the cell with the image and repeat steps 2-5 in any other cell you want to paste.

This way, you can easily copy and paste images in WPS Excel without re-inserting the image file multiple times. The formatting will remain consistent when pasting the copied image.

Advanced Method Of Inserting: Inserting Images Using Formulas

Here are the steps to insert an image using a formula in WPS Spreadsheets:

Step 1: Insert the image you want to use into any cell in the worksheet.

Step 2: Right-click on the image and select 'Copy Picture'.

Step 3: Go to the cell where you want the image formula. Type =IMAGE( and press Enter. It will insert the IMAGE formula.

Step 4: Click inside the formula bracket and press Ctrl + V to paste the copied picture.

Step 5: Press Enter. This will insert the image based on the formula.

Step 6: You can now resize or format the image as needed.

Step 7: To reference this cell containing the image from another cell, use a formula like: =A1

Step 8: This will pull the image directly into the new cell.

The key benefit of using an image formula is linking the image to the worksheet. So, if you update the original image, it will automatically update all cells referencing that formula.

How to Insert Multiple Pictures In WPS?

Here are the steps to insert multiple pictures in the WPS Presentation:

Step 1: Click the Insert tab and then click the Pictures button.

Step 2: Click the Insert Pictures to Multiple Slides option in the popup window.

Step 3: In the Insert Picture window, select the pictures you want to add by pressing the Ctrl key and clicking on multiple files.

Step 4: Once you've selected all the pictures, click Insert.

Step 5: In the popup window, specify the slide range where you want the pictures inserted. For example, entering 1-5 will insert the pictures starting on slide 1 through slide 5.

Step 6: Adjust the number order if needed by using the arrow buttons or entering a custom order.

Step 7: Click OK when done.

The selected pictures will be inserted sequentially across the specified slide range. You can then format and adjust each picture on their respective slides as needed. This provides an easy way to quickly add multiple photos without inserting them individually.

Additional: Editing And Formatting Inserted Pictures

How To Embed Inserted Image In An Excel Cell?

Here are the steps to embed an inserted image in a cell in Excel:

Step 1: Insert the image you want to embed into a cell. You can insert an image by going to Insert > Pictures and selecting the image file.

Step 2: Go to the Picture Tools Format tab with the image selected.

Step 3: Click on Size and select the Crop option.

Step 4: Crop the image as needed so that only the part you want shows.

Step 5: Click OK to apply.

Now, the image is embedded in the cell. When you resize or move the cell, the image remains anchored. You can also add text or data around the embedded image in the cell.

This provides a great way to embed graphics and icons alongside cell data. The image will stay persistent when copying or filling cells as well.

How To Set A Floating Picture In Excel?

Here are the steps to set up a floating picture in Excel:

Step 1: Insert the picture you want to use into the worksheet. Choose the image file from Insert > Pictures.

Step 2: Select the picture. A border will appear around the selected picture.

Step 3: Go to Picture Tools Format > Arrange > Position.

Step 4: Under With Text Wrapping, choose one of the wrap text options like In Front of Text or Behind Text.

Step 5: Adjust the picture position as needed. You can use the arrow keys to nudge the picture or click and drag it to the desired location.

Step 6: Go to Picture Tools Format > Size > Position > More Layout Options to make the picture float over cells.

Step 7: In the Layout dialog box, choose 'Move object with cells' and uncheck 'Move but don't size with cells'.

Step 8: Click OK.

The picture will float over the cells while maintaining its size and aspect ratio when rows/columns are added or deleted.

How To Resize Inserted Images In Excel?

Step 1: Click on the inserted image to select it. A border will appear around the selected image.

Step 2: Move your mouse over one of the sizing handles on the corner or side of the image. Suddenly, the mouse cursor will become a two-headed arrow.

Step 3: Click and drag the sizing handle to resize the image. Dragging a corner handle allows you to maintain the aspect ratio. Dragging a side handle stretches the image.

Step 4: You can also specify exact size measurements. With the image selected, go to the Picture Tools Format tab.

Step 5: Click the Size group and enter values for the height and width. Units can be specified as pixels, inches, cm, etc.

Step 6: You can also click the Crop button to crop the image to remove the outer edges visually.

Step 7: Under Picture Styles, you can click Format Picture to open formatting options for adjusting image layout, alt text, borders, and effects.

Step 8: When done, click outside the image to deselect it. The image will remain at the new size.

Adding Artistic Effects And Borders

Step 1: Insert the image and select it to activate the Picture Tools Format tab.

Step 2: Go to Picture Effect to apply predefined styles like frames, shadows, reflections, etc.

Step 3: To add a border, click Picture Outline and pick a border color and width.

Step 4: For more effects, go to Picture Effects. Options here include:

  • Shadow - Adds shadow effect behind the image.

  • Glow - Adds a glow effect to the image edges.

  • Soft Edges - Blurs the image edges slightly.

  • Bevel - Adds a 3D beveled edge.

Step 6: Adjust effect settings like color, transparency, size, etc., using the sliders.

Step 7: Return to Picture Styles and select Clear Picture to remove effects.

Adjusting Image Brightness, Contrast, And Color

Step 1: Insert and select the image to activate the Picture Tools Format tab.

Step 2: Go to the Adjust group and click Corrections to open formatting options.

Step 3: Drag the Brightness slider left or right to adjust brightness. Dragging the left darkens the image, and dragging the right lightens it.

Step 4: For contrast, drag the Contrast slider left or right. Left reduces contrast, right increases contrast.

Step 5: Click the Color button to open color tone options. Choose a preset color tone or select Grayscale to make the image black and white.

Step 6: You can also sharpen or soften the image using the Sharpness slider. Drag left to soften, right to sharpen.

Step 7: Under Color Saturation, drag left to desaturate and remove color vibrancy. Drag right to increase color intensity.

Step 8: Use the Recolor option to change the image tone to sepia, washout, or other effects.

Step 9: Click Close when done to apply changes. Observe the updated image.

Trustpilot

stars

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis
logo

More Features In WPS Office

WPS Office is a powerful yet lightweight office suite that provides core word processing, spreadsheet, and presentation applications for Windows, Mac, Linux, iOS, and Android devices. Developed by Chinese software developer Kingsoft, WPS Office aims to deliver an efficient and fully featured alternative to Microsoft Office.

Some of the main benefits of using WPS Office include:

Free and No Subscription Needed

WPS Office is completely free to download and use, with no hidden costs or subscription fees required. Unlike some competing office suites, WPS Office does not limit free users to a trial period or restrict advanced features only to paid tiers. You can enjoy full access to its Word, Excel, and PowerPoint functions at no cost for personal or commercial purposes.

Full Microsoft Office Compatibility

A key benefit of WPS Office is its seamless compatibility with Microsoft Office file formats. It allows you to easily open, edit, and save Word, Excel, and PowerPoint documents without formatting or layout issues. WPS Office supports the latest .docx, .xlsx, and .pptx formats, correctly retaining all formulas, images, tables, and other elements. This makes sharing and collaborating on Office files trouble-free.

Lightweight and Fast

WPS Office has a much smaller install size than the Microsoft Office suite. This makes downloading faster and takes up less storage space on your computer or mobile device. It also uses fewer system resources, so WPS Office applications load faster and perform smoothly. The streamlined functionality results in increased productivity.

Robust PDF Tools

WPS Office has a full-featured PDF editor that easily converts Office documents to PDF or turns PDF files into editable formats. You can annotate, highlight, add comments, e-sign, encrypt/decrypt, and perform other PDF tasks. The built-in OCR (optical character recognition) makes scanning paper documents directly into editable formats possible.

Cloud Support

With WPS Office's cloud support, you can access and edit documents stored on cloud drives like OneDrive or Dropbox directly from within the application. The suite facilitates seamless cloud collaboration by allowing you to share cloud-based files and work simultaneously with others. It also auto-saves files to the cloud to prevent data loss.

Templates, Charts, and Media

WPS Office provides thousands of customizable templates for Word documents, Excel spreadsheets, and PowerPoint presentations. Its media library contains clip art, animations, charts, maps, shapes, and other visual elements to enhance your work. For presentations, it offers quick access to slide transitions and animations to create polished and professional slide decks.

Stable, Secure, and Frequently Updated

WPS Office offers reliable stability with low crash rates, securing your data and work. It encrypts files, has file repair tools, and adds watermarks for IP protection. WPS developers frequently add new features and improvements through version updates.

FAQs:

1. Can I Insert Animated GIFs into The WPS Spreadsheet?

To insert a GIF into a spreadsheet, you must use the Insert Picture function in the Illustrations group on the Insert tab. So, animated GIFs are inserted into WPS Presentation slides but not directly into WPS Spreadsheet cells.

2. How Can I Compress Images To Reduce The Spreadsheet File Size?

First, to compress images in a spreadsheet and reduce file size, open the document in the WPS Office. Click on the image to select it, then click the Picture Tools tab and select the Compress Pictures button. In the Compress Pictures dialog box, adjust the compression settings as desired. Click OK to compress the image and reduce the overall spreadsheet file size.

3. Can I Batch Insert Multiple Images At Once?

There are a few easy ways to batch-insert multiple images into an Excel spreadsheet. You can drag and drop selected image files from your file explorer into the sheet to insert them. Another option is to copy multiple images, select the starting cell in Excel, and paste to insert the images into consecutive cells. The Insert Picture dialog box also lets you multi-select and insert several images at once.

4. What Do I Do If My Image Is Distorted In The Spreadsheet?

If an image becomes distorted when inserting it into a spreadsheet, you can fix this by right-clicking on the image and selecting "Size and Properties." Under Properties, make sure "Move but don't size with cells" is selected. This will keep the image from becoming distorted when the cells around it are moved or resized.

Summary

The article provides a step-by-step guide on How To Insert Picture In WPS Spreadsheet documents. It outlines several methods, such as inserting pictures from your computer files, copying and pasting images, using Excel's image library, and inserting images with formulas. The article covers how to embed, resize, and set wrapping for inserted images as well.

The article then demonstrates the robust image editing capabilities available within WPS Spreadsheets, including applying styles, artistic effects, borders, adjusting brightness/contrast, and color tones. It highlights how WPS Office provides a full-featured alternative to Microsoft Office with key benefits like being free to use, compatible with Office formats, having a small install size, integrating PDF editing tools, and supporting cloud storage

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.