Insert tab in Sheets

Insert tab in Sheets Windows

The Insert dropdown is used for placing a wide range of visual additions to your spreadsheets, such as graphics and charts.

Table... – Inserts a table with a pre-set formatting style. Just select its proportions and click OK.
Picture... – Inserts an image into your spreadsheet from your computer's filesystem. Placed images can be modified using the resize and scale anchors and rotated using the protruding rotate anchor.
  Right-clicking on an image provides additional options:
Save as Picture – Save the currently selected image to your computer.
Chart... – Opens the Chart Editor, which allows you to insert a chart with a range of visual styles. The Type tab lists charts and chart subtypes, including 3D effect variants. The Format tab allows you to add and name series, ranges, and titles.
  Right-clicking on a chart provides additional options:
Change Chart Type... – Changes the selected chart type through the Chart Editor.
Format Chart... – Changes the selected chart data and formatting through the Chart Editor.
Save as Picture – Saves the currently selected chart as an image on your computer.
Chart in New Sheet – Same as the Chart operation above, except the chart will be added as its own separate sheet.
Comment – Adds a comment to a cell or cell range. Commented cells are marked by a small indicator in the upper right, and comments will appear by hovering your mouse over them. Comments can be edited and deleted from the Review tab.
  Right-clicking on a cell with a comment provides additional options:
Edit Comment – Edits a comment in the selected cell or cell range.
Delete Comment – Removes a comment from the selected cell or cell range.
Link... – Adds a hyperlink to any selected text. You can choose between a web addressemail address, or bookmark within the spreadsheet by using the corresponding tabs at the top of the dialog.

Was this article helpful?

1 out of 2 found this helpful