By greg harvey . when a clip art image or imported picture is selected, excel 2010 adds the picture tools format tab to the ribbon. use the commands on the picture tools format tab if you need to edit or format clip art or pictures in your worksheets.. Optionally, you can modify this picture if necessary. for more information, see the format pictures section in insert pictures. copy data from another program and paste it as a picture in excel. in another program, such as word, use that program's copy command to copy the data that you want to paste as a picture in excel.. When an inserted picture is selected in the worksheet, excel adds the pictures tools contextual tab to the ribbon with its sole format tab. the format tab is divided into four groups: adjust, picture styles, arrange, and size..
On the drawing tools – format tab, click the shape fill button and then choose picture from the menu. in the insert pictures dialog box, do one of the following: click the browse button next to the from a file field to open the insert picture dialog box, where you can select a picture on your computer to insert.. The picture formatting tools are on the picture tools tab on the ribbon, which appears only when you have clicked on a picture to select it. in that tab, the sizing and cropping tools are all the way at the right end.. To add a style, select the image, then choose a style from the pictures styles gallery under the picture format tab. removing backgrounds from images although microsoft excel is a spreadsheet program, it also offers some photo editing tools, as we've already seen in this lesson..