Graphics And Drawing

Introduction Microsoft Excel is equipped with drawing features that can be used to embellish a worksheet. If you have used Microsoft Office long enough, you are probably aware of its drawing tools. They allow you to draw lines, other geometric shapes, and various flowcharts, connectors, banners, etc. Practical Learning: Formatting Cells Content Start Microsoft Excel and open the Red Oak High School3 workbook. If necessary, click the ROSH worksheet to select it. Select cells A1:C25 On the Formatting toolbar, click the arrow of the Fill Color button and select Pale Blue Click column A to select it. Press and hold Ctrl, then click column C, and release Ctrl. That selects those two columns Right-click column A and click Column Width… Type 0.50 and click OK Click cell B17 and type Red Oak High Press Enter. In cell B18, type School Press Enter. In cell B19, type Student Grade Press Enter. In cell B20, type Book Press Enter. In cell B21, type Mrs. Arlington Press Enter. In cell B22, type The Student Press Enter. In cell B23, type Administrator Select cell B17:B23 On the Formatting toolbar, click the arrow of the Font Size combo box and select 8 On the same toolbar, click the Center button Click the arrow of the Fill Color button and select Sky Blue Click the arrow of the Font Color button and select White While the cells are still selected, press Ctrl + 1 which is a shortcut for the Format Cells dialog. In the Format Cells dialog, click the Borders property sheet. In the Line Style list, click the last line under None Click the Color combo box and select White. In the Border section, click the top, the left, the right, and the bottom borders Click OK. Select cells B1:B25 On the main menu, click Format -> Cells to access the Format Cells dialog In the Line Style section, click the 5th line on the second column Click the Color combo box and select Teal In the Border section, click the left and the right borders. Click the Patterns property page. From the Cell Shading Color list, click Indigo (7th column, 1st row) Click OK Right-click column B and click Column Width Type 9.50 and press Enter then press Ctrl + Home to see the result Save the workbook

 

The Drawing Toolbar

The drawing in mainly done using the Drawing toolbar. The Drawing toolbar is usually available on the bottom section of Microsoft Excel’s interface. If you don’t see it or to display and hide it anytime, right-click any button on any displayed toolbar. If Drawing has a check mark, this means that the Drawing toolbar is currently displaying on your screen. To hide it, you can click Drawing and the toolbar would disappear. If Drawing doesn’t have a check mark, you can then click it to reveal the Drawing toolbar. You can also get access to any toolbar by using the main menu where you would click View -> Toolbars, then proceed the same way as described above. Another way you can control the toolbars is from the main menu where you would click Tools -> Customize. Although the Drawing toolbar is dockable, which means you can position it on the top, on the left, or on the right sides of your screen, it is better to keep at its default and usual position, which is at the bottom of your screen.

Practical Learning: Displaying the Drawing Toolbar

To display the Drawing toolbar, on the main menu, click View -> Toolbars If the Drawing item has a check mark, then press Esc three times. If it doesn't, then click it

Shapes

A shape is an aesthetic figure you draw on a worksheet. There is no strict rule that defines what a shape looks like.  To draw a shape, click it on the Drawing toolbar, then on the worksheet, click one of the extreme end, drag to the other extreme, when you get a satisfying size and orientation, release the mouse. Once you release the mouse, the object will still be selected with various object handles of various sides and corners of the object. If you position your mouse on different handles or on the object, the mouse pointers will have different shapes.

This shape Allows you to Move the whole object Resize the object vertically Resize the object horizontally Resize the object in up-left down-right orientation Resize the object in down-left up-right orientation Reorient an AutoShape

Some objects don’t display all these mouse pointers and some may display different mouse shapes. If/when one of those unusual pointers comes up, you will be guided on its meaning. Almost any shape you draw has a marking rectangular box around it. This allows you to work on the shape as an object. For example, you can use this box to move the object. You can move any object to a new location on your screen. Sometimes you will want to select more than one object to manipulate the group. To select more than one object, click one of them, press and hold Shift, and click the other object(s). When you have created the group, release Shift. A drawn object can be copied and pasted to another location on the same worksheet or to a different worksheet on the same workbook, in another workbook, or even to another file. To copy an object, click it. Then on the main menu, click Edit -> Copy, and proceed with pasting. You can copy one object or a group of objects. Using the new Clipboard toolbar of Microsoft Office 2000, you can copy up to 12 objects at once, then paste them to their new respective locations. Just keep in mind that these objects will not have explicit names.

 

Microsoft Office WordArt

A Microsoft Office WordArt is a fancy formatted sentence whose features you can use to include a good-looking group of words that you type and embed in your worksheet. To get a WordArt, you can click the Insert WordArt button on the Drawing toolbar. From the WordArt Gallery dialog, select the style you like and click OK. Type the desired sentence; you can also change the font and/or font size before clicking OK. Once the WordArt has been created, you can move and resize it to your satisfaction. Whenever the WordArt is selected, the WordArt toolbar should be on your screen, this toolbar is very useful and you should always have it handy whenever you are working on a WordArt. Even after the WordArt has been created, you can change its wording and style. To control its text, when the WordArt is selected, double-click or right-click it and click Edit Text, rephrase the words and click OK. To change the WordArt style, click the WordArt Gallery button the WordArt toolbar, select a new style and click OK.

Practical Learning: Creating WordArt

On the Drawing toolbar, click the Insert WordArt button Click the WordArt on 5th column, 2nd row Click OK Change the Size combo box to 20 Replace the text with Montgomery School and click OK While the WordArt is selected, resize and move it to occupy the upper section of the screen On the WordArt toolbar, click the Edit Text… button. Click between both words and type County Public so that when you finish, the text will read Montgomery County Public School Click OK On the WordArt toolbar, click the WordArt Gallery button Click the WordArt on 2nd column, 2nd row Click OK Press Ctrl + Z to undo Resize and re-position the title as you see fit but somewhere in the top-left section of the worksheet Save the workbook

Drawing Lines

One of the shapes available to improve your worksheet is the line. You can draw a horizontal, vertical, or diagonal line. When drawing lines, you can control their width, color, and arrow orientation if you decide to be fancy. To draw a line, click it on the Drawing toolbar. Then, on your worksheet, click one of the line’s intended starting points and drag on the other side, when you get the desired length or orientation, release the mouse. To draw a line starting at its center, press and hold Ctrl while you are dragging. To draw a controllable line, for example horizontal or vertical, press and hold Shift while you are dragging. When you have just released the mouse, the drawn line is terminated by small boxes on both sides. Use these object handles to control the line’s size and orientation.

Practical Learning: Drawing and Controlling Lines

On the Drawing toolbar, click the Line button. To draw a horizontal line, press and hold Shift. Click around the left border of cell B5 and hold your mouse down. That marks the starting point of our line. Drag the mouse in the right direction until you get to the right border of cell I5, then release the mouse. You don’t have to be absolutely precise since you can still resize and move the line to meet your satisfaction. While the line is still selected, on the Drawing toolbar, click the arrow of the Line Color button and click More Line Colors… From the Colors dialog, click the Custom property page Change the values of the colors to Red: 204, Green: 102, Blue: 0. Click OK On the Drawing toolbar, click the Line Style button and select the 3rd line from bottom (4 ½ pt)

Microsoft Office Drawing Shapes

The Drawing toolbar is equipped with numerous shapes, some of which you are familiar with, and you will get acquainted with some others. The drawing shapes on the Drawing toolbar are essentially organized in two categories. The most classic ones are readily on the toolbar; these are the Line, the Arrow, the Rectangle, and the Oval. The Line is just used to draw familiar lines. The Arrow is used to draw fancy lines terminated on one side or on both with an arrow or a bullet. The Rectangle is used to draw a rectangle or a square (a four-sided geometric figure whose sides are all equal). To draw a regular rectangle, click the Rectangle button. On the worksheet, click one intended corner of the rectangle and hold your mouse down. Drag to the other end corner of the rectangle and release the mouse. When you get the size you want, release the mouse. If the size and the position are not satisfying, you can resize and move the rectangle to your liking, using the rectangle’s handles. To draw a rectangle starting at its center instead of its corner, press and hold Ctrl while you are dragging. To draw a rectangle starting at the corner of a cell, press and hold Alt while you are dragging. To draw a square, press and hold Shift while you are dragging. To draw a square starting at its center instead of its corner, press and hold Ctrl + Shift while you are dragging. To draw a square starting at the corner of a cell, press and hold Shift + Alt while you are dragging. The Oval is used to draw an ellipse or a circle. Apply the techniques we have reviewed for the rectangle, just keep in mind that this time, the shape is circled. Other drawing shapes are available from the AutoShapes on the Drawing toolbar; these are organized in sub-categories of Lines, Basic Shapes, Block Arrows, etc.

Practical Learning: Drawing Shapes

Click the Student Info sheet to make it active On the Drawing toolbar, click AutoShapes -> Basic Shapes -> Octagon On the worksheet, click on the left side of cell A7 Resize the shape to fit the dark gray area While the shape is still selected, on the Drawing toolbar, click the arrow of the Fill Color button and click Fill Effects… In the Fill Effects dialog box, make sure you are in the Gradient property page. In the Shading Styles section, click From Center In the Variants section, make sure that the first button (1st column, 1st row) is selected Click OK. On the Drawing toolbar, click the arrow of the Line Color button, and click No Line On the Drawing toolbar, click the Rectangle button Click above the letter R of the RED OAK title in the upper section of the worksheet Type RED OAK HIGH SCHOOL  Select the new typed words in the rectangle On the Formatting toolbar, change the Font to Garamond and the Font Size to 20, also click the Bold button Resize the rectangle to display all the typed words Right-click the border of the rectangle and click Format AutoShape From the Format AutoShapes dialog box, click the Font property page, change the Color to White Click the Alignment property page In the Text Alignment section, change the Horizontal and the Vertical combo boxes to Center each Click the Colors And Lines property page In the Fill section, click the Color combo box and select No Fill In the Line section, click the Color combo box and select Light Yellow (3rd column, 5th row) In the Dashed combo box, make sure that the Solid (continuous) line is selected, decrease the line Weight spin button to 0.5 pt Click the Size property page In the Size And Rotate section, set the Height spin button to 0.4” In the Width spin button, type 3.54 and press Tab. Make sure the Rotation spin button is set to 0°. Click OK On the Drawing toolbar, click AutoShapes -> Basic Shapes -> Rounded Rectangle Draw and size a shape that completely covers the former shape, the RED OAK HIGH SCHOOL title While the shape is still selected, on the Drawing toolbar, click the arrow of the Fill Color button and click Fill Effects… In the Fill Effects dialog, click the Texture property page In the Texture list, click Brown Marble (3rd column, 2nd row). Click OK On the Drawing toolbar, click the arrow of the Line Color, and select White On the Drawing toolbar, click the Line Style button, and click 1 pt While the shape is still selected, on the Drawing toolbar, click Draw -> Order -> Send Backward. Now both shapes should be visible While one of the shapes is still selected, press and hold Shift, click the other shape (the rectangle with RED OAK), and release Shift when both shapes have been selected On the Drawing toolbar, click Draw -> Align Or Distribute -> Align Center While the shapes are still selected, move the whole group so that the left border of the brown marble aligns with the left border of column B Click somewhere else to deselect the shapes. Press Ctrl + Home Click the ROSH Cover worksheet to select it Click the lower right border of the triangle to select its shape Press and hold Shift, click RED on the big text, click the wide rectangle at the bottom section of the screen, then release Shift. That selects these three shapes On the main menu, click Edit -> Copy Click the ROSH worksheet to make it active On the main menu, click Edit -> Paste While the shapes are still selected, move them on the top section Click somewhere else to deselect and press Ctrl + Home

ClipArt and Pictures

Microsoft Office ships with a lot of pictures that you can use to enhance your worksheet. You can also include almost any kind of picture from almost any format. The ClipArt Gallery that installs with Microsoft Excel organizes its files in various categories. To access them, on the main menu, you can click Insert -> Picture > ClipArt. Select a category by clicking its button, review the available picture, once you like one, click it, and click Insert from the menu that comes up. You can also access additional pictures from Microsoft web site. Using any commercial graphics software, you can also create your own graphics. You can as well use company or personal pictures. Once you have one of these pictures or images in a suitable electronic format, on the main menu, click Insert -> Picture -> From File… Locate the folder where the picture is located, and select it. Microsoft Excel also allows you to completely change a worksheet’s background with a picture of your choice.

Practical Learning: Including Microsoft Office ClipArt

On the main menu, click Insert -> Picture -> ClipArt… From the Insert ClipArt dialog, click Animals. Click the Lion (1st column, 1st row) and click Insert Clip Close the ClipArt dialog box Using its lower right handle, resize the picture to occupy the Pale Blue section from the left corner of cell B6 to the lower right corner of cell B6 On the main menu, click Format -> Sheet -> Background… From your Exercises folder, click roshbg1 and click OK. On the main menu, click Tools -> Options… Make sure you are in the View property page. In the Window section, uncheck the Gridlines check box. Click OK Save your workbook