قالب وردپرس درنا توس
Home / Tips and Tricks / Excel stylesheets: cell styles and smart art, drawing, graphics, image, and diagram tools

Excel stylesheets: cell styles and smart art, drawing, graphics, image, and diagram tools



You may have used Excel for many years without having to deal with styles (or stylesheets), but they can make your work easier and faster, and make it more visually pleasing. In this feature, we'll discuss cell styles and smart art, drawing, graphics, image, and diagram tools. (We're skipping 3D modeling tools for the time being because they have no styles.)

Cell Styles

When you type a sentence in Excel, most of us simply format the sentence using the font, alignment, or number grouping functions additional functions such as colors, frames, alignment, etc. included. Or we click with the right mouse button on the pop-up / context menu and select the functions there.

  02 Sample Text Stylesheet in Excel JD Sartain / IDG Worldwide

You can, however, also select the group named ] Styles > Cell Styles and select Preset styles with custom fonts, colors, and attributes, as well as borders, shades, and paragraph levels such as Heading 1, Heading 2, Titles, and so on. Play around to learn more about your decisions.

The best way to explain how graphic styles work in Excel is to create them easily.

Smart Art Tools & Styles

Smart Art Graphics are the premade business graphics from Excel. An incomplete list of graphics includes:

  • Block Lists
  • Process Arrows and Diagrams
  • Organizational Diagrams
  • Radial Cycles
  • Segmented Pyramids
  • Image Graphics
  • Image Captions
  • … and 200 plus more.

. 1 Open Excel. From the group Insert tab> illustrations click on the symbol Smart Art Graphic (between Shapes and Store on the ribbon menu).

. 2 Browse the list and select a Smart Art graphic for this exercise. We chose Process > Step Down Process and then clicked on OK .

  03 Select a Smart Art Artwork JD Sartain / IDG Worldwide

3. Excel places the graphic in the middle of the page and displays the selection handles / circles. This means that the graphic is active. When a graphic is active, Excel displays a new tab in the Ribbon menu named [something] Tools > Design / Format which determines the "something" the selected graphic, z. Smart Art Tools, Drawin g Diagram tools, graphics tools and image tools. If you deselect the graphic (or click outside), these menu items disappear.

. 4 The menu Smart Art Tools > Design contains the following groups: Create Graphics, Layouts, Change Colors, Smart Art Styles and Reset. Here you can choose a different layout, a different Smart Art style or change colors.

. 5 In the menu Smart Art Tools > Format you can edit the shapes in 2D (for easy editing). change the shape styles; Change the shape, color, contour or effects. Change the WordArt style. change the arrangement or orientation of the graphics; and change the size.

NOTE: Note that the text in a text box may use the pop-up / context menu, the ribbon menu, or the default style menus of the Drawing Tools ] Menus of the menu. The text in an illustration or image (eg, graphic, diagram, drawing, smart art, word art) uses the appropriate tool > Design / Tools > Format ] Menus.

  04 Smart Art Tools Design Format plus Drawing Tool Format JD Sartain / IDG Worldwide

6. Select the graphic for the down-down process.

. 7 On the new Smart Art Tools tab, select Design > Smart Art Styles .

. 8 Select a style from the menu box or click the small expansion arrow (bottom right of the menu box) and select a style from the list of advanced icons.

. 9 Then click the Change Colors button (from the Smart Art group) and choose a group of colors from the color themes in the menu window.

<img src = "https://images.idsg.net/images/article/2018/08/05-select-a-style-and-colors-for-the-smart-art-graphic-100769779- medium.jpg "border =" 0 "alt =" 05 Choose a Style and Colors for the Smart Art Graphic [19659034] JD Sartain / IDG Worldwide

10. If the graphic is still selected, select Smart Art Tools > Format Another menu of formatting and formatting features is displayed: Select shape effects to add shadow, reflection, glow, soft edges, bevel style, or 3D rotation. NOTE: Note that form fill and shape outline change the background color of the graphics box or add a frame around the graphics box, not the graphic in the box, it Unless you select the graphic in the box separately or use Ctrl + left click Ctrl + Select [1 9459024]) to select multiple graphics in the box. For example, you can select both arrows and assign them the same color.

  06 Shadow reflection shaping effects Glow soft edges Chamfer style3d rotation selection JD Sartain / IDG Worldwide

Shadow, Reflection shape effects annealing, soft edges, beveled styles + 3D rotation

drawing tools and styles [19659003]. 1 In the group Insert > Text (on the far right side of the Ribbon menu), select the WordArt button (the right-justified letter "A").

. 2 Select a text design and a text box will open: Your text here . Enter some text (we entered the words Excel Styles).

. 3 Note that the Drawing Tools > format tab is displayed on the new tab. Select WordArt Styles > Text Effects > Transform . When you move the mouse pointer down in the menu list, the selected text changes, allowing you to see and decide the text effect you prefer. Follow Path or Warp

4. Select a shape for the second graphic on this Excel screen Insert > Shapes . Select a gradient Drawing Tools > Format > Shape Fill and a border or outline from Drawing Tools > Format ]> Shape Outline . Insert some WordArt elements in the center of the banner and add a color, gradient, or pattern and outline from the same menu.

Continue reading to learn more about the graphics tools, image tools, and charting tools


Source link