Insert and format autoshapes
Insert an autoshape
To add an autoshape in the Spreadsheet Editor,
- switch to the Insert tab of the top toolbar,
- click the Shape icon on the top toolbar,
- select one of the available autoshape groups from the Shape Gallery: Recently Used, Basic Shapes, Figured Arrows, Math, Charts, Stars & Ribbons, Callouts, Buttons, Rectangles, Lines,
- click the necessary autoshape within the selected group,
- place the mouse cursor where the shape sholud be added,
- once the autoshape is added, you can change its size and position as well as its settings. You can save the autoshape as picture on your hard drive using the Save as picture option in the right-click menu.
Copy autoshape style formatting
To copy a certain autoshape style formatting,
- select the autoshape whose formatting you need to copy with the mouse or using the keyboard,
- click the Copy style icon on the Home tab of the top toolbar (the mouse pointer will look like this ),
- select the required autoshape to apply the same formatting.
Adjust the autoshape settings
- Cut, Copy, Paste - standard options which are used to cut or copy the selected text/object and paste the previously cut/copied text passage or object to the current cursor position.
- Arrange is used to bring the selected autoshape to foreground, send it to background, move forward or backward as well as group or ungroup shapes to perform operations with several of them at once. To learn more on how to arrange objects, please refer to this page.
- Align is used to align the shape to the left, in the center, to the right, at the top, in the middle, at the bottom. To learn more on how to align objects, please refer to this page.
- Rotate is used to rotate the shape by 90 degrees clockwise or counterclockwise as well as to flip the shape horizontally or vertically.
- Assign Macro is used to provide a quick and easy access to a macro within a spreadsheet by assigning a macro to any shape. Once you assign a macro, the shape appears as a button control and you can run the macro whenever you click it. To learn more, please refer to the Assign a Macro to a Shape section of this guide.
- Save as picture is used to save the shape as a picture on your hard drive.
-
Edit Points is used to customize or to change the curvature of your shape.
- To activate a shape’s editable anchor points, right-click the shape and choose Edit Points from the menu or click the Edit shape > Edit points option on the right panel. The black squares that become active are the points where two lines meet, and the red line outlines the shape. Click and drag it to reposition the point, and to change the shape outline.
-
Once you click the anchor point, two blue lines with white squares at the ends will appear. These are Bezier handles that allow you to create a curve and to change a curve’s smoothness.
![Edit Points](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/editpoints_example.png)
-
As long as the anchor points are active, you can add and delete them.
To add a point to a shape, hold Ctrl and click the position where you want to add an anchor point.
To delete a point, hold Ctrl and click the unnecessary point.
- Shape Advanced Settings is used to open the 'Shape - Advanced Settings' window.
Some of the autoshape settings can be changed using the Shape settings tab on the right sidebar that will open if you select the inserted autoshape with the mouse and click the Shape settings icon. The following settings can be changed:
-
Fill - use this section to select the autoshape fill. You can choose the following options:
![Autoshape Settings tab](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/right_autoshape.png)
- Opacity - use this section to set the Opacity level by dragging the slider or entering the percent value manually. The default value is 100%. It means full opacity. The 0% value means full transparency.
-
Line - use this section to change the width, color or type of the autoshape line.
- To change the line width, select one of the available options from the Size dropdown list. The available options are: 0.5 pt, 1 pt, 1.5 pt, 2.25 pt, 3 pt, 4.5 pt, 6 pt. Alternatively, select the No Line option if you don't want to use any line.
- To change the line color, click on the colored box below and select the necessary color.
- To change the line type, select the necessary option from the corresponding dropdown list (a solid line is applied by default, you can change it to one of the available dashed lines).
- To change the line opacity, enter the required value manually or use the corresponding slider bar.
-
Rotation is used to rotate the shape by 90 degrees clockwise or counterclockwise as well as to flip the shape horizontally or vertically. Click one of the buttons:
- to rotate the shape by 90 degrees counterclockwise
- to rotate the shape by 90 degrees clockwise
- to flip the shape horizontally (left to right)
- to flip the shape vertically (upside down)
-
Edit shape - use this section to edit the shape points or to replace the current autoshape with another one selected from the dropdown list.
-
Edit points is used to customize or to change the curvature of your shape.
-
Once you click the anchor point, two blue lines with white squares at the ends will appear. These are Bezier handles that allow you to create a curve and to change a curve’s smoothness.
![Edit Points](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/editpoints_example.png)
-
As long as the anchor points are active, you can add and delete them.
To add a point to a shape, hold Ctrl and click the position where you want to add an anchor point.
To delete a point, hold Ctrl and click the unnecessary point.
- Change shape is used to replace the current autoshape. Choose another autoshape from the dropdown list.
-
Shadow - open this menu to choose one of the preset shadow styles used for the shape.
- No Shadow - uncheck this menu point to display a shadow, and vice versa.
- Color - choose one of the available colors either on the Theme colors or the Standard colors palette; use the Eyedropper tool to copy color from other objects in the document; or click the More colors menu item to create a custom color.
-
Adjust Shadow - create a custom shadow using the following sliders:
![Adjust shadow](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/common/main/resources/help/en/images/adjust_shadow.png)
- Transparency - adjust the transparency of the shadow.
- Size - adjust the size of the shadow.
- Angle - adjust the angle of the shadow relative to its object.
- Distance - adjust the distance of the shadow from its object.
Adjust shape advanced settings
To change the advanced settings of the autoshape, use the Show advanced settings link on the right sidebar. The 'Shape - Advanced Settings' window will open:
![Shape - Advanced Settings](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties.png)
The Size tab contains the following parameters:
- Width and Height - use these options to change the width and/or height of the autoshape. If the Constant proportions button is clicked (in this case it looks like this ), the width and height will be changed together preserving the original shape aspect ratio.
![Shape - Advanced Settings](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_5.png)
The Rotation tab contains the following parameters:
- Angle - use this option to rotate the shape by an exactly specified angle. Enter the necessary value measured in degrees into the field or adjust it using the arrows on the right.
- Flipped - check the Horizontally box to flip the shape horizontally (left to right) or check the Vertically box to flip the shape vertically (upside down).
![Shape - Advanced Settings](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_1.png)
The Weights & Arrows tab contains the following parameters:
-
Line Style - this option group allows you to specify the following parameters:
- Arrows - this option group is available if a shape from the Lines shape group is selected. It allows you to set the arrow Start and End Style and Size by selecting the appropriate option from the dropdown lists.
![Shape - Advanced Settings](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_2.png)
The Text Box tab allows you to Resize shape to fit text, Allow text to overflow shape or change the Top, Bottom, Left and Right internal margins of the autoshape (i.e. the distance between the text within the shape and the autoshape borders).
Note: this tab is only available if text is added within the autoshape, otherwise the tab is disabled.
![Shape Properties - Columns tab](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_4.png)
The Columns tab allows you to add columns of text within the autoshape specifying the necessary Number of columns (up to 16) and Spacing between columns. Once you click OK, the text that already exists or any other text you enter within the autoshape will appear in columns and will flow from one column to another one.
![Shape - Advanced Settings: Cell Snapping](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_6.png)
The Cell Snapping tab contains the following parameters:
- Move and size with cells - this option allows you to snap the shape to the cell behind it. If the cell moves (e.g. if you insert or delete some rows/columns), the shape will be moved together with the cell. If you increase or decrease the width or height of the cell, the shape will change its size as well.
- Move but don't size with cells - this option allows you to snap the shape to the cell behind it preventing the shape from being resized. If the cell moves, the shape will be moved together with the cell, but if you change the cell size, the shape dimensions remain unchanged.
- Don't move or size with cells - this option allows you to prevent the shape from being moved or resized if the cell position or size was changed.
![Shape - Advanced Settings: Alternative Text](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/shape_properties_3.png)
The Alternative Text tab allows you to specify the Title and Description which will be read to people with vision or cognitive impairments to help them better understand what information the shape contains.
Insert and format text within the autoshape
To insert a text into the autoshape, select the shape with the mouse and start typing your text. The text will become part of the autoshape (when you move or rotate the shape, the text also moves or rotates with it).
All the formatting options you can apply to the text within the autoshape are listed here.
Join autoshapes using connectors
You can connect autoshapes using lines with connection points to demonstrate dependencies between the objects (e.g. if you want to create a flowchart). To do that,
- click the Shape icon on the Insert tab of the top toolbar,
-
select the Lines group from the menu,
![Shapes - Lines](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/connectors.png)
- click the necessary shape within the selected group (excepting the last three shapes which are not connectors, namely Curve, Scribble and Freeform),
-
hover the mouse cursor over the first autoshape and click one of the connection points that appear on the shape outline,
-
drag the mouse cursor towards the second autoshape and click the necessary connection point on its outline.
If you move the joined autoshapes, the connector remains attached to the shapes and moves together with them.
You can also detach the connector from the shapes and then attach it to any other connection points.
Assign a Macro to a Shape
You can provide a quick and easy access to a macro within a spreadsheet by assigning a macro to any shape. Once you assign a macro, the shape appears as a button control and you can run the macro whenever you click it.
To assign a macro:
-
Right-click the shape to assign a macro to and choose the Assign Macro option from the drop-down menu.
![Assign Macro on Menu](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/assignmacro_rightclickshape.png)
- The Assign Macro dialogue will open
-
Choose a macro from the list, or type in the macro name, and click OK to confirm.
![Assign Macro](https://test-helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/assignmacro.png)
Return to previous page