Does Excel Have a Drawing Tool

Excel Shapes

How to use Excel as a Drawing Tool

for pop, sizzle, and clearer communication with pictures and images

Hunt Excel Training

All Surpass training is found on 2 big web pages

1. This page for Excel Drawings (see page Contents)
2. and the main Stand out Training foliate

so that you privy easily
habit CTRL+F to find keywords

---

Training

Video Help

Video: The 7 Advantages
of Excel as a drawing instrument

Television: How to Use Excel
as a Drawing Tool
Persona 1

Video: Part 2
How to Select Objects

Video: How to use Excel
as a Drawing off Tool
Part 3

---

Shapes

On the job with Shapes

help

Assist for any Systems2win shape

RIGHT-click the contour (anyplace there is no text) > Size and Properties > Alt Text

There in the Alt Text, you will find an explanation of what each shape is used for.

FindShapes, addShapes

Where to find shapes

Excel's criterial palette of shapes

Surpass Ribbon bar > Slip in tab > Shapes

Systems2win shapes

Excel Ribbon bar > Systems2win tab > Copy Shapes

Systems2win provides a standard pallette of commonly used shapes that can be quickly copied and pasted into any Excel written document to make it prosperous for your mass to give your company's documents a consistent and occupational group look and feel.

Excel Ribbon block u > Systems2win tab > Imitate Shapes

Tip: The training video for the To Do List guide demonstrates how to copy shapes

User-defined shapes

Whorl downhearted to the User-Defined Shapes section

Minimal brain damage your own custom shapes

Your leaders potty add your own shapes to the User-Defined Shapes section to make your shapes always available to every member of your team

by simply selecting Excel Ribbon bar > Systems2win yellow journalism > Copy Shapes in a direction that your usance shapes will be automatically constitute and transferred to your new master Shapes template every time that you upgrade.

assuming that your leaders accept purchased the feature for the Personalization Acclivity Utility

Examples of icons that stool be
purchased separately, then
used with your Systems2win templates

How?

Assuming that you are person appointed the Systems2win Leaders Role to personalize your master templates...

1. Open a copy of your Shapes.xlsx file away

   Excel Medallion bar > Systems2win tab > Written matter Shapes

2. Redeem it to any impermanent location
3. Copy your shapes to the clipboard,
   then paste (CTRL+V) them to the User-Defined Shapes section

   If you need more space, simply insert rows above the thin gold line

4. Properly format your shapes

   Right-click > Format Picture or Size and Properties

   1. Properties should represent set to Move and size with cells
      (this enables your shapes to be hidden and unhidden
      when hiding and unhiding rows and columns)
   2. Size > Lock Aspect Ratio should be unrestrained
      (this allows shapes to be easily restored to avant-garde size if they ever become crooked)
   3. Alt Schoolbook should contain your description and/or help for each shape

   If you want your icons to be perfectly size and formatted for the Standard Operate templates, past you leave want them to be no much 36 pixels extensive and 31 pixels tall (.38" x .32")

   

5. When everything is pluperfect... overwrite your master Shapes.xlsx file away in your master portal

   following the same instruction manual that you use when you personalize any headmaster template, overwrite the captain Shapes.xlsx file located in the \tTemplates\ leaflet of your master portal.

6. Send the email to advise each of your users to Sync Now

   following the same instructions that you use when you personalize any sea captain template and use your Training Ground substance to ensure that people actually do it (the same as always)

logo

Make your Logotype forever available

If you only own 1 seat, you stern either:

1. Purchase a second seat

   Systems2win personalizes apiece of your templates with your logotype when you possess 2 seats or more

2. Score your logo always immediately available

   Add your logo to the Exploiter-Defined Shapes section of the sea captain Shapes.xlsx file away

   which connected your one-user estimator is located at
   C:\Users\In the public eye\Documents\Systems2win\tTemplates

And now your logo is always instantly available to copy to whatever other document when you select

Surpass Ribbon bar > Systems2win tab > Copy Shapes

DrawingToolbar

Where to find Drawing Tools

The Drawing Tools bill of fare tab appears at the really summit of the window whenever you select some drawing shape.

Click the Drawing Tools fare tab to display the Lottery Tools palm.

Tip: This Drawing Tools menu only appears when a draught shape is designated !!!

select

How to prize a shape

To select a Shape, vibrate your mouse cursor over any part of the Shape that contains no text, until your pointer changes into a four-sided bad-tempered-arrows figure (like this )

Then either:

1. Click the left mouse release to select the shape
2. Right-click to open a pop fly window to format the Shape
3. Satisfactory-click and retarding force to copy or go the shape

If you dawn in the middle of a Shape that contains text it leave assume that you want to edit the text.

You need to click an area of the shape with no text to select the entire influence.

To enter text in a blank Physique — satisfactory-penetrate > Edit Text.

To select a Grouped Shape

IT is very important to select vindicatory the outer border that surrounds the entire solicitation of grouped shapes.

If you accidentally select a shape within the group, you will move just that shape, and it will distort the spatial relationship between the other shapes in the group.

SelectObjects

How to mass select a group of shapes

Option 1) Hold down the CTRL key Eastern Samoa you left-mouse-clack multiple objects

the same way that you select multiple objects in most other Windows applications

Option 2) On-off switch the Choice Objects pointer "on" and line a box some the aggroup of shapes

Habitation tab > Editing group > Find and Blue-ribbon > Take Objects

The Select Objects arrow

changes the way your shiner functions to go far easier to select objects.

With the Select Objects pointer toggled is connected:

you can suck in a box roughly a group of shapes, and everything in the box will be selected

To mend normal mouse functions...

either toggle switch the Select Objects Arrow OFF, or double-dog some open space on your worksheet.

Because it is so frequently used...

we highly advocate adding the Choice Objects arrow to your Prompt Access Toolbar.

copy

How to copy & paste shapes and connectors

1. Regular written matter & paste works 99% of the time

   Select the object, then CTRL+C to imitate and CTRL+V to paste

2. If that doesn't employment...

   for example, if you use steady copy & paste to test to copy a conventional arrow connector, it might paste atomic number 3 a collapsed tiny dot...

   then use this alternate copy method that works 100% of the clock time:

   Suited-get through and drag the selected object then select "written matter here" from the menu that pops up when you loss your RIGHT shiner after effortful.

move

How to move shapes

Select the object, and then drag.

Or use the arrow keys on your keyboard to "jog" selected objects.

Tip: To prevent vertical or horizontal movement, hold down the Shift key patc dragging.

resize

How to resize a painting or shape

Right-click the picture or Supreme Headquarters Allied Powers Europe > Size and Properties > Size tablet

To keep the graduated ratio of height and breadth:

1) In Size tab key, jibe Lock scene ratio, then inscribe new value for either to or width.

2) To manually resize, guardianship proportionate ratio:

for a scene: left-click the image to select IT, then left-click and scuff the lower right turning point of the image — keep back holding down the left mouse A you drag to resize the image.

for a shape: left-suction stop the image to select it, hold low the Shift, then left-click and drag any corner of the image, patc holding down the left mouse and Shift key every bit you drag to resize the image.

To clear the picture or shape wider, dilutant, shorter or taller:

1) In Sized tab, UNCHECK Lock aspect ratio, and then enter recent value for either height or width, or some.

2) To manually resize, NOT keeping proportional ratio:

Port-click to select the image, and then left-cluck and drag unmatched of the white circles that appear in the mid of each margin of the configuration.

resetPictureSize

How to reset characterization size

Many shapes are set to move and size with cells.

These shapes are hidden when you hide a row or chromatography column, and reappear when the rowing or pillar is again unhidden.

To reset the original size of a picture or shape...

Right-click the depict operating theatre shape > Size and Properties > Sizing tab and so ensure that the see to it box seat for "Put away aspect ratio" is unchecked before you click the Readjust button.

boil down

How to reduce trope sizes

To reduce the total megabytes size of your Excel file, you will want to reduce the sized of large images that you paste into Excel.

This is especially useful for the Work Instructions and A3 Report card templates.

Option 1) Resize the picture

If you don't already own Photoshop or some other image editing software, you can always use Irfanview (free image editing software) or the Paint course of study that comes disentangled with Microsoft Windows

(Start > All Programs > Accessories > Paint)

How? Open your large image file in Paint.

Select Home tablet > Image group > Resize.
Put down the percent (or pel values) to which you want to shrink the image.

If you require to keep both a large and small size of the image, use File > Save As — and give your smaller pictur other name.

You will commonly want to save your files as bmp, jpg, operating theater png.

So in Excel, select Insert > Ikon, and browsing to select your (small) image.

Option 2) Crop the picture

In SM Rouge: Select, past Crop

Although Irfanview or Paint have better cropping fearues, Excel does have its possess Crop feature:

Select an image. The Picture Tools / Format tab appears in a higher place your Ribbon menu.
Click on the Show Tools / Format carte tab and superior Crop > Crop.
8 unawares bold lines ("handles") appear on the image delimitation (at each corner and on each incline).
Carefully select any of these (cursor will change to see like handle) and drag to crop the image.

At this point you also may want to compress the image to subjugate file size.

Option 3) Compress the characterization

In Excel...

Quality an image.
The Picture Tools / Arrange fare appears supra your Ribbon menu.

Select [Adjust group] > Compress Pictures.

Enter values in the dialog box.

Tips:

Notice that with one come home of a release you give the axe choose to compress merely selected pictures, Oregon All pictures in document!

Images within grouped shapes will not be closed.

As eager as Excel's Browse and Compress features sound...

the truth is that Excel is not ideal for image redaction.

Your primary strategy for reduction image file out sizes should be to use image editing software package to get those images fine-tune to a levelheaded filing cabinet size before you e'er paste them into Excel.

editText

How to edit out text within a chassis

To edit school tex that already exists in an Shape simply left-click and get typing

To enter text in a incommunicative Shape right-click > Edit Textual matter

format

How to data format a determine OR picture

If you right-click...

on a Contour anywhere there is not text and prize Format Shape,

or along a picture and select Format Scene

and then a bulge out-up window will appear with many window tabs for antithetic formatting options.

If you right-click within the text area of a Work that contains text, and select Format Shape

then a pop-up book windowpane will appear with lonesome one window tab — to format text.

MatchFormat

How to initialize a shape
to match the data formatting of some other shape

Arrange Puma, ( on the Home tablet prat be used to apply the same formatting to play off another Cast.

Click the build with the desired formatting, then click the Initialize Painter button, then click the shape to which you want to hold the formatting.

Or to format a refreshing Shape...

Rightmost-click an existing Shape that has your desired formatting, and select...

Set Atomic number 3 Nonremittal Anatomy

Then simulate and paste whatever new Shapes from Stand out's definitive pallet, and your new Shapes testament be formatted to match your default option shape.

ChangeToAnotherShape

How to change a shape to some other shape

Drawing off Tools > Insert Shapes group > Edit Shape > Change Shape

rotate

To rotate a shape

Simply use the green rotate handle.

Tip: You might need to zoom to a high resolution for the rotate handle to appear.

bring Forward

How to bring an object frontwards or backward

Roughly objects appear in front of other objects.

For instance, a shape might be in front of a line, or a line might be in front of a shape.

To bring an object forward operating room self-referent...

Choose unmatched or Sir Thomas More Shapes then right-click the edge in of one of the selected Shapes, then select Order, and choose Bring to Frontmost operating theatre Send to Back.

group

How to grouping shapes

and so that they are treated as a single shape

To group shapes...

Select all objects that you want to group together and so right-click and select Group > Radical.

To ungroup shapes...

flop-click the grouped condition, then select Group > Ungroup.

Bung: Whenever you group, ungroup, Oregon regroup, you need to reset Properties if you don't want the shapes to move and size with cells.

name

How to Name a shape

Select the forge.

In the Constitute Corner (just to the left of the Formula Bar)

type your chosen name past hit the Enter key on your keyboard.

Key Point: The key out won't stick until you hit the Move into key.

Properties

To change the Properties of a pattern

to move surgery size with cells, or to operate or unlock the shape

Right-clack > Sizing and Properties > Properties tab

SnapToGrid

Pushover To Grid

Toggle IT on or off...

Drawing Tools > Align > Snap to Grid

Snap To Grid Tips

• Many shapes have been particularly designed by Systems2win to fit perfectly within the grid so that you fire instantly resize all shapes in an entire column honourable by dragging the column width.
• When using specially-sized snap-to shapes always nudge the shape just a little to the RIGHT — rather than to the left.
• It is knowing array most of your snap to grid shapes first before adding connector arrows.

---

Connectors and attachConnectors

Working with Arrows and Connectors

How to attach connectors to shapes

so that the connectors move with the figure

In criterial Surpass, all lines and arrows are connectors.

The Patrick Victor Martindale White ends play red when related to.

Not-connectors

Because it is sometimes effectual to possess lines or arrows that DON'T connect...

(for illustration walk path arrows in a layout diagram)

some Systems2win templates include idential-sounding shapes for both:

1. Conector lines or arrows
2. Legacy non-connective lines or arrows

If you see two identical-looking lines operating theater connectors, play with them to see which is which.

How to:

1. Copy your chosen connector from the Systems2win pallette of shapes.

   Tap: Straightforward connectors sometimes paste as a midget battery-acid if you utilisation regular copy &ere; paste.

   If this happens, use our 100% method to copy.

2. Drag an end of a Connector to the put off where you want it to unite to the Shape.

   Tip: You toilet connect to any of the blue dots that appear when you hover a connector line left an physical object.

   Or use the special Systems2win Connecter Diamond to produce additional connectors anywhere on any shape.

3. When the end of the Connector turns bolshie and the Mold lights raised for a second the Connector is now connected to the shape.

ConnectorDiamond

Connector Diamond

Systems2win menu > Copy Shapes includes a tiny Connector Diamond

which is a tiny object that pot cost victimised as an anchor point for copulative a connector line or arrow anywhere.

Maybe you want your connector arrow to terminate in "undecided blank",

or to connect to a place on an objective other than the blue connectors that are part of every shape.

Tiptoe: Consider grouping your Connexion Diamond with a shape.

articulatio cubiti

Modification a Connector between straight, elbow, surgery curved

Decent-click the Connector > Connector Type > pick out your choice.

bendShapes

How to bend shapes

to create arched arrows or free form circles

The easiest way to create a curvy pointer surgery phone line is to use a curved connector (instructions above) but sometimes you deficiency a shape curved with more precision.

How?

Systems2win carte > Copy Shapes

Right-click a shape that is already formatted the way you want your new soma to be, so pick out...

Set As Default Telephone line

then ...

a) To create a knack arrow or furrow, select...

Lottery Tools > Curve

Left click to bulge your note, and for all corner put off. Go into to finish.

b) To create a complimentary form circle, select...

Drawing Tools > Freeform

Draw your circle

(or easier yet — just copy & paste the pre-formatted circle — and resize it — and maybe change the vividness)

---

ViewingAndPrinting

Viewing and Printing

View in Page Break Prevue

View > Thomas Nelson Page Dampen Preview

Tip: When viewing in Varlet Break Trailer mode

(preferably than Purview > Standard)

you can simply drag the thick blue lines to change the Print Area.

ChangeSizeDrawingSpace

How terminate I change the sizing of my draft space?

Systems2win has defined your drawing canvas to automatically impress on a single page, and has defined your Shapes to graduated table appropriately... thus you can simply hide, unhide, delete, or insert rows and columns.

a) Rather than deleting

it is unremarkably improve to hide and unhide rows and columns.

b) To insert rows or columns, exercise Insert Copied Cells

(Get out of the initiate bad habit of using Insert > Rows)

c) Change course height or column width

(This is rarely your best option)

To resize a drafting in Word operating room PowerPoint

Word: Drawing Tools > Size of it

Caution: Don't fitting "pull the corners" of your drawing sail, or you might be in for some impolite surprises.

To resize the drawing space of an Excel Organization Graph

Refer to Org Chart breeding

Printing

File > Print

More than printing tips

More Excel Training

Does Excel Have a Drawing Tool

Source: https://www.systems2win.com/c/MSdraw.htm