(The units depend on theĬomputer, but inches and centimeters are two common possibilities.) You can click either of these text boxes, and then typeĮxcel gives you one more way to set the size of a picture by hand. You'll see two text boxes, which provide the current height and width of the picture box.

Your worksheet contains several pictures and you want them all to be consistent), head to the ribbon's Picture Tools | Format > Size If you're not too handy with a mouse, or if you just want to size your picture with exact precision (possibly because

Use the circles that appear in each corner to resize the picture bigger or smaller without changing its proportions.

Use the squares that appear in the middle of each side to stretch the picture in one direction (possibly stretching itīeyond all recognition at the same time).

Of these handles to one side to expand or shrink the picture.ĭepending on which handle you drag, the type of resizing Excel performs changes: These handles look like small circles and squares, and they show up at each corner and in the middle of each side. First, click the picture once so that the resizing handles appear. You can nearly as easily change a picture's size. For example, if you press the left arrow key, Excel nudges the picture ever so slightly to the left (one pixel To get really fine-grained control over picture positioning, click the picture to select it, and then use theĪrrow keys. Sometimes you want to move your picture just a small amount so that it lines up perfectly with some other part of your The easiest way to move a picture once you have inserted it is to click anywhere on the picture surface, and then drag it To remove a background image from a worksheet, display the Page Layout tab of the user interface and then, in the Page Even if you change orĭelete the original picture file, it doesn't have any effect on your worksheet. When you insert a picture this way, Excel copies all the picture data into your worksheet. When you insert the picture, Excel places it in a new floating box.

Browse to the picture you want to insert, select it, and then click OK.Įxcel lets you use a wide range of image file formats, including files with the following extensions.

You can change this option to show only the file type that youĪre interested in (bitmap files, JPEG files, GIF files, and so on).

Includes all the types of image files you can use in Excel. One difference is that the 'Files of type' list The Insert Picture dialog box is very similar to the familiar Open dialog box. To insert a picture file that exists on your computer, follow these steps:

Using shapes in excel to show data