How to Switch From Draw Tool Cursor Excel

Excel Shapes

How to use Surpass As a Drawing Tool

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

Search Excel Training

All Excel training is found along 2 big web pages

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

then that you can well
use CTRL+F to find keywords

---

Preparation

Video Assistance

TV: The 7 Advantages
of Excel Eastern Samoa a drawing tool

Video: How to Use Excel
American Samoa a Drawing Creature
Break 1

Video recording: Part 2
How to Select Objects

Video: How to use Excel
arsenic a Drawing Tool
Part 3

---

Shapes

Working with Shapes

help

Help for any Systems2win physical body

RIGHT-click the shape (anywhere there is nary text) > Sizing and Properties > Alt Text

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

FindShapes, addShapes

Where to find shapes

Excel's definitive palette of shapes

Excel Ribbon blockade > Tuck tab > Shapes

Systems2win shapes

Excel Ribbon block > Systems2win tab > Written matter Shapes

Systems2win provides a standard palette of commonly used shapes that can be quickly copied and glued into any Excel papers to pull round well-fixed for your people to give your ship's company's documents a consistent and line bet and feel.

Excel Ribbon bar > Systems2win tab > Copy Shapes

Tip: The training video recording for the To Fare List templet demonstrates how to copy shapes

Exploiter-defined shapes

Scroll down to the User-Defined Shapes section

Tot up your own made-to-order shapes

Your leaders can minimal brain damage your own shapes to the User-Defined Shapes plane section to make your shapes always available to every phallus of your squad

away simply selecting Stand out Typewriter ribbon legal community > Systems2win tab > Imitate Shapes in a way that your made-to-order shapes will exist automatically ground and transferred to your modern passkey Shapes template every time that you upgrade.

assuming that your leadership have purchased the feature for the Personalization Promote Utility

Examples of icons that lav be
purchased on an individual basi, and then
used with your Systems2win templates

How?

Assuming that you are person allotted the Systems2win Leading Role to personalize your master templates...

1. Hospitable a re-create of your Shapes.xlsx file cabinet

   Excel Ribbon block > Systems2win tab > Copy Shapes

2. Keep open it to any interim location
3. Copy your shapes to the clipboard,
   and then paste (CTRL+V) them to the Exploiter-Defined Shapes section

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

4. Properly format your shapes

   Far-click > Format Picture or Size and Properties

   1. Properties should be set to Move and size with cells
      (this enables your shapes to be hidden and unhidden
      when concealing and unhiding rows and columns)
   2. Size > Lock Aspect Ratio should represent unchecked
      (this allows shapes to be easily restored to original size of it if they ever get on distorted)
   3. Alt Text should contain your description and/or help for each shape

   If you want your icons to be perfectly mouse-sized and formatted for the Casebook Work templates, then you will want them to be no more than 36 pixels wide-eyed and 31 pixels tall (.38" x .32")

   

5. When everything is perfect... overwrite your master Shapes.xlsx file in your superior portal

   following the unvaried instructions that you use when you individualize any master templet, overwrite the master Shapes.xlsx file located in the \tTemplates\ booklet of your master portal.

6. Send the email to apprise apiece of your users to Sync Now

   following the same instructions that you use when you personalize whatever master template and use your Training Matrix to see to it that populate actually screw (the Saame as always)

logotype

Make your Logotype always lendable

If you only possess 1 can, you derriere either:

1. Purchase a second seat

   Systems2win personalizes to each one of your templates with your logo when you own 2 seats or more

2. Make your logo always instantly gettable

   Sum your logo to the User-Defined Shapes section of the dominate Shapes.xlsx file

   which on your one-member-user figurer is located at
   C:\Users\World\Documents\Systems2win\tTemplates

And now your logo is e'er instantly available to copy to any strange text file when you select

Excel Ribbon bar > Systems2win tab > Copy Shapes

DrawingToolbar

Where to find Draft Tools

The Drawing Tools menu tab appears at the very crowning of the window whenever you select any drawing shape.

Click the Drawing Tools menu tablet to display the Drawing Tools decoration.

Tip: This Drawing Tools menu only appears when a drawing shape is selected !!!

select

How to select a shape

To select a Shape, hover your sneak cursor terminated any part of the Chassis that contains no text, until your cursor changes into a quaternary-sided cross-arrows figure (like this )

Past either:

1. Click the left mouse button to select the shape
2. Right-click to naked a pop-up book window to data format the Shape
3. Right-click and drag to re-create or movement the shape

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

You need to chink an area of the shape with no textual matter to select the entire shape.

To move into textbook in a space Shape — right-click > Edit Schoolbook.

To select a Grouped Forge

Information technology is very important to select just the outer border that surrounds the entire assemblage of grouped shapes.

If you accidentally select a shape within the grouping, you will motility equitable that forge, and it will distort the attribute kinship between the else shapes in the group.

SelectObjects

How to masses select a group of shapes

Option 1) Hold down the CTRL key as you leftist-mouse-fall into place multiple objects

the same way that you select multiple objects in all but strange Windows applications

Option 2) Toggle the Choice Objects pointer "on" and draw a box around the grouping of shapes

Home tab > Editing group > Get and Select > Select Objects

The Select Objects pointer

changes the way your creep functions to get to it easier to select objects.

With the Select Objects arrow toggled is on:

you can draw a box approximately a radical of shapes, and everything in the box will be selected

To restore normal mouse functions...

either toggle the Select Objects Arrow OFF, or double-click any open space happening your worksheet.

Because it is so frequently used...

we highly advocate adding the Select Objects arrow to your Quick Access Toolbar.

copy

How to replicate & paste shapes and connectors

1. Regular copy & paste workings 99% of the clock

   Select the objective, then CTRL+C to copy and CTRL+V to paste

2. If that doesn't work...

   for instance, if you use regular copy & paste to try to simulate a square shooter connexion, it might library paste as a collapsed tiny loony toons...

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

   RIGHT-click and drag the hand-picked object then blue-ribbon "copy here" from the menu that pops improving when you unfreeze your Compensate mouse after effortful.

move

How to move over shapes

Select the targe, then drop behind.

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

Point: To prevent vertical or level movement, handgrip down the Shift while dragging.

resize

How to resize a picture or mould

Right-sink in the picture or shape > Size and Properties > Size lozenge

To keep in the proportional ratio of stature and width:

1) In Size tab, check Lock scene ratio, then enter new value for either elevation or width.

2) To manually resize, keeping proportional ratio:

for a picture: left-click the figure of speech to select it, then left-flick and retarding force the depress right corner of the image — keep holding down the leftover mouse as you hale to resize the image.

for a shape: left-click the image to select information technology, hold down the Faulting key, then left-click and drag any corner of the image, while holding down the left mouse and Shift key as you hale to resize the image.

To make the picture or shape wider, thinner, shorter or taller:

1) In Size of it tab, UNCHECK Lock scene ratio, and so enter new value for either height or width, Beaver State both.

2) To manually resize, NOT keeping proportional ratio:

Left field-click to select the image, then left-click and drag one of the white circles that seem midmost of each march of the shape.

resetPictureSize

How to reset picture size

Umteen shapes are lot to move and sizing with cells.

These shapes are hidden when you hide a row surgery column, and re-emerge when the row or column is again unhidden.

To readjust the original sized of a picture or shape...

Ethical-click the picture show Beaver State shape > Size and Properties > Size check and then ensure that the check box for "Ignition lock aspect ratio" is unchecked before you click the Reset button.

reduce

How to reduce figure sizes

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

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

Option 1) Resize the picture

If you don't already personal Photoshop Oregon just about other image redaction software, you can ever use Irfanview (free icon redaction software) or the Rouge program that comes free with Microsoft Windows

(Start > All Programs > Accessories > Rouge)

How? Open your large fancy file in Paint.

Select Home tab > Image group > Resize.
Enter the percent (or pixel values) to which you want to shrink the image.

If you want to keep some a large and small size of the image, use File > Save As — and give your smaller fancy another name.

You will usually privation to save your files every bit bmp, jpg, or png.

And then in Excel, select Insert > Picture, and browse to prize your (smaller) picture.

Choice 2) Trim the word picture

In MS Paint: Choice, past Crop

Although Irfanview Oregon Paint have better cropping fearues, Excel does hold its own Crop feature:

Select an image. The Picture Tools / Format tab appears above your Ribbon menu.
Click on the Picture Tools / Format menu tab and select Crop > Pasture.
8 squab bold lines ("handles") appear along the image border (at each corner and along each side).
Carefully select any of these (cursor volition change to looking at like plow) and drag to crop the image.

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

Option 3) Compress the picture

In Excel...

Select an image.
The Word picture Tools / Format menu appears to a higher place your Ribbon menu.

Blue-ribbon [Adjust grouping] > Compress Pictures.

Enter values in the dialogue box.

Tips:

Notice that with 1 click of a button you can select to compress only selected pictures, or Completely pictures in document!

Images inside grouped shapes will not comprise compressed.

As great As Excel's Crop and Compress features sound...

the trueness is that Excel is not ideal for image editing.

Your primary strategy for reduction figure file sizes should be to use look-alike editing software package to start those images down to a just file sizing before you ever paste them into Excel.

editText

How to edit text within a shape

To edit text that already exists in an Shape only left-click and start typing

To enter school tex in a blank Shape right-click > Edit out Text

format

How to format a shape or see

If you aright-click...

on a Shape anyplace there is not text and select Formatting Mould,

or on a picture and select Arrange Picture

then a pop-up windowpane wish appear with many windowpane tabs for different formatting options.

If you right-click inside the text area of a Configuration that contains text, and select Format Configuration

so a pop-up window will appear with just incomparable windowpane tab — to format text.

MatchFormat

How to format a pattern
to meet the formatting of another shape

Format Painter, ( on the Home tab can be in use to give the same data format to gibe another Shape.

Dog the shape with the desired formatting, then click the Format Felis concolor button, then click the shape to which you want to apply the formatting.

Or to arrange a newborn Shape...

Right-click an alive Shape that has your desired formatting, and select...

Localise Equally Default Shape

Then simulate and paste whatever recently Shapes from Excel's standard pallet, and your new Shapes bequeath atomic number 4 formatted to match your nonremittal shape.

ChangeToAnotherShape

How to change a influence to other shape

Drawing Tools > Insert Shapes aggroup > Edit Shape > Change Forge

rotate

To rotate a shape

Simply use the jet rotate hold.

Crest: You might pauperization to zoom to a higher settlement for the revolve hold to come along.

convey Forward

How to bring an object forward or bashful

Some objects appear in frontal of other objects.

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

To get an object forward or backward...

Prize indefinite or more Shapes past correctly-click the edge of 1 of the selected Shapes, then select Order, and choose Bring to Straw man operating room Send to Back.

group

How to group shapes

so that they are stained as a individual shape

To mathematical group shapes...

Select complete objects that you neediness to group together then right-clack and select Grouping > Chemical group.

To ungroup shapes...

conservative-click the classified shape, then prize Group > Ungroup.

Tip: Whenever you group, ungroup, or regroup, you need to readjust Properties if you don't want the shapes to motion and size with cells.

gens

How to Name a shape

Select the shape.

In the Epithet Box (just to the left-wing of the Formula Browning automatic rifle)

type your elect name then bump off the Enter of import on your keyboard.

Key Point: The name South Korean won't stick until you hit the Recruit key.

Properties

To change the Properties of a shape

to move Oregon sizing with cells, or to lock or unlock the build

Right-click > Size and Properties > Properties tablet

SnapToGrid

Snap To Grid

Toggle IT connected or off...

Drawing Tools > Align > Snap to Grid

Walkover To Grid Tips

• Many shapes have been specially designed past Systems2win to able-bodied perfectly within the grid so that you can immediately resize all shapes in an total newspaper column just by dragging the column width.
• When victimization peculiarly-sized snap-to shapes always nudge the shape just a little to the RIGHT — rather than to the left.
• It is informed to lay out most of your snap to grid shapes first ahead adding connector arrows.

---

Connectors and attachConnectors

Operative with Arrows and Connectors

How to attach connectors to shapes

so that the connectors affect with the shape

In criterial Excel, each lines and arrows are connectors.

The white ends become Red when connected.

Non-connectors

Because it is sometimes utilitarian to have lines Oregon arrows that Preceptor'T connect...

(for example walk course arrows in a layout diagram)

some Systems2win templates let in idential-looking shapes for both:

1. Conector lines operating theatre arrows
2. Legacy non-connector lines or arrows

If you see ii isotropous-superficial lines or connectors, play with them to see which is which.

How to:

1. Copy your chosen connective from the Systems2win palette of shapes.

   Tip: Heterosexual connectors sometimes paste every bit a tiny dot if you use regular copy & paste.

   If this happens, wont our 100% method to simulate.

2. Drag an end of a Connector to the place where you want it to join to the Shape.

   Tip: You rear end connect to any of the sorry dots that appear when you hover a connector line good an object.

   Or use the special Systems2win Connexion Diamond to create additive connectors anywhere on any shape.

3. When the end of the Connector turns red and the Shape lights up for a moment the Connective is now connected to the shape.

ConnectorDiamond

Connector Diamond

Systems2win menu > Copy Shapes includes a tiny Connector Diamond

which is a tiny object that can follow misused as an anchor point for connecting a connective railway line Beaver State pointer anywhere.

Perhaps you wish your connexion arrow to terminate in "open space",

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

Tip: Think grouping your Connector Diamond with a mold.

elbow

Change a Connecter betwixt straight, elbow, operating theater curved

Right-click the Connector > Connection Type > select your choice.

bendShapes

How to Bend shapes

to create curved arrows or free form circles

The easiest way to create a curved arrow operating room line is to use a falciform connecter (instructions above) but sometimes you neediness a shape incurved with much precision.

How?

Systems2win menu > Copy Shapes

Right-click a material body that is already formatted the way you want your new build to atomic number 4, and then select...

Set As Default Line

then ...

a) To create a bent on pointer Oregon line, select...

Drawing Tools > Arc

Left click to start your line, and for apiece corner set down. Enter to finish.

b) To produce a free form rotary, select...

Drawing Tools > Freeform

Draw your circle

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

---

ViewingAndPrinting

Viewing and Printing

View in Sri Frederick Handley Page Break Trailer

View > Paginate Faulting Trailer

Crown: When viewing in Page Good luck Preview manner

(rather than View > Normal)

you can simply drag the thick dirty lines to variety the Print Area.

ChangeSizeDrawingSpace

How can I change the sizing of my drawing distance?

Systems2win has defined your drawing canvas to automatically black and white on a sui generis foliate, and has formed your Shapes to scale appropriately... so you toilet simply hide, unhide, edit, OR insert rows and columns.

a) Quite than deleting

it is usually better to enshroud and unhide rows and columns.

b) To insert rows operating theater columns, habituate Insert Copied Cells

(Come out of the novice spoilt habit of using Enclose > Rows)

c) Convert row altitude or column width

(This is rarely your best option)

To resize a drawing in Word or PowerPoint

Word: Draftsmanship Tools > Size of it

Caution: Don't just "attract the corners" of your drawing canvas, operating room you power be sure few early surprises.

To resize the draught blank of an Excel Organization Graph

Refer to Org Chart training

Printing

Lodge > Print

More printing tips

More than Excel Education

How to Switch From Draw Tool Cursor Excel

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

Share this post