Search

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 address, email address, or bookmark within the spreadsheet by using the corresponding tabs at the top of the dialog.

 

Insert tab in Sheets Android

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

Table – Inserts a table into the selected cell or cell range. You can specify the number of rows and columns by dragging them across the creation grid. Once a table is inserted, you can modify it under the Table tab by tapping on it.
Picture – Inserts an image into your spreadsheet from your Android file system. Placed images can be modified using resize and scale anchors.
Web Picture – Perform an online image search and instantly insert a picture into your spreadsheet (requires an Internet connection).
Camera – Allows you to insert an image using your devices' camera.
Chart – Opens the chart insertion dialog, which allows you to insert a chart with a range of chart options. The Type tab lists charts and chart subtypes, along with a 3D effect toggle. The Data tab allows you to add and name series and ranges, while the Style tab provides options to change chart colors. Selected charts can be modified using the Charts tab.
Chart in New Sheet – Provides identical options to the chart tab, except the chart will be inserted into a separate sheet in the spreadsheet.
Link – Marks the contained cell elements as a hyperlink to a web address or email. Offers options to add URL; Email; Cell; Defined Names.
Comment – Adds a comment to a cell or cell range. Commented cells are marked by a small indicator in the upper right, and will briefly appear when the cell or cell range is selected.
Line Break – Similar to how the Shift + Enter key combination works, the Line Break feature will bring the cursor to a new line in the same paragraph.

 

Insert tab in Sheets iOS

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

Table – Include a table in the spreadsheet, a new Table tab will appear, the options of which include:
Picture – Inserts an image into your spreadsheet from your iOS Photos app. You may be prompted to grant OfficeSuite access to your Photos in order for this feature to work. Placed images can be modified using the resize and scale anchors, and rotated using the protruding rotate anchor.
Camera Picture – Allows you to insert an image using your iPhone or iPad camera.
Row Above – Inserts a blank row above the currently selected cell.
Column Left – Inserts a blank column to the left of the currently selected cell.
Chart – Inserts a custom chart with a data range you specify. Selected charts can be modified using the Chart tab.
Chart in a New Sheet – Provides identical options to the chart item, except the chart will be inserted into a separate sheet in the spreadsheet. Selected charts can be modified using the Chart tab.
Comment – Adds a comment to a cell. Commented cells are marked by a small red indicator in the upper right.
Hyperlink – Marks the contained cell elements as a hyperlink to a website, email address, or a reference in the current spreadsheet.