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

To create, edit, and format images in Excel

How do you add geometric shapes in Excel, and how can you customize them? Excel offers more than 16 dozen geometric shapes that you can customize to your specific needs, as well as hundreds of special effects to customize those shapes. Additional shapes are available in the form of icons, images, or 3D models, all of which can be resized, edited, and customized.

Inserting Shapes, Symbols, Images, and 3D Models

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

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

. 3 Shapes and symbols are also available as online images. Select INSERT> Illustrations> Online Images and enter Icons or Shapes in the search box. Then press . Find the desired shape or symbol, click once to highlight it, and then click the Insert button.

. 4 For the best shapes, see INSERT> Illustrations> 3D Models . The size and manipulation options for the 3D models are amazing! You can change the X, Y, or Z rotation, change the camera view for the X, Y, and Z positions or the viewpoint. You can also select a three-dimensional view from a list of preset options.

NOTE: When you select shapes, Excel inserts the crosshair into your spreadsheet as soon as you click on the desired item, then you must hold down the left mouse button and drag down to select the shape. " to draw". In the other illustrations INSERT > (symbols, online images, 3D models, etc.), Excel provides a graphical submenu from which you can select from the image library. After clicking on the image you want, you must click on the Insert button to have the image appear in the spreadsheet.

  01 Inserting Shape Symbols, Images, or 3D Models JD Sartain / IDG Worldwide

Inserting shapes, symbols, images, or 3D models

Resizing images

1. Resizing the illustrations is a familiar process that you have probably used in other programs. After inserting a shape, symbol, image, or 3D model, note the four circles (called image handles) in the four corners, and the top and bottom circles in the middle and both sides.

. 2 Place the cursor on one of the circles (for example, bottom right), hold down the left mouse button, and drag the image down to make it larger. or drag up and to the left to decrease it. These are just suggestions. You can drag up or down, left or right, depending on what is comfortable for you and produces the desired effect.

NOTE: Use the corner circles / points to scale the image proportionally. Use the middle upper, middle lower, middle left or middle right circle to distort the image. For example, if you use the upper or lower middle circle, the image will be shorter and wider (or fatter). If you use the circles on the middle side, the image gets longer and thinner.

  02 Using image handles JD Sartain / IDG Worldwide

02 Resizing or distorting images

Editing illustrations

1. When you insert a shape into an Excel spreadsheet, the DRAWING TIMES tab appears as long as the shape is selected. Select Edit Shape (in the first box of the Ribbon), and then click Edit Points . Note that Excel adds edit points to the selected image.

. 2 Click the dots (individually) to change the image and see your results.

. 3 You can also edit the symbols. Insert one from the library (eg a butterfly). In its present form, all you can do is size, distortion, or a color, pattern, or gradient, with or without outline.

. 4 To edit an icon, select it. Notice that a new GRAPHICS TOOLS tab is displayed. Below that is a FORMAT tab that displays the Format Bar menu. Click Convert to Form . In the pop-up menu you will be asked: ". , , Do you want to convert it to a Microsoft drawing object? Click the Yes button.

. 5 Apparently nothing has changed, but it has changed. Hold down the Ctrl key and click on a butterfly's wing. Note that all parts of the butterfly can be individually selected and modified (eg stretched, compressed, rotated, etc.). You can also add different colors, patterns, gradients, lines, and special effects to each piece of the butterfly. These are four wings and their bodies.

  03 Editing Illustrations JD Sartain / IDG Worldwide

03 Editing Illustrations

Custom Formatting / Designing Illustrations

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

. 2 Formatting in Excel includes color, artistic effects, transparency, styles, borders, seven image effects (with many custom or preset features in each effect), and image layouts.

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

. 4 As mentioned above, images may be mirrored, rotated, scaled, distorted, grouped, aligned, cropped, or forwarded or backwarded.

  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 displayed above the FORMAT tab) are displayed based on the selected object (images, images, or graphics).

. 6 Load some pictures and experiment with the formatting options until you are familiar with the different menus.

  05 Drawing Tools Image Tools Graphics Tools Menus JD Sartain / IDG Worldwide

05 Drawing Tools, Image Tools, Graphics Tools Menus

Source link