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.
You can use Gemini to answer questions about the data in your sheet.
Use checkboxes to make Google Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas.
- 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 Data
Data 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.
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 Data
Remove 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.
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.
On this page
Image. 
Checkbox.
Remove duplicates.