On this page
- Add your logo to an invoice
- Generate data analysis & insights with Gemini
- Add checkboxes to spreadsheets
- Standardize data entries with lists
- Validate email addresses
- Split data into columns
- Swap rows and columns
- Space rows and columns evenly
- Remove duplicate entries & spaces
- Format currencies
Add your logo to an invoice
Make your spreadsheets look consistent and professional by putting your organization’s logo at the top of invoices. Just add the image to the top row. Set the row to "freeze" so it remains visible as you scroll.
Add an image to a spreadsheet
- On your computer, open a spreadsheet in Google Sheets.
- Click the cell where you want to add an image.
- Click Insert Image.
- Select to place your image in the cell or over the the cells. Cells with an image cannot also have text.
- Choose an image or take a snapshot.
- Click Open or Select.
Generate data analysis & insights with Gemini
You can use this feature only if your organization supports it. For help, contact your administrator.
You can use Gemini to answer questions about the data in your sheet.
Important: This feature is currently only available via Gemini Alpha and Workspace Labs program.
- On your computer, open a spreadsheet from Google Sheets.
- At the top right, click Ask Gemini .
- In the side panel, create your own prompt with references from your sheet or generic cell names. Examples of prompts:
- "Identify trends in this table."
- "How can I show regression and prediction of this data?"
- "What analysis can you help me perform with this sheet?"
- "Help me understand month-to-month food prices."
Add checkboxes to spreadsheets
Use checkboxes to make Google Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas.
- Check off items in a to-do list
- Track project tasks
- Take attendance
- Create dynamic charts
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to have checkboxes.
- In the menu at the top, click Insert Checkbox.
- To remove checkboxes, select the checkboxes you want to remove and press Delete.
Standardize data entries with lists
Reduce the chance of data-entry errors by limiting choices in Sheets. For example, if you have a status column, you can give choices, such as Done, In Progress, and Not Started. You specify the options and they appear in a drop-down list in each cell in the column.
Create a list for data validation
- In Sheets, open a spreadsheet.
- Select the column where you want to add the options.
- Click DataData validation.
- Next to Criteria, select List of items.
- Enter the valid options separated by commas.
- Make sure the Show dropdown list in cell box is checked.
- Select Show warning or Reject input to specify what happens if someone enters an invalid option.
- (Optional) To show a message to assist with validation, check the Show validation help text box and enter a message. For example: Please enter a valid value (Done, In Progress, Not Started).
- Click Save.
- (Optional) To see the choices, click the arrow in a cell under the column.
Validate email addresses
If your data involves entering email addresses, reduce entry errors by validating the email format in Sheets.
Use data validation for email addresses
- In Sheets, open a spreadsheet.
- Select the column that will contain the email addresses.
- Click DataData validation.
- Next to Criteria, select Textcontains.
- In the text box next to contains, enter @.
- Select Show warning or Reject input to specify what happens if someone enters an invalid option.
- (Optional) To show a message to assist with validation, select Show validation help text and enter a message. For example: Please enter a valid email address, such as xxx@xxx.xxx.
- Click Save.
Split data into columns
You can split clearly defined data, such as text separated by commas, into separate columns in Sheets. For example, a single column with Last name, First name data can be split into 2 columns: Last name and First name.
- On your computer, open a spreadsheet in Google Sheets.
- If the data’s already in the sheet, select the cells you want to split.
- If the data isn’t in the sheet yet, paste it.
- At the top, click Data Split text to columns.
- To change which character Sheets uses to split the data, next to "Separator" click the dropdown menu.
- To fix how your columns spread out after you split your text, click the menu next to "Separator" Detect automatically.
Note: After you paste the data, you can click Paste Split text to columns.
Swap rows and columns
If you want to rotate what you have in columns to rows, or vice versa, you can do that using the TRANSPOSE function in Sheets. For example, you might want to swap column headings with row headings.
- In Sheets, open a spreadsheet.
- In an empty cell, type =TRANSPOSE.
- In parentheses, enter the references to the rows or columns that you want to transpose.
- Press Enter.
For example:
To transpose rows 1 and 2 of columns A through E, you enter: =TRANSPOSE(A1:E2).
Space rows & columns evenly
In Sheets, you can resize all rows, or all columns, to use the same amount of space.
Evenly space rows & columns
- On your computer, open a spreadsheet in Google Sheets.
- Select the rows or columns you want to resize.
Tip: To select all rows and columns in the sheet, click the button in the top left corner of the sheet. - To resize rows:
- Point to a row border on the numbered row bar. The pointer changes to a vertical arrow.
- To change the height of selected rows, drag the row border in the row bar.
- To resize columns:
- Point to a column border on the column-heading bar. The pointer changes to a horizontal arrow.
- To change the width of selected columns, drag the column border in the heading bar.
Automatically expand cells to show content
In Sheets, you can format cells to automatically expand to show content. You can also set content to flow into adjacent empty cells without expanding cell size.
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to format.
- Click FormatWrapping, then select an option:
- Overflow—Allow content to flow into adjacent empty cells. Overflow saves vertical space and shows as much content as possible.
- Wrap—Automatically expand cells to show all content. Wrap lets you view all content in selected cells.
- Clip—Hide content that doesn't fit in existing cells. Clip shows only the content that fits in the cell.
Remove duplicate data & spaces
Duplication errors and spaces are a common problem that can be costly and easy to miss, especially in big data.
- Remove unwanted, duplicate data. Cells with identical values but different letter cases, formatting, or formulas are considered duplicates.
- Remove extra leading spaces, trailing spaces, or excessive spaces from your data. This helps reduce problems when searching for data strings.
Remove duplicate data
- In Sheets, open a spreadsheet.
- Select the data range that you want to remove duplicate data in.
- Click DataRemove duplicates.
- Select which columns to include and whether the data has headers.
- Click Remove duplicates.
- In the status window, click OK.
Remove extra spaces
- In Sheets, open a spreadsheet.
- Select the data range that you want to remove extra spaces in.
- Click DataTrim whitespace.
Nonbreaking spaces aren’t trimmed.
Format currencies in your spreadsheet
If you’re working with international teams or clients, you can add international currencies to your financial spreadsheets in Google Sheets.
- On your computer, open a spreadsheet in Google Sheets.
- Highlight the data you want to format.
- Click Format Number.
- Click Custom currency.
- Search in the menu text box to select a format. You can also add your own custom currency format into the text box.
- Click Apply.
You can also change a few properties about the currency (for example, how many decimal places to show) by clicking the drop-down menu in the right corner of the input box and choosing a desired option.
Related topics
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.