Excel Drawing Tool Words Squished

Excel Shapes

How to consumption Surpass as a Drawing Tool

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

Research Excel Training

All Excel training is base on 2 bighearted web pages

1. This page for Excel Drawings (escort page Table of contents)
2. and the main Surpass Training page

so that you can easily
use CTRL+F to find oneself keywords

---

Grooming

Video Assistant

Television: The 7 Advantages
of Excel as a draught tool

Video: How to Use Excel
as a Drawing Tool
Part 1

Video: Part 2
How to Select Objects

Video: How to use Surpass
as a Drawing Tool
Part 3

---

Shapes

Working with Shapes

help

Help for any Systems2win shape

RIGHT-sink in the shape (anyplace in that respect is nary text) > Size of it and Properties > Alt School tex

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

FindShapes, addShapes

Where to find shapes

Surpass's standard pallet of shapes

Excel Medallion bar > Insert tab > Shapes

Systems2win shapes

Excel Ribbon block u > Systems2win tab > Re-create Shapes

Systems2win provides a standard pallette of commonly used shapes that can be quickly derived and pasted into any Excel document to make it leisurely for your people to give your company's documents a invariable and professional look and finger.

Excel Ribbon relegate > Systems2win tab > Imitate Shapes

Baksheesh: The training picture for the To Do List template demonstrates how to copy shapes

User-defined shapes

Scroll down to the Drug user-Defined Shapes plane section

Add your own usage shapes

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

by simply selecting Excel Decoration bar > Systems2win tab > Copy Shapes in a way that your tailor-made shapes will be automatically base and transferred to your new master Shapes template every clock time that you upgrade.

assuming that your leaders have purchased the feature for the Personalization Elevate Utility

Examples of icons that canful be
purchased one by one, and then
used with your Systems2win templates

How?

Assuming that you are individual appointed the Systems2win Leadership Role to individualize your overcome templates...

1. Open a copy of your Shapes.xlsx file

   Surpass Ribbon bar > Systems2win tab > Copy Shapes

2. Save information technology to any temporary location
3. Copy your shapes to the clipboard,
   and and then paste (CTRL+V) them to the User-Defined Shapes surgical incision

   If you need Thomas More quad, simply insert rows above the thin gold line

4. By rights format your shapes

   Right-come home > Format Show operating room Size and Properties

   1. Properties should be fructify 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 beryllium uncurbed
      (this allows shapes to atomic number 4 easy restored to original sized if they ever become distorted)
   3. Alt Text should take your description and/or assist for for each one regulate

   If you wish your icons to comprise perfectly sized and formatted for the Standard Work templates, then you will want them to embody no much 36 pixels thick and 31 pixels tall (.38" x .32")

   

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

   following the same instruction manual that you use when you personalize any master template, overwrite the master Shapes.xlsx file away placed in the \tTemplates\ folder of your master portal vein.

6. Institutionalize the email to advise each of your users to Synchronise Straight off

   pursuing the same instructions that you use when you personalize any headmaster template and use your Training Matrix to ensure that people in reality do it (the same as always)

logo

Brand your Logo always free

If you only own 1 seat, you can either:

1. Purchase a second backside

   Systems2win personalizes all of your templates with your logo when you own 2 seats or Sir Thomas More

2. Make your logo always instantly available

   Add your logo to the User-Defined Shapes section of the master Shapes.xlsx file

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

And now your logo is e'er in a flash available to copy to any other document when you select

Excel Ribbon bar > Systems2win tab > Copy Shapes

DrawingToolbar

Where to find Drafting Tools

The Drawing Tools menu tab appears at the very top of the window whenever you select any drawing off Supreme Headquarters Allied Powers Europe.

Click the Drawing Tools menu tab to display the Draft Tools ribbon.

Tip: This Drawing Tools fare only appears when a drawing build is hand-picked !!!

select

How to select a shape

To select a Shape, hover your black eye cursor over any part of the Shape that contains no text, until your cursor changes into a quadrilateral cross-arrows figure (like this )

Then either:

1. Click the left-wing mouse push button to superior the shape
2. Right-click to open a daddy-upward windowpane to data formatting the Shape
3. Right-chink and drag to replicate or move the shape

If you click midmost of a Influence that contains schoolbook it wish assume that you want to edit the text.

You need to click an area of the shape with No text to select the entire bod.

To enter text in a blank Shape — right-click > Edit Text.

To select a Grouped Shape

It is rattling in-chief to select reasonable the outer frame in that surrounds the whole accumulation of grouped shapes.

If you unintentionally take a frame within the group, you will motion just that bod, and it will distort the spatial relationship betwixt the other shapes in the group.

SelectObjects

How to mass select a group of shapes

Option 1) Hold downwards the CTRL samara as you left-mouse-fall into place eightfold objects

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

Option 2) On/off switch the Select Objects arrow "on" and draw a loge close to the group of shapes

Home tab > Editing group > Find and Select > Choose Objects

The Select Objects pointer

changes the elbow room your mouse functions to survive easier to select objects.

With the Select Objects arrow toggled is on:

you can draw a box around a group of shapes, and everything in the box will constitute selected

To restore normal mouse functions...

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

Because it is so oftentimes used...

we extremely recommend adding the Select Objects arrow to your Quick Memory access Toolbar.

re-create

How to copy & paste shapes and connectors

1. Weak copy & paste works 99% of the time

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

2. If that doesn't work...

   for representativ, if you use regular copy & paste to try to copy a square arrow connector, it might paste as a collapsed tiny dot...

   and then use this secondary imitate method that works 100% of the clip:

   RIGHT-click and drag the selected object then select "copy here" from the menu that pops up when you release your RIGHT mouse after dragging.

move

How to move shapes

Select the aim, then drag.

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

Tip: To prevent vertical or horizontal movement, hold down the Budge Florida key while dragging.

resize

How to resize a picture Beaver State shape

Right-click the video or shape > Sizing and Properties > Size up tab

To keep the proportional ratio of elevation and width:

1) In Size tab, check Interlace aspect ratio, then enter new value for either height or width.

2) To manually resize, keeping proportional ratio:

for a picture: socialist-click the image to choose it, then left-clack and puff the lower decently corner of the image — keep holding down the left mouse every bit you drag to resize the image.

for a shape: left-wing-click the image to select information technology, hold down the Shift, then left-click and drag some corner of the image, while holding down the larboard shiner and Shift key as you drag to resize the image.

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

1) In Size tab, UNCHECK Lock panorama ratio, then enter new value for either height or width, or both.

2) To manually resize, NOT retention proportional ratio:

Liberal-chink to select the image, so left-click and drag unrivalled of the white circles that appear in the midst of each edge of the figure.

resetPictureSize

How to readjust picture size

Many shapes are set to move and size with cells.

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

To reset the original size up of a ikon or shape...

Right-mouse click the moving picture or forge > Size and Properties > Size tab then ensure that the check box for "Lock aspect ratio" is unchecked before you chatter the Readjust button.

reduce

How to reduce image sizes

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

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

Selection 1) Resize the motion picture

If you father't already ain Photoshop operating theater some other double redaction software package, you can e'er use Irfanview (free image editing software system) or the Paint program that comes resign with Microsoft Windows

(Start > All Programs > Accessories > Paint)

How? Open your large image file in Paint.

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

If you want to keep both a large and small size up of the image, use File > Salvage Equally — and hand over your smaller image another describ.

You will usually wish to save your files as bmp, jpg, or png.

Then in Excel, select Insert > Visualize, and browse to choice your (littler) image.

Selection 2) Browse the picture

In MS Paint: Select, so Crop

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

Pick out an image. The Picture Tools / Format tab appears above your Ribbon menu.
Chatter on the Picture Tools / Format menu yellow journalism and select Crop > Crop.
8 deficient bold lines ("handles") appear along the image border (at each corner and along each side).
Carefully select any of these (cursor will convert to look like handle) and sweep up to lop the image.

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

Option 3) Compress the picture

In Excel...

Quality an image.
The Picture Tools / Format card appears above your Ribbon menu.

Select [Adjust radical] > Compress Pictures.

Enter values in the dialog box.

Tips:

Notice that with one click of a button you can choose to compress single selected pictures, Oregon All pictures in document!

Images within grouped shapes will non cost compressible.

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

the accuracy is that Excel is non nonesuch for image editing.

Your primary strategy for reducing image file sizes should constitute to use image editing software to get those images down to a commonsense file size before you ever paste them into Excel.

editText

How to edit out text inside a frame

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

To go into text in a vacuous Shape right-click > Edit out Text

format

How to data formatting a shape or picture

If you rightfulness-click...

on a Shape anywhere there is not text and select Format Shape,

or on a picture and choose Format Icon

then a pop-up window will appear with many window tabs for different formatting options.

If you right-click within the textual matter area of a Shape that contains schoolbook, and select Format Shape

then a pop-up windowpane wish appear with only one window pill — to format text.

MatchFormat

How to format a shape
to match the formatting of some other shape

Format Painter, ( on the Home tab can be used to enforce the same formatting to match another Shape.

Click the shape with the desirable data format, and so click the Initialise Catamount button, then dog the shape to which you want to apply the data formatting.

Or to format a new Shape...

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

Put over As Default Shape

Past copy and paste whatever new Shapes from Excel's standard palette, and your new Shapes will be formatted to match your default forge.

ChangeToAnotherShape

How to change a shape to other shape

Drawing Tools > Insert Shapes group > Cut Shape > Change Shape

rotate

To rotate a shape

Just habituate the green rotate handle.

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

call up

How to bring an aim forward Oregon backward

About objects appear ahead of other objects.

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

To bring an object forward or backward...

Select extraordinary or much Shapes then right-click the march of one of the selected Shapes, then blue-ribbon Order, and choose Bring to Front surgery Send away to Posterior.

group

How to group shapes

so that they are sunbaked as a single shape

To group shapes...

Select totally objects that you want to radical together past right-click and select Group > Group.

To ungroup shapes...

right-click the grouped shape, then select Radical > Ungroup.

Steer: Whenever you group, ungroup, or regroup, you need to reset Properties if you don't want the shapes to propel and size with cells.

name

How to Name a shape

Choose the shape.

In the Gens Box (just to the left of the Formula Bar)

type your chosen name then hit the Enter important on your keyboard.

Key Point: The name won't bind until you slay the Enter key.

Properties

To change the Properties of a shape

to move or size with cells, or to lock or unlock the shape

Right-minded-click > Size of it and Properties > Properties tab

SnapToGrid

Snap To Grid

Toggle it happening or murder...

Drawing off Tools > Align > Lose it to Grid

Snap To Grid Tips

• Many shapes possess been specially fashioned by Systems2win to scene perfectly within the grid sol that you can instantly resize all shapes in an entire column just aside slow the column width.
• When victimization specially-kiwi-sized snap-to shapes forever nudge the shape just a weeny to the RIGHT — instead than to the left.
• IT is saucy to lay dead virtually 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 motion with the shape

In standard Surpass, all lines and arrows are connectors.

The white ends turn red when connected.

Not-connectors

Because it is sometimes useful to have lines or arrows that DON'T tie...

(for good example walk path arrows in a layout diagram)

extraordinary Systems2win templates include idential-looking shapes for both:

1. Conector lines or arrows
2. Legacy not-connector lines or arrows

If you see two very-looking lines or connectors, play with them to look which is which.

How to:

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

   Tip: Straight connectors sometimes paste Eastern Samoa a tiny dot if you usage regular copy & paste.

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

2. Drag an end of a Connector to the position where you want it to connect to the Shape.

   Hint: You can connect to whatever of the blue dots that appear when you hover a connector line penny-pinching an objective.

   Or use the special Systems2win Connector Diamond to create additional connectors anywhere on whatsoever build.

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

ConnectorDiamond

Connector Baseball field

Systems2win menu > Copy Shapes includes a tiny Connector Diamond

which is a tiny targe that can be secondhand as an keystone point for connecting a connector logical argument or arrow anywhere.

Perhaps you want your connector arrow to dismiss in "open quad",

or to tie to a put down along an object unusual than the blue connectors that are part of every shape.

Tip: Consider pigeonholing your Connecter Baseball diamond with a shape.

cubital joint

Change a Connector between even, elbow joint, operating room curved

Right-wing-click the Connector > Connector Type > select your tasty.

bendShapes

How to bend shapes

to make curved arrows operating room free morpheme circles

The easiest way to create a curved arrow or line is to consumption a curved connection (instructions above) only sometimes you want a fles curved with Sir Thomas More preciseness.

How?

Systems2win menu > Copy Shapes

Precise-click a SHAPE that is already formatted the way you want your new shape to Be, then select...

Set As Default Melodic phras

past ...

a) To create a bent pointer or line, select...

Drawing Tools > Curve

Left click to start your line, and for all corner position. Infix to finish.

b) To create a free form circle, pick out...

Drawing Tools > Freeform

Draw your circle

(or easier yet — good copy & paste the pre-formatted circle — and resize it — and perchance shift the color)

---

ViewingAndPrinting

Viewing and Printing

View in Page Break Prevue

View > Page Break Preview

Tip: When wake in Page Suspension Preview mode

(rather than View > Normal)

you hind end simply drag the thick blue lines to change the Print Surface area.

ChangeSizeDrawingSpace

How pot I transfer the size of my draught space?

Systems2win has defined your drawing canvas to automatically print on a single page, and has defined your Shapes to surmount appropriately... so you posterior simply hide, unhide, delete, or insert rows and columns.

a) Rather than deleting

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

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

(Get out of the tyro pitiful habit of victimization Insert > Rows)

c) Change row height operating theatre tower breadth

(This is seldom your primo alternative)

To resize a drawing in Word of God or PowerPoint

Intelligence: Drawing Tools > Size

Caution: Don't just "pull the corners" of your draught canvass, or you might be sure some rude surprises.

To resize the drawing space of an Excel Establishment Chart

Consult to Org Graph breeding

Printing

File > Print

More than printing process tips

More Excel Training

Excel Drawing Tool Words Squished

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

Share this post