قالب وردپرس درنا توس
Home / Tips and Tricks / How to create, edit and format images in Excel

How to create, edit and format images in Excel



How do we add geometric shapes to Excel, and can they be customized? Excel provides over 16 dozen geometric shapes that you can dimension and manipulate to your specific needs, plus hundreds of special effects to customize these shapes. Additional shapes are available in the form of icons, images or 3D models, all of which can be dimensioned, manipulated and tailored.

Insert shapes, icons, images and 3D models

1. For shapes, select INSERT> Illustrations> Shapes and select one from the drop-down menu.

2nd For icons, select INSERT> Illustrations> Icons and select one from the large drop-down menu organized by category.

3rd Shapes and icons are also available as pictures online. Select INSERT> Illustrations> Online Images and type Icons or Shapes in the search box, and then press Enter . Find the shape or icon you need, click once to highlight and then click the Insert button.

4th The best forms are under INSERT> Illustrations> 3D models . The dimensioning and manipulation options for the 3D models are amazing! You can change X, Y or Z Rotation, change camera view for X, Y, and Z Position or Look-at-Point; or you can select a three-dimensional view from a list of preset options.

NOTE: When you choose Form, you insert the drawing hair into the spreadsheet as soon as you click on what you want, which then requires you to hold down the left mouse button and drag down and down to "draw" shape. With the others INSERT > Illustrations (Icons, Online Images, 3D Models, etc.), Excel provides a graphical submenu for selecting from the image library. When you click on the image you want, you must click the Insert button to display the image on the spreadsheet.

  01 insert shapes icons pictures or 3d models JD Sartain / IDG Worldwide

Insert shapes, icons, pictures or 3D models

Size illustrations

1. The dimensioning of the illustrations is a well-known process that you probably used in other programs. After inserting a shape, an icon, an image or a 3D model, you notice the four circles (called image "handle") in the four corners, plus the circles located in the middle and bottom and both sides.

2nd Place the cursor on one of the circles (for example, at the bottom right), hold down the left mouse button and drag down and down to enlarge the image. or pull up and left to reduce it. It's just suggestions. You can pull up or down, left or right, based on what is convenient for you and give the desired effect.

NOTE: Use the corner circuits / handles to dimension the image proportionally. Use the middle side, the middle of the bottom, the middle left or the middle of the right circles to distort the image. For example, if you use the upper or lower center circle, the image becomes shorter and wider (or fatter). If you use intermediate circles, the image extends longer and thinner.

  02 Size or distort the images with image handle JD Sartain / IDG Worldwide

02 Size or distort the illustrations with the image handle

Edit the illustrations

1. When you insert a form into an Excel spreadsheet, the MANUFACTURING TOOL tab appears as long as the shape is selected. Select Edit Form (in the first box on the Ribbon menu), and then click Edit Points . Note that Excel adds editing points to the selected image.

2nd Click on the points (one at a time) to change the image and see your results.

3rd You can also edit the icons. Insert one from the library (eg a butterfly). In its present form, all you can do is size it, distort it, or do everything a color, pattern or gradient, with or without a sketch.

4th To edit an icon, select it. Note that a new GRAPHIC TOOLS tab is displayed with a FORMAT tab below the one that displays the Format Ribbon menu. Click the Convert to Shape button. In the pop-up menu that asks: "… Do you want to convert it to a Microsoft Draw object?" Click the Yes button.

5th It seems that nothing has changed, but it did. Hold down the Ctrl key and click on one of the butterfly wings. Note that all parts of the butterfly can be selected individually, modified (as stretched, pressed, rotated, etc.). You can also add different colors, patterns, gradients, lines and special effects to each piece of the butterfly. that is, four wings and its body.

  03 Editing the Illustrations JD Sartain / IDG Worldwide

03 Editing the Illustrations

Custom Formatting / Designing the Illustrations

1. In Excel, the term for custom design is called the attributes of an image formatting. When an image is selected, the FORMAT tab is displayed and displays all formatting options and functions for the current image.

2nd Formatting in Excel includes Color, Artistic Effects, Transparency, Styles, Borders, Seven Picture Effects (with many custom or preset functions in each effect) and image layouts.

3rd You can also make color corrections and remove the background of an image that contains more than just the "floating" object.

4th As previously mentioned, images can be turned, rotated, scaled, distorted, grouped, adjusted, cropped or forwarded or forwarded.

  04 custom formatting of illustrations JD Sartain / IDG Worldwide

04 Custom formatting of illustrations

5. The FORMAT tab contains three different sets of tools: drawing tools, image tools and graphics tools. These sub-tabs (even if they appear above the FORMAT tab) are displayed based on the selected item — Illustrations, Images, or Graphics.

6th

  05 drawing tools image tools graphics tool menus JD Sartain / IDG Worldwide

05 Drawing tools, image tools, graphics tool menus


Source link