Data entry and organization
Insert screenshots into your sheet
How to insert a screenshot To insert a screenshot: Go to Insert > Screenshot . To insert screenshots of any currently open window, select from the listed options. To insert screenshots of a portion in your spreadsheet, select Screen Clipping and ...
Insert an image
To insert an image: Select the cell in which you want to insert the image. Under the Insert menu, select Image . From the dropdown, select either Image In Cell or Image Over Cells > Upload from Mac. Select the desired image and click Open.
Insert a checkbox
To insert a checkbox: Select the cell or the range of cells you wish to add checkboxes to. Under the Insert menu, select Checkbox. You can check or uncheck the box based on your requirement. The logical equivalent of a checked box is TRUE, and for an ...
How to create data validation
Data validation allows you to restrict cell entries to a predefined list to avoid invalid inputs. To create data validation: Under the Data tab, select Data Validation . Select Create Validation from the contextual menu. Select the range of cells you ...
Data from picture
How to import data from picture To import data from a printed document: On the listing page, select Data from Picture under the New section and click Create. Select an image from your device's image gallery and click Open. Once the picture is ...