Jump to content

Keyboard drawing


Recommended Posts

Keyboard drawing

Excel's Drawing toolbar offers several tools for adding visual flair to your worksheets, including WordArt objects, AutoShapes objects, lines, arrows, text boxes, and ovals. Here are two keyboard tips that come in handy when you're designing the graphical elements of your worksheet.

If you want the object you're drawing to line up along existing worksheet gridlines, click the drawing object, but before you click in the sheet and start dragging to draw the object, press and hold the [Alt] key. As you move the mouse to draw, you'll notice that the object's edges gravitate toward the nearest gridline. You'll get a perfect fit every time.

You can also customize how Excel creates the drawing object. By default, when you click and drag to draw an object, Excel creates the object by beginning where you clicked and extending it toward the direction in which you move the mouse. If you'd rather Excel draw the object inside out, click the object on the Drawing toolbar, then press and hold the [Ctrl] key before you click and drag.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...