Learn what's new in Google Sheets

For ranges with vertical merges, you can create a filter and select various filter types, such as:

• Condition
• Values
• Colour

For ranges with horizontal merges, you can create a filter and select various filter types, such as:

• Condition
• Values
• Colour
• Sort by values or colour

Learn how to sort and filter your data.

You can now insert preset drop-down chips set up for common use cases like priority or review statuses. When you insert a preset drop-down, use the data validation sidebar to easily adjust the options or add styles.

Learn how to create an in-cell drop-down list.

You can scroll to a specific part of a row or column and stop anywhere within the spreadsheet. It works when you use scrollbars, instead of a mouse or trackpad, and in all Sheets features like:

• Frozen rows
• Hidden columns
• Charts
• Buttons
• Comments
• Right-to-left layouts

The timeout time for BigQuery and Looker went from 20 to 30 minutes. You can also check the status of a query and easily cancel it in Google Sheets.

Learn more about connected sheets for Looker.

Learn about BigQuery data in connected sheets.

You can now import and convert sensitive Excel files into Google Sheets with client-side encryption. Whether you work with external or internal users, you can use both Google Sheets and Microsoft Excel.

Learn how to work with encrypted files in Sheets.

• With Looker: Check if these filters are applied in their Google Sheets:
  • Looker-defined filters
  • Always_filters
  • Conditionally_filters
• With BigQuery: Right-click any value in the connected sheets preview and filter rows based on that value. To re-fetch the preview, a new query is sent to BigQuery. This new option allows you to easily explore data in the connected sheets preview for BigQuery.

Learn how to sort and filter BigQuery data in Google Sheets.

You can show context-aware Help Centre content in Sheets for the 23 supported Sheets functions, like AVERAGE and XLOOKUP. When you create a formula that can query BigQuery, the formula shows descriptions for connected sheets functions. Otherwise, the formula shows descriptions of native Sheets functions.

Learn more about the XLOOKUP function.

You can copy charts from the Google Sheets app on all iOS devices and paste them externally as images or a duplicate chart in the same spreadsheet. You can also use text formats with the contextual toolbar in Sheets when a keyboard is attached to iOS tablets.

Learn how to add and edit a chart or graph.

Learn how to edit and format a spreadsheet.

Enhanced Smart Fill in Google Sheets is available to users on work or school accounts through a Gemini for Google Workspace add-on, and to users on personal accounts through Google One AI Premium. Use enhanced Smart Fill with Gemini.

When your hyperlinked text matches the text of a smart chip in Sheets, you're prompted to convert an inserted file, people, calendar event, YouTube or place link into a smart chip.

Learn how to insert smart chips.

You can now view your timelines on Android and iOS.

Learn about timeline view.

Emoji reactions are now available on comments in Google Sheets, and allow you to quickly and creatively express your opinions about spreadsheet content.

Use comments, action items and emoji reactions.

In Google Sheets, you can use the 'Help me organise' prompt to create tables with artificial intelligence. Learn how to organise with Gemini.

You can now import and convert sensitive Excel files into Google Sheets with client-side encryption. Your encrypted Excel file won't be changed, even as you change the encrypted Sheets file.

To insert emojis into a Google Sheet, select an option:

1. On your spreadsheet, input @  Emoji.
   • Select the desired emoji.
2. On your spreadsheet, click Insert Emoji.
   • Select the desired emoji.

Learn how to insert emojis and special characters.

Place chips: When you add a Google Maps place chip in your Sheet, you can open the location directly in Google Maps, and find a preview of the location or find directions.

Expanded date capabilities: Include dates in your Sheet easily by the use of @ entry point with shortcuts like:

• @today
• @yesterday
• @tomorrow
• @date
  • When you click on the date, a date picker shows up to allow you to update dates as you need.

Finance chips: Add Google Finance entities, such as stocks, mutual funds and currencies into a Sheet. Hover over the chip to preview information based on entity type.

Learn how to insert smart chips.