Sunday, October 20, 2013

How to Draw in Excel 2007


1. Open Microsoft Excel 2007.
2. Click on the 'Insert' tab. This is located near the top right-hand corner of the screen.
3. Click on the 'Line' drawing tool. The 'Line' tool is a good place to start, because you can use basic line shapes to draw a plethora of other custom-drawn shapes.
4. Click 'Lock Drawing Mode,' located underneath the main 'Line' heading. This option lets you connect several lines to predetermined nodes.
5. Click on the document where you want the line to start.
6. Drag your cursor across the spreadsheet to form a line and double-click when the line is long enough. Repeat this process as needed, and click on existing lines to create connection nodes. If you want to move a line or a node, click and drag the entire line or one of the circular nodes.
7. Press the 'Esc' key when you are finished connecting lines. This takes you out of the line editing mode.
8. Click on the 'Shapes' tool if you need to make a simple, pre-drawn shape.
9. Select the desired shape from the list of icons. The 'Shapes' tool gives you access to squares, circles, triangles and oblong shapes, each indicated by different icons underneath the 'Shapes' tool heading.
10. Click and drag the selected shape across your spreadsheet.
11. Click on the 'Home' tab when you are finished. This returns you to the main Excel window, letting you type text, adjust fonts and use Excel macros.

Blogger news