how to find worksheet answers on google

Teachers have the option to see correct answers in workbooks.

• To view answers on a worksheet, click on the menu option in the top right corner that has three lines, also known as a "hamburger" menu, and select Edit.
• This will open the worksheet to view how it was setup and see correct answers in green.

Students have the option to see correct answers after submitting their work if a worksheet is setup to allow this.

• ​​​​​​​​​​​​​​On the worksheet in the menu option in the top right corner, select Show Right Answers
• Choose the option to Add button "Show Right Answers" when the student has finished the exercise is selected
• Click Save Changes

When the student submits their work, the grading will be displayed on the top left portion of the worksheet along with a button to Show right answers .  

Community Support

If you need more help, you can ask our community of users.

Contact Support

How to find answers on Google Forms in 3 different formats, as well as in Google Sheets

• You can find answers on Google Forms as a creator after sending one out and receiving feedback.
• You can view respondents' answers in three different ways: as a summary, by question, or by individual respondent.
• You can also view answers via Google Sheets if you prefer.

If you've sent out a Google Form and begun to collect responses, you'll want to be able to see what people answered. Fortunately, Google Forms makes the whole process easy to understand. 

Here's how to find respondents' answers on your Google Forms.

How to find answers on Google Forms

1.  Open your Google Form.

2.  Click on "Responses."

3.  After you've opened the Responses tab, you will be able to view answers in three different ways: "Summary," "Question," and "Individual."

4.  Click on the "Summary" tab to view a summary of all answers submitted to your Google Form. These may appear as charts and graphs, or in other formats.

5.  Click on the "Question" tab to view collection data for specific questions on your form. The responses you are viewing will be for the specific question listed in the drop-down menu.

7. Click on the "Individual" tab to view specific respondents' answers to each question. To navigate between respondents, click on the arrows in the top banner.

How to find answers on Google Sheets

You can also view answers to your Google Form via a spreadsheet that is automatically saved when creating a Google Form. First, open the Google Form within Google Drive. 

1.  Click on the Responses Tab. 

2.  Select the Google Sheets icon in the top right corner. 

3.  You should now see the responses displayed in a spreadsheet. 

To turn on email notifications after respondents fill out your form, all you have to do is click the three-dot icon under the same Responses tab and select "Get email notifications for new responses."

Related coverage from  Tech Reference :

What are google forms everything you need to know about google workspace's online form builder, how to embed google forms to share surveys on your website, how to upload a file on google forms or let respondents upload their own files, are google forms anonymous here's how to enable anonymous responses and know whether yours is, how to create a chart or graph in google sheets to get a visual display of your data, watch: worst tech of the decade.

• Main content

Making Find Answers On Google Sheets

Introduction.

Google Sheets is an invaluable tool for organizing and analyzing data, but sometimes finding the right answers can be a challenge. Whether it's locating specific information within a large dataset or understanding a complex formula, it's essential to be able to efficiently find answers on Google Sheets . In this blog post, we'll explore the importance of finding answers on Google Sheets , the challenges people commonly face when trying to find answers , and preview some solutions to help you make the most of this powerful tool.

Key Takeaways

• Efficiently finding answers on Google Sheets is essential for productivity and data analysis.
• Utilizing search functions such as "Find," "Filter," and "Search" can help narrow down specific information within a dataset.
• Leveraging built-in help resources like the Google Sheets support page, the "Explore" feature, and community forums can provide guidance and insights.
• Using external resources such as tutorials, video demonstrations, and blog articles can offer in-depth assistance and tips for problem-solving.
• Customizing settings for efficient search and collaborating with colleagues for feedback can enhance the process of finding answers on Google Sheets.

Utilizing search functions

When working with Google Sheets, it is essential to be able to efficiently find specific answers within your data. Google Sheets provides several search functions that can help you to quickly locate the information you need.

The "Find" function in Google Sheets allows you to search for a specific keyword or value within your spreadsheet. To use this function, simply press Ctrl + F on your keyboard, or go to Edit > Find and Replace > Find . You can then enter the keyword or value you are looking for, and Google Sheets will highlight all instances of it within the sheet.

The "Filter" function in Google Sheets is another powerful tool for finding specific answers within your data. By using the filter function, you can narrow down your search results based on specific criteria, such as specific values within a column. Simply click on the filter icon in the column header, and then select the specific values you want to filter by.

The "Search" function in Google Sheets allows you to find specific text within the sheet. To use this function, simply press Ctrl + H on your keyboard, or go to Edit > Find and Replace > Find . You can then enter the text you are looking for, and Google Sheets will highlight all instances of it within the sheet.

Leveraging built-in help resources

When using Google Sheets, it's essential to know how to find answers to any questions or issues that may arise. Luckily, Google Sheets provides several built-in help resources to assist users in finding the answers they need.

A. Accessing the Google Sheets support page for guidance

Google Sheets offers a comprehensive support page that provides guidance on a wide range of topics. Users can access this support page by clicking on the "Help" menu at the top of the Google Sheets interface and selecting "Help Center." This will open a new tab in your web browser, where you can search for answers to specific questions or browse through the available support topics.

B. Utilizing the "Explore" feature to find answers and insights

The "Explore" feature in Google Sheets is a powerful tool that can help users find answers and insights within their spreadsheets. To access this feature, simply click on the "Explore" button located in the bottom right corner of the Google Sheets interface. From there, you can enter a question or topic into the search bar and receive relevant answers and insights based on the data in your spreadsheet.

C. Seeking help from the Google Sheets community forums

Google Sheets also offers community forums where users can seek help from other users and experts. To access the community forums, click on the "Help" menu and select "Community." This will take you to the Google Sheets community forums, where you can ask questions, browse through existing discussions, and learn from the experiences of other users.

Using external resources

When faced with a problem or question while using Google Sheets, it can be incredibly helpful to turn to external resources for assistance. Here are a few ways to utilize external resources for finding answers on Google Sheets:

A. Exploring online tutorials and guides for in-depth assistance

Online tutorials and guides can provide a deep dive into specific features or functions of Google Sheets. These resources often break down complex tasks into manageable steps, making it easier to understand and implement them in your own work.

Sub-points:

• Look for comprehensive tutorials on reputable websites such as Google's own support pages, or platforms like YouTube, Skillshare, or Udemy.
• Take the time to follow along with the tutorials, pausing as needed to apply the steps to your own Google Sheets document.

B. Watching video tutorials for visual demonstrations of problem-solving

Video tutorials can be particularly beneficial when it comes to visual demonstrations of problem-solving in Google Sheets. Watching someone else navigate through a similar issue can provide valuable insight and make it easier to replicate the solution in your own work.

• Search for video tutorials that specifically address the problem or question you have about Google Sheets.
• Pay attention to the presenter's explanations and any on-screen demonstrations, and practice alongside the video to reinforce your learning.

C. Consulting Google Sheets blogs and articles for tips and tricks

Blogs and articles dedicated to Google Sheets are a wealth of knowledge when it comes to finding tips and tricks for using the platform more effectively. These resources often share insider insights and creative solutions that you may not have considered on your own.

• Seek out reputable blogs or websites that frequently publish content related to Google Sheets, and bookmark them for future reference.
• Take the time to read through articles and blog posts, and make note of any tips or tricks that could be applicable to your own use of Google Sheets.

Customizing settings for efficient search

When using Google Sheets, it's important to customize your search settings to ensure efficient and effective results. By adjusting the settings, learning keyboard shortcuts, and utilizing add-ons, you can enhance your search capabilities and streamline your workflow.

Adjusting the search settings to include or exclude specific criteria

Google Sheets allows you to adjust the search settings to include or exclude specific criteria, such as case sensitivity or whole word matching. By customizing these settings, you can refine your search results and find the information you need more quickly and accurately.

Learning keyboard shortcuts for quicker navigation and search

Mastering keyboard shortcuts can significantly increase your efficiency when searching on Google Sheets. By learning shortcuts for functions like finding, replacing, and navigating between cells, you can save time and complete tasks more quickly.

Utilizing add-ons to enhance search capabilities and functionality

Google Sheets offers a range of add-ons that can enhance your search capabilities and overall functionality. From advanced search tools to data visualization add-ons, there are numerous options available to customize your search experience and improve productivity.

Collaborating and seeking feedback

Google Sheets offers various tools and features that make it easy to collaborate with colleagues and seek feedback when looking for answers to complex problems. Here are some ways to effectively use Google Sheets for collaborating and seeking feedback:

• Invite colleagues: Share the Google Sheet with colleagues who have the expertise or knowledge to help in finding answers to specific questions. Collaboratively working on the sheet allows multiple people to contribute their ideas and solutions.
• Assign specific tasks: Use Google Sheets to assign specific tasks or sections to different colleagues, ensuring that everyone is working on a particular area of focus for finding answers.
• Add comments: Encourage colleagues to add comments to the cells or sections where they have insights or suggestions for finding answers. This allows for a streamlined communication process within the Sheet.
• Utilize notes: Use the notes feature in Google Sheets to provide additional context or explanations related to specific data or calculations, making it easier for colleagues to understand the context and contribute effectively.
• Share for feedback: Share the Google Sheet with individuals outside of the immediate team to gain fresh perspectives and insights. This can provide new ways of thinking about the problem and offer alternative solutions.
• Act on feedback: Encourage colleagues to actively seek feedback from others and be open to incorporating new ideas or perspectives into the sheet. This iterative process can lead to more comprehensive and well-thought-out answers.

In conclusion, we have discussed several methods for efficiently finding answers on Google Sheets, including using the search bar, using the Explore feature, and utilizing keyboard shortcuts. It is important to be able to quickly find the information you need in order to work more efficiently and effectively. By implementing the suggested solutions, you can streamline your workflow and improve productivity. So, don't hesitate to put these methods into practice and see the difference it makes in your work.

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

The Benefits of Excel Dashboards for Data Analysts

Unlock the Power of Real-Time Data Visualization with Excel Dashboards

Unlocking the Potential of Excel's Data Dashboard

Unleashing the Benefits of a Dashboard with Maximum Impact in Excel

Exploring Data Easily and Securely: Essential Features for Excel Dashboards

Unlock the Benefits of Real-Time Dashboard Updates in Excel

Unleashing the Power of Excel Dashboards

Understanding the Benefits and Challenges of Excel Dashboard Design and Development

Leverage Your Data with Excel Dashboards

Crafting the Perfect Dashboard for Excel

An Introduction to Excel Dashboards

How to Create an Effective Excel Dashboard

• Choosing a selection results in a full page refresh.

4 Easy Ways to Search in Google Sheets (With Examples)

With Google Sheets, you can search text within your spreadsheets in many different ways. Here are some methods you can use.

As a spreadsheet user, you may often see yourself sifting through data rows to find a specific keyword. On smaller spreadsheets, doing this manually is easy. However, with large spreadsheets, this becomes close to impossible.

Thankfully, Google Sheets has several built-in functions that allow you to easily search for data in your spreadsheets.

4 Ways to Search in Google Sheets

There are multiple ways that you can search text in your spreadsheet. We will discuss some of them extensively here. Google Sheets allows you to use formulas and some built-in functions to search text in your spreadsheets. Here are some methods you can use to search text in your spreadsheet.

The ways to search in Google Sheets we’ll cover in this guide are:

• The find and replace tool
• The FIND function
• The SEARCH function
• The MATCH function

Each performs slightly differently, so checking them all out will help you find the perfect way to search Google Sheets depending on your specific needs. Whether you're just starting out on spreadsheets or are an experienced entrepreneur , learning to search is a very important skill for Google Sheets.

1. The Find and Replace Tool

This feature is built into Google Sheets and looks through the spreadsheet to find the keyword you provide. It provides a few advantages over using formulas to achieve the same purpose, the most prominent of which is case matching. It is also one of the best basic tools in Google Sheets .

To access the Find and Replace feature in Google Sheets :

• Click on Edit in the top bar of your main Google Sheets screen.
• Click on Find and replace in the drop-down menu that shows up. This will open a new window in the middle of the screen.

Alternately, you can use the Ctrl + H keyboard shortcut on Windows to do the same thing. On macOS, the shortcut is Cmd + Shift + H .

In the above example, we can find the cells that contain the word "Pencil". In the Find and Replace window, you will see two text boxes: Find and Replace with . In the Find text box, enter your keyword. If you have multiple sheets, choose All sheets in the Search option.

Finally, click on the Find button. This will take you to the first instance of the text in the spreadsheet. You can repeatedly press the button to traverse the spreadsheet to find the keyword.

Alternatively, if you don't plan to replace any data, and you don't need any of the advanced search features, then use the Find feature instead. You can access this by using the Ctrl + F shortcut in Windows. For macOS users, the shortcut is Cmd + F .

2. The FIND Function

You can use this formula to find the position where the string is first detected in the text. This formula is case-sensitive, so ensure the text you enter the formula has the proper case. Here is the syntax for the formula:

The formula uses three arguments. These are:

• search-for : this is the text you're searching for in the search-text parameter.
• search-text: this defines the cell or cell range that the function will search to find the text in the search-for parameter.
• start-at: this is an optional parameter to define the character in the search-text . This defines where the search will be started from.

In this example, we have a sentence in cell A2 . We wish to find the word fox there. Here are the steps to do so:

• Click on the cell where you wish to input the formula.
• Type the initial part of the formula, which is =FIND( .
• Now, type the cell address of the text that you want to search. In this case, it is cell D2 . Alternately, you can also write the text inside quotation marks.
• Write the cell address containing the text you wish to search. In this case, it is cell A2 .
• Add a closing bracket.
• Press Enter to execute the formula.

One thing to note is that this formula is case-sensitive. So if you write “Fox” instead of “fox” then the formula won't work. If you're looking for a similar function that isn't case-sensitive, you can use the SEARCH formula.

Note: If you’re confused by the numerical result in the example, remember the FIND function notes the location of the string, in our case, fox. You’ll notice that the f in fox is the 17 character in the cell (including spaces) hence the result of 17.

3. The SEARCH Function

The SEARCH formula is almost identical to the FIND formula. Here is the syntax for the formula:

As you can see, the SEARCH formula uses the same parameters as the FIND formula. We will use a different case for the search text to demonstrate this formula. Here are the steps to use the SEARCH formula.

• Type the initial part of the formula, which is =SEARCH( .
• Now, type the cell address of the text that you want to search. In this case, it is cell D2.

4. The MATCH Function

The MATCH function outputs the position of a value in a defined cell range that matches a value specified by the user. Here is the syntax for the formula:

The formula uses three parameters. These are:

• key: this is the value that you want to search for. This can be a number, string, or a combination of both.
• range: this is the 1-dimensional array to search the value within. Note that using a 2-dimensional range will return the #N/A! Error.
• type: this is an optional parameter that defines the method to search the range.

In the type parameter, you can choose to enter either 1 , 0 , or -1 .

• 1 is the default and assumes that the range is in ascending order.
• 0 is used where the range is in no particular order.
• -1 assumes that the range is in descending order.

Here are the steps you need to follow to use a MATCH formula:

• Type the initial part of the formula, which is =MATCH( .
• Now, type the text that you want to search for. In this case, we will write “Desk” including the quotation marks.
• Add a comma.
• Write the cell range containing the text you wish to search. In this case, it is the range B2:B31 .
• Add another comma to separate the parameters.
• As the data is in no particular order, the third parameter is entered as 0 .

The result is 1 as the first instance of “Desk” is in the first row of the range.

Keeping Searching for Ways to Improve Your Spreadsheet Skills

Aside from SEARCH and FIND, these functions work quite differently and are best used in different scenarios. Familiarize yourself with all of them for the best results in your spreadsheets. Mastering as many Google Sheets functions as possible will have you using the software like a pro in no time.

Contribute to the Microsoft 365 and Office forum! Click  here  to learn more  💡

April 9, 2024

Contribute to the Microsoft 365 and Office forum!

Click  here  to learn more  💡

Excel Forum Top Contributors: HansV MVP  -  Ashish Mathur  -  Andreas Killer  -  Jim_ Gordon  -  Riny_van_Eekelen   ✅

May 10, 2024

Excel Forum Top Contributors:

HansV MVP  -  Ashish Mathur  -  Andreas Killer  -  Jim_ Gordon  -  Riny_van_Eekelen   ✅

• Search the community and support articles
• Microsoft 365 and Office
• Search Community member

Ask a new question

Replacing worksheet name

There is find and replace facility for formulas, values and comments in the dropdown menu 'Look in'. But there is none for sheet name. When a workbook contains some 80 or more ws. it would be better if there is automation facility. or is there some other method to change sheet names?

• Subscribe to RSS feed

Report abuse

Reported content has been submitted​

Excel does not have an easy built-in way to find and replace worksheet names.

It would be possible to use VBA code to do it, but it would be a lot of work.

1 person found this reply helpful

Was this reply helpful? Yes No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Thanks for your feedback.

Replies (2) 

Question info.

• Norsk Bokmål
• Ελληνικά
• Русский
• עברית
• العربية
• ไทย
• 한국어
• 中文(简体)
• 中文(繁體)
• 日本語

Free Math Worksheets by Math-Drills

Math-Drills.com includes over 70,000 free math worksheets that may be used to help students learn math. Our math worksheets are available on a broad range of topics including number sense, arithmetic, pre-algebra, geometry, measurement, money concepts and much more. There are two interactive math features: the math flash cards and dots math game.

Math-Drills.com was launched in 2005 with around 400 math worksheets. Since then, tens of thousands more math worksheets have been added. The website and content continues to be improved based on feedback and suggestions from our users and our own knowledge of effective math practices.

Most Math-Drills users are classroom teachers or parents. Classroom teachers use our math worksheets to assess student mastery of basic math facts, to give students extra math practice, to teach new math strategies, and to save precious planning time. Parents use our math worksheets to give their children extra math practice over school breaks and to enhance their math education. Home schools use our math worksheets in their programs to develop and strengthen math skills in their children.

Most Popular Free Math Worksheets this Week

Supporting Student Learning with Free Math Worksheets by Math-Drills

Math-Drills believes that education should be accessible to all children despite their socioeconomic situation or any other factors. Since it began in 2005, all the math worksheets on Math-Drills have been free-to-use with students learning math. The Math-Drills website works well on any device and worksheets can be printed or used on a screen.

Math-Drills worksheets are also used in special education, adult education, tutoring, colleges, high schools, prisons and a variety of other situations. Special education teachers especially like that we break down math skills and provide large-print options. Adult learners appreciate the simple uncluttered format that our worksheets offer. Tutors use our math worksheets to reduce their costs and focus on student learning. High school, college and university educators sometimes need remedial resources for students to allow them to continue with more advanced topics.

Students who practice their math skills with our math worksheets over school breaks keep their math skills sharp for upcoming school terms. Because we provide answer keys, students are able to self-assess and use the immediate feedback provided by an answer key to analyze and correct errors in their work. Our interactive (fillable) math worksheets allow them to fill in their answers on the screen and save or print the results.

Math-Drills.com Tour on YouTube.

Join the Math-Drills Newsletter

Join our newsletter to find out about new math worksheets and other information related to the website.

Copyright © 2005-2024 Math-Drills.com You may use the math worksheets on this website according to our Terms of Use to help students learn math.

• PRO Courses Guides New Tech Help Pro Expert Videos About wikiHow Pro Upgrade Sign In
• EDIT Edit this Article
• EXPLORE Tech Help Pro About Us Random Article Quizzes Request a New Article Community Dashboard This Or That Game Popular Categories Arts and Entertainment Artwork Books Movies Computers and Electronics Computers Phone Skills Technology Hacks Health Men's Health Mental Health Women's Health Relationships Dating Love Relationship Issues Hobbies and Crafts Crafts Drawing Games Education & Communication Communication Skills Personal Development Studying Personal Care and Style Fashion Hair Care Personal Hygiene Youth Personal Care School Stuff Dating All Categories Arts and Entertainment Finance and Business Home and Garden Relationship Quizzes Cars & Other Vehicles Food and Entertaining Personal Care and Style Sports and Fitness Computers and Electronics Health Pets and Animals Travel Education & Communication Hobbies and Crafts Philosophy and Religion Work World Family Life Holidays and Traditions Relationships Youth
• Browse Articles
• Learn Something New
• Quizzes Hot
• This Or That Game
• Train Your Brain
• Explore More
• Support wikiHow
• About wikiHow
• Log in / Sign up
• Computers and Electronics
• Spreadsheets

How to Use Google Sheets: The Ultimate Guide for Getting Started

Learn the Google Sheets basics

Last Updated: September 27, 2023 Fact Checked

Opening a Spreadsheet

Opening an excel file in sheets, using google sheets, navigation shortcuts, saving & sharing spreadsheets, expert q&a.

This article was co-authored by wikiHow staff writer, Kyle Smith . Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo. This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources. This article has been viewed 156,751 times. Learn more...

This wikiHow guide will show you how to use Google Spreadsheets on Windows or Mac.

Things You Should Know

• Open a new spreadsheet by going to https://sheets.google.com/ in your web browser.
• Edit an Excel .xlxs file by uploading it to your drive and opening it in Google Sheets.
• Enter data into cells. Then, adjust the formatting by using the toolbar or Format tab.
• Share your spreadsheet by clicking the blue Share button in the top-right of the Sheet.

• Or, go to https://www.google.com/sheets/about/ and click Go to Sheets .
• Or, click the 9-dot grid button in the upper-right corner of https://www.google.com/ , Gmail, or any Google web app. Select Sheets from the menu.

• Create new spreadsheet opens a blank spreadsheet.
• Choose template opens the template gallery, where you can choose a premade layout that fits your spreadsheet needs.
• You can also open a new spreadsheet from Google Drive by clicking the New button and selecting Google Sheets .

• Alternatively, click New in Google Drive, then File upload .

• The .XLSX icon next to the title in the Google Sheets editor indicates that you’re working on an Excel file. If there’s a red dot notification on this icon, there may be a compatibility issue.

• By default, there will be 26 columns (A to Z) and 1000 rows.
• Add more rows by scrolling to the bottom, entering in an amount next to “more rows at bottom,” and clicking Add .
• After adding in your data, you can search through the sheet if you’re looking for something specific.

• You can add a new column or row to a specific location by selecting any cell in the row/column and clicking the Insert tab. You'll see options to insert rows or columns above or below and to the right or left of the selected cell.

• You can also use the toolbar above the formula box to make formatting changes to a range of cells.
• When selecting multiple cells (horizontally or vertically), you can merge them so that they span multiple rows or columns.
• To adjust the way numbers are formatted, go to the Number subsection in the Format tab. You can format numbers in a variety of ways. For example, selecting “Percent” will show numbers as percentages.

• If your data have column headers, go to Sort range > Advanced range sorting options . Check the “Data has header row” box. When you click the Sort by drop-down menu, you can select a column by its header name.
• The A to Z and Z to A options are ascending and descending respectively. This sorts numbers low-to-high or high-to-low.
• Filtering your data is a great way to see temporary views of the dataset without changing the spreadsheet.

• See our guide on creating graphs in Sheets for more detailed information!

• 1 row or 2 rows will freeze the first 1 or 2 rows.
• 1 column or 2 columns will freeze the first 1 or 2 columns.
• To freeze more rows and columns, select the cell that you want to freeze up to. Then, select Up to row NUMBER or Up to column LETTER .

• Google Sheets offers most of the same functions found in Microsoft Excel, so those experienced with Excel should find Sheets to be pretty familiar.
• Advanced users can create their own functions using Google Apps Script. For example, you could create a simple script to add the time and date automatically .
• IF lets you return a specified value by evaluating a logical expression. This works similarly to using If-Else in Excel .
• VLOOKUP searches a column for a key value, then returns a cell value in a specific column to the right of the search range. (Check out our Excel guide for this function ).
• SUM adds multiple cell values together. ( Same as SUM in Excel ).
• ABS will give you the absolute value of a number.
• FLOOR rounds a number value down to the closest integer.
• NPV returns the net present value for an investment given periodic cash flows.

• Show common keyboard shortcuts — Ctrl + /
• Select column — Ctrl + Space
• Select row — Shift + Space
• Fill down — Ctrl + d
• Fill right — Ctrl + r
• Copy, cut, and paste — Ctrl + c , Ctrl + x , and Ctrl + v
• Move to beginning of sheet — Ctrl + Home
• Move to beginning or end of a range — Ctrl + Up/Down/Left/Right Arrow

• Show common keyboard shortcuts — Cmd + /
• Fill down — Cmd + d
• Fill right — Cmd + r
• Copy, cut, and paste — Cmd + c , Cmd + x , and Cmd + v
• Move to beginning of sheet — Cmd + Fn + Left Arrow
• Move to beginning or end of a range — Cmd + Up/Down/Left/Right Arrow

• Sharing a sheet with some means that they can view, comment on, or edit the file directly.
• There’s also an option to create a shareable link that you can send to people separately.

wikiHow Video: How to Use Google Spreadsheets

• You can create charts within a spreadsheet, but you can also create a gadget for a chart, pivot table . Gadgets can then be embedded in another web page such as Google Sites. Having gadgets from many spreadsheets embedded in a single page provides a dashboard type view of all the spreadsheets. Thanks Helpful 0 Not Helpful 0

You Might Also Like

• ↑ https://support.google.com/docs/answer/6000292?hl=en&co=GENIE.Platform%3DDesktop
• ↑ https://support.google.com/docs/answer/181110?hl=en&co=GENIE.Platform%3DDesktop

About This Article

Anyone with a Google account can create and share a spreadsheet by using Google Sheets. To get started, open your web browser and go to Sheets.Google.com. If you're already signed in to your Google account, you'll see the main area of Google Sheets. If not, you'll be prompted to sign in with your Google Account. Once you are signed in, you can select a template from the template gallery, or click the plus sign to create a blank workbook. Type a name for your Google Sheets file into the top-left corner. As you work on your file, the changes you make will be saved automatically to your Google Drive. If you plan to collaborate on this sheet with others, or just want others to see what you've been working on, you can share your file by clicking the "Share" button at the top-right corner of your open Google Sheets file. If you just want to share a link to the file by pasting it into a message or post, click "Copy link" to copy the link to your clipboard, and then paste it wherever you'd like. If you want to share your file via email, type the email address of the person you want to share with into the top field, and then click the correct person in the search results. You can enter multiple addresses if you want to share with more than one person—you can even share with a group by typing the group's name and selecting it from the search results. Once you've added at least one person to share with, you'll see a permissions drop-down menu at the top-right corner. It's set to "Editor" by default, which means the person or people you're sharing with can make their own edits to the file. If you don't want others to make changes, click the drop-down menu and select "Viewer," or "Commenter" if you also want the viewer to be able to add comments. Next, click the gear icon to manage whether Editors can change permissions or invite others, and whether Viewers and Commenters can download, print, or copy the file. Before sending the invitation, type a message into the Message area that explains what the Google Sheets file is, or why you're sharing it. Then, click "Send" to share the file. When a recipient clicks the link in the email from Google Sheets, the file you shared will open for viewing or editing. Did this summary help you? Yes No

• Send fan mail to authors

Is this article up to date?

Featured Articles

Trending Articles

Watch Articles

• Terms of Use
• Privacy Policy
• Do Not Sell or Share My Info
• Not Selling Info

wikiHow Tech Help Pro:

Level up your tech skills and stay ahead of the curve

Cloud Storage

Custom business email

Video and voice conferencing

Shared Calendars

Word processing

Spreadsheets

Presentation builder

Survey builder

Google Workspace

An integrated suiet of secure, cloud-native collaboration and productivity apps powered by Google AI.

Make data-driven decisions, in Google Sheets

Create and collaborate on online spreadsheets in real time and from any device.

• For my personal use
• For work or My Business

T h e s e   n u m b e r s   l o o k   v e r y   s t r o n g !

Collaborate on data, from anywhere

Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Use comments and assign action items to keep analysis flowing.

Get to insights faster with built-in intelligence

Assistive features like Smart Fill and formula suggestions help you analyse faster with fewer errors. And get insights quickly by asking questions about your data in simple language.

Seamlessly connect to other Google apps

Sheets is thoughtfully connected to other Google apps that you love, saving you time. Easily analyse Google Forms data in Sheets, or embed Sheets charts in Google Slides and Docs. You can also reply to comments directly from Gmail and easily present your spreadsheets to Google Meet.

Extend collaboration and intelligence to Excel files

Easily edit Microsoft Excel spreadsheets online without converting them, and layer on Sheets’ enhanced collaborative and assistive features like comments, action items and Smart Fill.

Build custom solutions

Speed up workflows by building business apps and automations. Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items and macros with Apps Script.

Always work with fresh data

With Sheets, everyone’s always working on the latest version of a spreadsheet. And with edits automatically saved in version history, it’s easy to undo changes or even see edit history of an individual spreadsheet cell.

Seamlessly connect to critical data

Pull in and analyse data from the other tools that you use, like customer data from Salesforce. Enterprise customers can also use connected sheets to analyse billions of rows of BigQuery data in Sheets – without writing any code.

Security, compliance and privacy

Secure by default

We use industry-leading security measures to keep your data safe, including advanced malware protections. Sheets is also cloud-native, eliminating the need for local files and minimising risk to your devices.

Encryption in transit and at rest

All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.

Compliance to support regulatory requirements

Our products, including Sheets, regularly undergo independent verification of their security, privacy and compliance controls .

Private by design

Sheets adheres to the same robust privacy commitments and data protections as the rest of Google Cloud’s enterprise services .

You control your data.

We never use your sheets content for ad purposes., we never sell your personal information to third parties., find the plan that’s right for you, google sheets is a part of google workspace.

Every plan includes

Collaborate from anywhere, on any device

Access, create and edit your spreadsheets wherever you are — from any mobile device, tablet or computer — even when offline.

Get a head-start with templates

Choose from a variety of dashboards, project trackers and other professionally-designed templates to kick things off quickly..

Visit the Sheets template gallery for more.

Ready to begin?

How-To Geek

How to search in all sheets of a spreadsheet in google sheets.

Find anything within a complex spreadsheet.

Quick Links

Use "find and replace" to search within google sheets, use google drive to search within google sheets.

Need to search inside multiple sheets of a Google Sheets spreadsheet at once? We'll show you how using either "Find and Replace" or a Google Drive search tip.

A quick way to search inside all sheets of a Google Sheets spreadsheet at once is to use the "Find and Replace" function. With this, you can search for a keyword in the current sheet, in a specific sheet, or all sheets of your spreadsheet.

To do so, open your favorite browser and visit the Google Sheets site.

Next, open the spreadsheet that you'd like to search within. In the menu bar, click "Edit," and then select "Find and Replace." Alternatively, press Ctrl+h on Windows or Command+Shift+h on Mac.

In the "Find and Replace" window that opens, click the "Find" box at the top and type your search query. Next, click the "Search" drop-down menu and select "All sheets" to search in all sheets. Then, click "Find" at the bottom to start the search.

If Google Sheets finds a match in a sheet, it will open that sheet and highlight the field that includes your query.

If it can't find your searched words in your sheets, it will display an error message.

When you're done, click "Done" in the "Find and Replace" window to close it.

Google saves all your Sheets spreadsheets in Google Drive , which means that you can use Drive's search feature to search inside your spreadsheets. The only issue with this method is that it won't show exactly which sheet matches your search query, only the entire spreadsheet itself.

To get started, load the Google Drive site in a browser. On the main Google Drive page, click the "Search in Drive" box at the top. Type your search query, press Space, and then type this and hit Enter:

type:spreadsheet

Google Drive will look for your typed query in your Google Sheets spreadsheets.

On the search results screen, it will list the spreadsheets that match your search. Double-click any spreadsheet here to open it in the Sheets editor.

And that's how you search in all sheets without opening each one in Google Sheets. Very handy!

Related: The Beginner's Guide to Google Sheets

• Create new account
• Reset your password

Register and get FREE resources and activities

Ready to unlock all our resources?

Worksheet finder

Easily Connect Google Forms To Google Sheets [2 Ways]

• Last updated April 18, 2023

Google Forms provides a convenient way to collect data. You can use it to take quizzes and surveys and collect feedback and registration information. However, its capabilities are not just limited to these.

When you connect Google Forms to Google Sheets, you can use the analytical powers of the latter to make powerful calculations from the gathered data.

In this tutorial, we will show you how to connect Google Forms to Sheets. We will show you how to do this both ways:

• Creating a Google Sheets datasheet and connecting it to your Google form
• Creating a Google Form from a Google Sheets worksheet

Table of Contents

Why Connect Google Forms to Sheets?

Google Forms already comes with a Responses tab, where you can see a summary of the responses received. Although this is quick and convenient, it does not contain as much analytical functionality as you might need. Linking a Google Form to Google Sheets alleviates this issue.

For example, say you’ve collected registration information from attendees of an event. If there are a lot of attendees, you can directly have the data transferred to a spreadsheet, from where you can further process and analyze the information, get insights, create visualizations, and make important decisions based on complex analytics.

Moreover, every time someone submits the form, the data can get automatically updated in the worksheet so that your worksheet is always up-to-date.

Alternatively, say you have a shared worksheet that allows multiple people to enter data. In such cases, since so many people handle the raw data, there is always the possibility of accidental deletions or unintentional changes being made to the original dataset when adding new data.

A safer option would be to connect the sheet to a Google form that lets users enter the same data without touching the original datasheet.

Moreover, the data can be directly validated through the forms, ensuring all the data in the worksheet is in the correct format.

In addition, the form can look attractive with pictures, company branding colors, logos, etc., and may be made more user-friendly, so that non-Google Sheets users can also easily and quickly enter the required data.

The most important advantage when you link a Google form to Google Sheets is that your data will remain in the sheet even when you delete the Google Form.

How to Connect Google Forms to Google Sheets

There are two ways to convert responses from Google Forms into Google Sheets. You can either create a Google Sheets worksheet from a Google form, or create a Google form from an existing worksheet.

Let’s look at how to link Google forms to Google Sheets using both methods.

How to Send Form Responses to a Spreadsheet

Once you have a Google form designed and ready, you can connect it to a Google Sheets worksheet, so that every time a form is submitted the data (along with a timestamp ) directly gets entered into the appropriate columns of the worksheet.

You can either link the Google form to a spreadsheet that already exists or create a new one.

To connect the form to a worksheet, follow the steps shown below:

Step 1:  Design your Google form, let’s say it looks like this:

Step 2:  Click on the Responses tab of the created form.

Step 3:  Click on the Google Sheets  icon or the ellipsis next to it (followed by Select response destination ).

Step 4:  You will be asked if you want to create a new worksheet or choose an existing one to connect to your form. If creating a new spreadsheet, type a name for the sheet in the input field next to ‘ Create a new spreadsheet ’.

Step 5:  If using an existing spreadsheet, check the radio button next to ‘ Select existing spreadsheet ’. Then click Select and choose the spreadsheet you want to connect to the form.

Please note  that even if you choose an existing spreadsheet, Google Forms is going to create a new tab in the worksheet with fields corresponding to those in your form.

To look at the newly created sheet at any point, simply click on the Google Sheets icon (under the Responses tab of your form).

Test out the Google Forms-Sheets integration by clicking on Preview , filling out the form, and submitting it. Your form should instantly send all your responses to the connected worksheet.

How to Create a Google Form from a Spreadsheet

You can also go the other way round. You can create a Google form from columns in a Google Sheets worksheet.

To connect a form to a worksheet, follow the steps shown below:

• Open a new or existing worksheet in Google Sheets.
• Navigate to Tools > Create a new form  from the main menu.

This will create a Form Responses  sheet in your workbook and open the blank connected Google form in a new browser tab.

You can now start adding questions to the form. You will notice that as you add new questions to the form, the connected worksheet will get automatically updated with a corresponding column header in real-time.

Once you have your responses, you can create a dashboard  with them on Google sheets to tell a story.

Note: Even if you are using an existing worksheet to create a form, Google Sheets will automatically create a new tab called Form Responses 1  when you connect it to a Google Form.

If you create multiple forms connected to the same Google Sheets workbook, there will be separate form to spreadsheet responses created for each form response.

How to Unlink a Google Form from Google Sheets

If you want to unlink a form in Google Spreadsheets:

• Open a form in Google Forms .
• In the top left under “Responses,” click Summary.

• Click Unlink.

How to Save or Delete a Google Form

You can delete individual responses or all the responses on a google form. Simply go to your google forms in summary and click the 3 dots. Select delete all responses if you want to delete all responses.

How to Remove Google Form Responses

If you want to delete individual responses:

• Go to summary under Responses
• Select Individual.
• Choose Previous Previous or Next Next to find the response you want to delete.
• Click Delete Delete and then OK.

How to Filter Data Before Sending to Google Sheets

You might want to filter your form responses so that only specific data go into your worksheet depending on a given input. For example, say you have a signup form and you have a multiple-choice question asking if the user wants to sign up to your mailing system.

Based on the user’s answer to this question, you might want to filter the form’s responses to be sent to the Form Response sheet only if the user chooses a ‘Yes’ .

You can use either the QUERY or FILTER function to accomplish this. Let us look at each of the two methods.

Using the QUERY Function to Filter Form Responses

The QUERY function in Google Sheets  lets you use SQL language commands on your Google Sheets data. The syntax for this function is as follows:

QUERY( data , query , [ headers ])

• data is the range of cells that you want to run the query on
• query is the query that you want to run on your data. It is usually specified as an SQL query within double-quotes.
• headers is an optional parameter. It specifies the number of header rows  at the top of the data (not relevant in this case).

So, if you want to filter data in columns (say) A:E of a sheet, such that it displays only those rows where column E has the value “ Yes ”, your QUERY formula will be as follows:

=QUERY(A:E, “SELECT * WHERE E=’Yes’”)

So let’s assume your form response that corresponds to whether the user wants to sign up or not is stored in column E of the ‘ Form Responses 1 ’ sheet, as shown below:

To filter the sheet and display only those rows where Column E has a “ Yes ” value, follow the steps shown below:

Step 1:  Open the sheet connected to your form.

Step 2:  Press the ‘+’ sign next to the Form Responses   1  tab to create a new sheet in the same workbook.

Step 3:  In cell A1 of this sheet, enter the following formula: =QUERY(‘Form Responses 1’!A:E, “SELECT * WHERE E=’Yes'”,1).

Step 4:  Press the Return Key.

Once you’ve entered this formula into your response sheet, your form data should automatically get filtered in this new sheet to display only those entries where the user has opted to sign up (where column E has the value “ Yes ”).

Using the FILTER Function to Filter Form Responses

Alternatively, you can use the FILTER  function to filter your response data. The syntax for this function is as follows:

FILTER( data , condition )

• data is the range of cells that you want to filter
• condition is the condition you want satisfied for a row to be included in the result

So, if you want to filter data in columns (say) A:E of a sheet ‘Form Responses 1’, such that it displays only those rows where column E has the value “ Yes ”, your FILTER formula will be as follows:

=FILTER(‘Form Responses 1′!A1:E4,’Form Responses 1’!E1:E4=”Yes”)

Once you’ve entered this formula into cell A1 of your response sheet, your form data should automatically get filtered to display only those entries where the user has opted to sign up (where column E has the value “ Yes ”).

You can also use google sheets scripts to add these functions. If you’re new to Google Sheets Scripts, you can check out our beginner’s guide to Google Scripts  to get familiar with the layout.

Frequently Asked Question

Can you link google forms and google sheets.

Yes, you can connect your Google form to Google Sheets, so that every time a user submits a form, the data gets automatically updated in the sheet.

Can Google Forms Pull Data From a Spreadsheet?

No, you can’t use a Google Form to pull data from a spreadsheet. But you can opened forms directly from Google Sheets by navigating to Tools > Create a new form.

Can You Link Multiple Google Forms to One Spreadsheet?

Every time you connect a form to a Google Sheets workbook, a new worksheet is created to store the form response data. It is not possible to link multiple forms to a single spreadsheet by default, however, there are numerous add-ons available that can let you do that.

How Do I Filter Responses From Google Forms to Google Sheets?

To filter responses from Google Forms to Google Sheets, you can use the QUERY or FILTER functions in the sheet to filter out rows that match a given criterion.

Related Reading: 3 Easy Ways to Add Subscript and Superscript in Google Sheets

Wrapping Up the Google Forms Google Sheets Guide

In this tutorial, we discussed two ways to connect Google Forms to Google Sheets. We also discussed how you could filter the responses obtained from your user form so that a sheet displays only the details you need. Integrating Google Forms with Google sheets takes a small amount of time to put together, but once the connection has been set up, it can speed up your workflow.

Want to become a pro in Google Forms and Sheets? Take our masterclass!

ACCESS GOOGLE FORMS & SHEETS MASTERCLASS

Related:  How to Create a Survey in Google Forms [Step-by-Step Guide]

Most Popular Posts

How To Highlight Duplicates in Google Sheets

How to Make Multiple Selection in Drop-down Lists in Google Sheets

Google Sheets Currency Conversion: The Easy Method

A 2024 guide to google sheets date picker, related posts.

• Sumit Bansal
• May 16, 2024
• May 2, 2024

How to Insert a Google Sheets Hyperlink in 5 Seconds

• Chris Daniel
• April 15, 2024

How to Import Stock Prices into Google Sheets

• April 2, 2024

Thanks for visiting! We’re happy to answer your spreadsheet questions. We specialize in formulas for Google Sheets, our own spreadsheet templates, and time-saving Excel tips.

Note that we’re supported by our audience. When you purchase through links on our site, we may earn commission at no extra cost to you.

Like what we do? Share this article!

Please ensure that your password is at least 8 characters and contains each of the following:

• a special character: @$#!%*?&

• Help Center
• Get started
• Learn by product
• Learn by role & industry
• Hybrid workplace tips
• Gen AI tips
• Productivity tips
• Business tutorials
• Switch from Microsoft & others
• Support & accessibility
• Google Workspace
• Privacy Policy
• Terms of Service
• Submit feedback
• What's new?
• Get started Welcome Get ready to switch What to do on your first day Your first week & beyond Cheat sheets & reference guides Open Google Workspace apps
• Learn by product Calendar Chat Chrome browser Docs Drive Gemini Gmail Meet Sheets Slides Managed teams Mobile & device setup All products
• Learn by role & industry Administrative assistants Digital marketing Finance Healthcare Human resources Law practices Manufacturing Media & entertainment Nonprofits Professional services Project management Research & development Retail Sales & marketing Technical support UX design Visual design Web development
• Hybrid workplace tips Hybrid work training & help Use Meet Companion mode Stay connected when working remotely Work from home Work with remote teams Plan & hold meetings from anywhere Hold large remote events Work with non-Google Workspace users
• Gen AI tips Generative AI training & help Get started with Gemini Gemini cheat sheet Role-specific prompts & use cases Tips for writing prompts for Gemini Gemini usage limits Learn about generative AI
• Productivity tips Set up business meetings Discuss topics with your team Brainstorm with colleagues Improve communication Make video conference calls Create great presentations Create strong proposals Onboard team members Optimize your inbox Analyze data Clean up data Go paperless
• Business tutorials Use generative AI at work Plan & manage a project Plan & hold meetings from anywhere Hold large remote events Stay connected when working remotely Collaborate with decision makers Share a final document Free up storage space Plan a project with external clients Delegate work when you're OOO Get up to speed after time off Additional training resources
• Switch from Microsoft & others Switch from Microsoft Switch from Slack Switch from Zoom, Skype, or Webex Switch from Box, Dropbox, or C:\ drive Switch from HCL Notes
• Support & accessibility Support for users Support for administrators Accessibility Save or customize Learning Center guides

Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work .

Google Sheets training and help

On this page

Sheets quick start guides.

Sheets cheat sheet

• Sheets productivity guides

Sheets troubleshooting & more resources

Want advanced Google Workspace features for your business?

Try Google Workspace today!

Quickly learn how to create and edit a spreadsheet, move to Sheets from another online spreadsheet app, and more.

Get started with Sheets      Switch from Microsoft Excel to Sheets

Print this visual reminder to keep handy as you get up to speed using Sheets.

 Sheets productivity guides

• Troubleshoot Sheets
• Take Google's online Sheets course
• Google Sheets accessibility
• How Google handles your information
• Visit the Sheets Help Center
• Get certified in data analytics

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.

Was this helpful?

Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization.

• Anker power bank deal
• Uber introduces Uber Shuttle
• Google Cast on Android Auto
• The best Nintendo Switch games
• iPad Pro M4 (2024) review

Google Search will now show AI-generated answers to millions by default

Ai overviews are now available in the us and will roll out to more than a billion people by the year's end..

Google is shaking up Search. On Tuesday, the company announced big new AI-powered changes to the world’s dominant search engine at I/O, Google’s annual conference for developers. With the new features, Google is positioning Search as more than a way to simply find websites. Instead, the company wants people to use its search engine to directly get answers and help them with planning events and brainstorming ideas.

“[With] generative AI, Search can do more than you ever imagined,” wrote Liz Reid, vice president and head of Google Search, in a blog post . “So you can ask whatever’s on your mind or whatever you need to get done — from researching to planning to brainstorming — and Google will take care of the legwork.”

Google’s changes to Search, the primary way that the company makes money, are a response to the explosion of generative AI ever since OpenAI’s ChatGPT released at the end of 2022. Since then, a handful of AI-powered apps and services including ChatGPT, Anthropic, Perplexity, and Microsoft’s Bing, which is powered by OpenAI’s GPT-4, have challenged Google’s flagship service by directly providing answers to questions instead of simply presenting people a list of links. This is the gap that Google is racing to bridge with its new features in Search.

Starting today, Google will show complete AI-generated answers in response to most search queries at the top of the results page in the US. Google first unveiled the feature a year ago at Google I/O in 2023, but so far, anyone who wanted to use the feature had to sign up for it as part of the company’s Search Labs platform that lets people try out upcoming features ahead of their general release. Google is now making AI Overviews available to hundreds of millions of Americans, and says that it expects it to be available in more countries to over a billion people by the end of the year. Reid wrote that people who opted to try the feature through Search Labs have used it “billions of times” so far, and said that any links included as part of the AI-generated answers get more clicks than if the page had appeared as a traditional web listing, something that publishers have been concerned about. “As we expand this experience, we’ll continue to focus on sending valuable traffic to publishers and creators,” Reid wrote.

In addition to AI Overviews, searching for certain queries around dining and recipes, and later with movies, music, books, hotels, shopping and more in English in the US will show a new search page where results are organized using AI. “[When] you’re looking for ideas, Search will use generate AI to brainstorm with you and create an AI-organized results page that makes it easy to explore,” Reid said in the blog post.

If you opt in to Search Labs, you’ll be able to access even more features powered by generative AI in Google Search. You’ll be able to get AI Overview to simplify the language or break down a complex topic in more detail. Here’s an example of a query asking Google to explain, for instance, the connection between lightning and thunder.

Search Labs testers will also be able to ask Google really complex questions in a single query to get answers on a single page instead of having to do multiple searches. The example that Google’s blog post gives: “Find the best yoga or pilates studios in Boston and show details on their intro offers and walking time from Beacon Hill.” In response, Google shows the highest-rated yoga and pilates studios near Boston’s Beacon Hill neighborhood and even puts them on a map for easy navigation.

Google also wants to become a meal and vacation planner by letting people who sign up for Search Labs ask queries like “create a 3 day meal plan for a group that’s easy to prepare” and letting you swap out individual results in its AI-generated plan with something else (swapping a meat-based dish in a meal plan for a vegetarian one, for instance).

Finally, Google will eventually let anyone who signs up for Search Labs use a video as a search query instead of text or images. “Maybe you bought a record player at a thriftshop, but it’s not working when you turn it on and the metal piece with the needle is drifting unexpectedly,” wrote Reid in Google’s blog post. “Searching with video saves you the time and trouble of finding the right words to describe this issue, and you’ll get an AI Overview with steps and resources to troubleshoot.”

Google said that all these new capabilities are powered by a brand new Gemini model customized for Search that combines Gemini’s advanced multi-step reasoning and multimodal abilities with Google’s traditional search systems.

Catch up on all the news from Google I/O 2024 right here !

Latest Stories

Slack has been using data from your chats to train its machine learning models.

Slack trains machine-learning models on user messages, files and other content without explicit permission. The training is opt-out, meaning your private data will be leeched by default.

Blue Origin successfully sends tourists to the edge of space again after a long hiatus

Jeff Bezos’ spaceflight company successfully flew six paying customers to the edge of space and back this morning, breaking its nearly two-year-long hiatus from crewed missions. This was Blue Origin’s seventh trip with humans on board.

Indie developers are trying to make horse games that don’t suck. It’s not easy

With ambitious new projects, developers are hoping to revive a genre plagued with bad games and worse anatomy.

Apple will reportedly offer higher trade-in credit for old iPhones for the next two weeks

According to Bloomberg’s Mark Gurman, Apple will be offering a little more than usual for some trade-ins starting next week in the US and Canada. That's as long as you're getting one of the iPhone 15 models.

New trailer for Dead Cells: Immortalis gives us a first real look at the animated series

A full trailer just dropped for the upcoming animated show based on the popular game Dead Cells, and it looks like the creators have made a few unexpected choices. Along with the trailer, the series now has a release date: June 19.

Beats headphones and earbuds with AppleCare+ are on sale at Amazon

Several models of Beats headphones and earbuds are deeply discounted right now in a deal from Amazon, including the noise canceling Studio Buds, which are nearly half off. The limited time deal also includes the option for two years of AppleCare+ coverage.

X-Men ‘97 didn’t have to go that hard

I wasn’t sure Marvel, under the auspices of Disney, could deliver on the flavor of the X-Men cartoon, while also making a modern show that older fans, now adults in their 30s and 40s, could enjoy. But X-Men 97 does just that.

Adobe threatens to sue Nintendo emulator Delta for its look-alike logo

Delta, an emulator that can play Nintendo games, had to change its logo after Adobe threatened legal action.

How to watch the Microsoft Build 2024 keynote live on May 21

Microsoft is streaming its Build 2024 keynote on Tuesday. Here's how to watch -- and what to know about the lower-profile event the day before.

Doctor Who: Boom review: All hail the conquering hero

It's the first classic of the Disney+ era.

Motorola’s 2024 Razr lineup may include a bigger cover screen for the budget model

We may have a good look at Motorola’s next foldable phones. A pair of leaks show the entry-level and high-end models in various colors from all sorts of angles.

The OpenAI team tasked with protecting humanity is no more

In the summer of 2023, OpenAI created a “Superalignment” team whose goal was to steer and control future AI systems that could be so powerful they could lead to human extinction. Less than a year later, that team is dead.

The best sous vide machines for 2024

For newbies interested in buying their first sous vide machine or experienced cooks simply looking for an upgrade, here's a list of the best sous vide machines on the market right now.

Valve’s next game appears to be Deadlock, a MOBA hero shooter

According to a pair of content creators, the wait for a new Valve game is almost over: A third-person hero shooter is imminent, and it’s called Deadlock.

Apple is said to be working on a 'significantly thinner' iPhone

The iPhone could be going the way of the iPad Pro by becoming much thinner next year. However, you'll may have to pay quite a lot for this rumored slender model, which may replace the Plus in the annual iPhone lineup.

Surface Pro 10 for Business review: A safe upgrade for IT workers

The Surface Pro 10 for Business is basically just a chip upgrade over the previous model, but it’s still a thin, light and well-designed Windows tablet.

A Fallout crossover is coming to Fortnite

A Fallout crossover is coming to Fortnite, likely when the battle royale's new season starts on May 24.

Amazon's Kindle Scribe dips back to an all-time low, plus the rest of this week's best tech deals

This week's deals in tech include sale prices on gear from Apple, Kindle, Beats, Roku, Anker and more.

This Anker Nano 10K power bank is on sale for just $32

This Anker Nano 10K power bank is on sale for $32 via Amazon. That’s a discount of 20 percent on one of our most recommended power banks.

The next Call of Duty will reportedly hit Game Pass on its release day

It seems that Microsoft has decided to bring the next Call of Duty game to Game Pass on day one. Executives had reportedly been debating for some time how to handle the upcoming release.

Advertisement

Supported by

Can Google Give A.I. Answers Without Breaking the Web?

Publishers have long worried that artificial intelligence would drive readers away from their sites. They’re about to find out if those fears are warranted.

• Share full article

By Kevin Roose

Reporting from San Francisco

For the past year and a half since ChatGPT was released, a scary question has hovered over the heads of major online publishers: What if Google decides to overhaul its core search engine to feature generative artificial intelligence more prominently — and breaks our business in the process?

The question speaks to one of the most fragile dependencies in today’s online media ecosystem.

Most big publishers, including The New York Times, receive a significant chunk of traffic from people going to Google, searching for something and clicking on articles about it. That traffic, in turn, allows publishers to sell ads and subscriptions, which pay for the next wave of articles, which Google can then show to people who go searching for the next thing.

The whole symbiotic cycle has worked out fine, more or less, for a decade or two. And even when Google announced its first generative A.I. chatbot, Bard , last year, some online media executives consoled themselves with the thought that Google wouldn’t possibly put such an erratic and unproven technology into its search engine, or risk mucking up its lucrative search ads business, which generated $175 billion in revenue last year.

But change is coming.

At its annual developer conference on Tuesday, Google announced that it would start showing A.I.-generated answers — which it calls “A.I. overviews” — to hundreds of millions of users in the United States this week. More than a billion users will get them by the end of the year, the company said.

The answers, which are powered by Google’s Gemini A.I. technology , will appear at the top of the search results page when users search for things like “vegetarian meal prep options” or “day trips in Miami.” They’ll give users concise summaries of whatever they’re looking for, along with suggested follow-up questions and a list of links they can click on to learn more. (Users will still get traditional search results, too, but they’ll have to scroll farther down the page to see them.)

The addition of these answers is the biggest change that Google has made to its core search results page in years, and one that stems from the company’s fixation on shoving generative A.I. into as many of its products as possible. It may also be a popular feature with users — I’ve been testing A.I. overviews for months through Google’s Search Labs program, and have generally found them to be useful and accurate.

But publishers are right to be spooked. If the A.I. answer engine does its job well enough, users won’t need to click on any links at all. Whatever they’re looking for will be sitting right there, on top of their search results. And the grand bargain on which Google’s relationship with the open web rests — you give us articles, we give you traffic — could fall apart.

Google executives put a positive spin on the announcement on Tuesday, saying that the new A.I. overviews would improve the user experience by “taking the legwork out of searching.”

But that legwork pays for a lot of journalism, and a lot of other types of online media (fashion blogs, laptop reviews, restaurant listings) without which the internet would be far less useful. If Google’s A.I. overviews starve these websites of traffic, what will happen to them? And if big chunks of the web were to vanish altogether, what would be left for the A.I. to summarize?

Google clearly anticipated these fears, and its executives had responses prepared.

In a briefing this week ahead of Google’s developer conference, they said that the company’s tests had found that users who were shown A.I. overviews tended to conduct more searches, and visited a more diverse set of websites. They also said that the links that appeared in A.I. overviews got more clicks than the links that were displayed on traditional search results pages.

Liz Reid, the vice president of search at Google, said in a blog post on Tuesday that the company would “continue to focus on sending valuable traffic to publishers and creators.”

But parse these responses carefully and you’ll see that Google is not saying that publishers’ overall search traffic won’t decline. That’s because Google can’t really predict what will happen once it starts showing A.I.-generated overviews in billions of search results a day, and how users’ behavior may change as a result.

Earlier this year, I wrote about Perplexity , an A.I.-powered “answer engine” that shows users a concise summary of a topic they’re researching rather than handing them a list of websites to visit. The experience, I believed, was clearly better than a traditional search engine for some types of searches, and usually gave me more useful information faster.

But I was also nervous, because during my own testing of Perplexity, I basically stopped clicking any links at all. In a world where A.I. can browse the internet for me and paraphrase what it sees, I found that I just didn’t need them. And I worried about what would happen if Perplexity users were all like me and got in the habit of relying on A.I.-generated summaries rather than on original sources.

I have the same concerns about Google’s new A.I. overviews, but on a vastly different scale.

Perplexity is tiny — just 10 million monthly users, as of February. Google, by contrast, has billions of users and represents more than 90 percent of the global search market. If it makes a change to its search engine that reduces outgoing traffic by just a few percentage points, every publisher will feel it.

It’s unclear how big the effects of Google’s A.I. overviews will ultimately be. One analyst firm, Gartner, has predicted that traffic to the web from search engines could fall by 25 percent by 2026. And many publishers are bracing for double-digit declines in traffic this year.

Maybe these fears are overblown, and publishers have been worrying over nothing. But after Tuesday’s announcement, Google has made it clear that they’re about to find out either way.

Kevin Roose is a Times technology columnist and a host of the podcast " Hard Fork ." More about Kevin Roose

Explore Our Coverage of Artificial Intelligence

News  and Analysis

Ilya Sutskever, the OpenAI co-founder and chief scientist who in November joined three other board members to force out Sam Altman before saying he regretted the move, is leaving the company .

OpenAI has unveiled a new version of its ChatGPT chatbot  that can receive and respond to voice commands, images and videos.

A bipartisan group of senators released a long-awaited legislative plan for A.I. , calling for billions in funding to propel U.S. leadership in the technology while offering few details on regulations.

The Age of A.I.

D’Youville University in Buffalo had an A.I. robot speak at its commencement . Not everyone was happy about it.

A new program, backed by Cornell Tech, M.I.T. and U.C.L.A., helps prepare lower-income, Latina and Black female computing majors  for A.I. careers.

Publishers have long worried that A.I.-generated answers on Google would drive readers away from their sites. They’re about to find out if those fears are warranted, our tech columnist writes .

A new category of apps promises to relieve parents of drudgery, with an assist from A.I.  But a family’s grunt work is more human, and valuable, than it seems.

More From Forbes

Today’s nyt ‘strands’ hints, spangram and answers for tuesday, may 14.

• Share to Facebook
• Share to Twitter
• Share to Linkedin

Today's NYT Strands hints and answers.

Looking for Monday’s Strands hints, spangram and answers? You can find them here:

Ahoy there, landlubbers (and I suppose anyone joining us from sea or in the air). I hope you’re doing well and you’re ready to have fun with today’s game of Strands .

Today’s NYT Strands hints, spangram and answers are coming right up.

How To Play Strands

The New York Times’ Strands puzzle is a play on the classic word search. It’s in beta for now, which means it’ll only stick around if enough people play it every day.

There’s a new game of Strands to play every day. The game will present you with a six by eight grid of letters. The aim is to find a group of words that have something in common, and you’ll get a clue as to what that theme is. When you find a theme word, it will remain highlighted in blue.

You’ll also need to find a special word called a spangram. This tells you what the words have in common. The spangram links at least two sides of the board, but it may not start or end there. While the theme words will not be a proper name, the spangram can be a proper name. When you find the spangram, it will remain highlighted in yellow.

Aurora Alert Why You Now Need To Pack A Bag For Sudden Solar Storms

Leak reveals an etf perfect storm could be heading toward bitcoin after $6 trillion fed inflation flip unleashed a crypto price boom, google chrome gets third emergency update in a week as attacks continue.

Every letter is used once in one of the theme words and spangram. You can connect letters vertically, horizontally and diagonally, and it’s possible to switch directions in the middle of a word. If you’re playing on a touchscreen, double tap the last letter to submit your guess.

If you find three valid words of at least four letters that are not part of the theme, you’ll unlock the Hint button. Clicking this will highlight the letters that make up one of the theme words.

Be warned: You’ll need to be on your toes. Sometimes you’ll need to fill the missing word(s) in a phrase. On other days, the game may revolve around synonyms or homophones. The difficulty will vary from day to day, and the puzzle creators will try to surprise you sometimes.

What Is Today’s Strands Hint?

Scroll slowly! Just after the hint for today’s Strands puzzle, I’ll reveal what the answer words are.

The official theme hint for today’s Strand puzzle is...

Need some extra help? Here’s another hint...

A perfect gift for a deliciously lazy dinner

There are six words to find today, including the spangram.

What Are Today’s Strands Answers?

Spoiler alert! Don’t scroll any further down the page until you’re ready to find out today’s Strands answers.

I’ll first tell you the spangram and show you where that is on the grid. I’ll then tell you the other words and show you how they fit in.

This is your final warning!

Today’s Strands spangram is...

CHARCUTERIE

Here’s where you’ll find it on the grid...

New York Times Strands screenshot, showing the highlighted term CHARCUTERIE.

The rest of today’s Strands theme words are...

Here’s what the completed grid looks like...

Completed Strands grid for May 14 featuring the words OLIVE, CHARCUTERIE, BRIE, SPREAD, SALAMI, ... [+] CRACKER, NUTS and FRUIT.

I needed a little help at the outset, so I found FARCE, FACE and RACE in the bottom right to unlock a hint. That gave me the letters for BRIE in the top right. That's when I spotted OLIVE in the top left, which made the spangram pretty obvious.

The spangram blocked off the letters for SALAMI on the right rail. From there, I found SPREAD on the left, FRUIT at the bottom and NUTS in between those. That left CRACKER for the win.

I used one hint and the spangram was the third theme word I found.

That’s all there is to it for today’s Strands clues and answers. Be sure to check my blog for hints and the solution for Wednesday’s game if you need them.

• Editorial Standards
• Reprints & Permissions

Join The Conversation

One Community. Many Voices. Create a free account to share your thoughts. 

Forbes Community Guidelines

Our community is about connecting people through open and thoughtful conversations. We want our readers to share their views and exchange ideas and facts in a safe space.

In order to do so, please follow the posting rules in our site's  Terms of Service.   We've summarized some of those key rules below. Simply put, keep it civil.

Your post will be rejected if we notice that it seems to contain:

• False or intentionally out-of-context or misleading information
• Insults, profanity, incoherent, obscene or inflammatory language or threats of any kind
• Attacks on the identity of other commenters or the article's author
• Content that otherwise violates our site's  terms.

User accounts will be blocked if we notice or believe that users are engaged in:

• Continuous attempts to re-post comments that have been previously moderated/rejected
• Racist, sexist, homophobic or other discriminatory comments
• Attempts or tactics that put the site security at risk
• Actions that otherwise violate our site's  terms.

So, how can you be a power user?

• Stay on topic and share your insights
• Feel free to be clear and thoughtful to get your point across
• ‘Like’ or ‘Dislike’ to show your point of view.
• Protect your community.
• Use the report tool to alert us when someone breaks the rules.

Thanks for reading our community guidelines. Please read the full list of posting rules found in our site's  Terms of Service.

• Solve equations and inequalities
• Simplify expressions
• Factor polynomials
• Graph equations and inequalities
• Advanced solvers
• All solvers
• Arithmetics
• Determinant
• Percentages
• Scientific Notation
• Inequalities

What can QuickMath do?

QuickMath will automatically answer the most common problems in algebra, equations and calculus faced by high-school and college students.

• The algebra section allows you to expand, factor or simplify virtually any expression you choose. It also has commands for splitting fractions into partial fractions, combining several fractions into one and cancelling common factors within a fraction.
• The equations section lets you solve an equation or system of equations. You can usually find the exact answer or, if necessary, a numerical answer to almost any accuracy you require.
• The inequalities section lets you solve an inequality or a system of inequalities for a single variable. You can also plot inequalities in two variables.
• The calculus section will carry out differentiation as well as definite and indefinite integration.
• The matrices section contains commands for the arithmetic manipulation of matrices.
• The graphs section contains commands for plotting equations and inequalities.
• The numbers section has a percentages command for explaining the most common types of percentage problems and a section for dealing with scientific notation.

Math Topics

More solvers.

• Add Fractions
• Simplify Fractions

Web publishers brace for carnage as Google adds AI answers

The tech giant is rolling out AI-generated answers that displace links to human-written websites, threatening millions of creators

Kimber Matherne’s thriving food blog draws millions of visitors each month searching for last-minute dinner ideas.

But the mother of three says decisions made at Google, more than 2,000 miles from her home in the Florida panhandle, are threatening her business. About 40 percent of visits to her blog, Easy Family Recipes , come through the search engine, which has for more than two decades served as the clearinghouse of the internet, sending users to hundreds of millions of websites each day.

Podcast episode

As the tech giant gears up for Google I/O, its annual developer conference, this week, creators like Matherne are worried about the expanding reach of its new search tool that incorporates artificial intelligence. The product, dubbed “Search Generative Experience,” or SGE, directly answers queries with complex, multi-paragraph replies that push links to other websites further down the page, where they’re less likely to be seen.

The shift stands to shake the very foundations of the web.

The rollout threatens the survival of the millions of creators and publishers who rely on the service for traffic. Some experts argue the addition of AI will boost the tech giant’s already tight grip on the internet, ultimately ushering in a system where information is provided by just a handful of large companies.

“Their goal is to make it as easy as possible for people to find the information they want,” Matherne said. “But if you cut out the people who are the lifeblood of creating that information — that have the real human connection to it — then that’s a disservice to the world.”

GET CAUGHT UP

70 years later, 1 in 3 Black people say integration didn’t help Black students

Journalists sue Chicago Tribune owner alleging pay discrimination

Abbott grants Daniel Perry pardon in murder of Black Lives Matter protester

NFL disavows Harrison Butker’s comments, cites commitment to inclusion

6 Airbnb red flags to spot before you make a booking mistake

Google calls its AI answers “overviews” but they often just paraphrase directly from websites. One search for how to fix a leaky toilet provided an AI answer with several tips, including tightening tank bolts. At the bottom of the answer, Google linked to The Spruce, a home improvement and gardening website owned by web publisher Dotdash Meredith, which also owns Investopedia and Travel + Leisure. Google’s AI tips lifted a phrase from The Spruce’s article word-for-word.

A spokesperson for Dotdash Meredith declined to comment.

The links Google provides are often half-covered, requiring a user to click to expand the box to see them all. It’s unclear which of the claims made by the AI come from which link.

Tech research firm Gartner predicts traffic to the web from search engines will fall 25 percent by 2026. Ross Hudgens, CEO of search engine optimization consultancy Siege Media, said he estimates at least a 10 to 20 percent hit, and more for some publishers. “Some people are going to just get bludgeoned,” he said.

Raptive, which provides digital media, audience and advertising services to about 5,000 websites, including Easy Family Recipes, estimates changes to search could result in about $2 billion in losses to creators — with some websites losing up to two-thirds of their traffic. Raptive arrived at these figures by analyzing thousands of keywords that feed into its network, and conducting a side-by-side comparison of traditional Google search and the pilot version of Google SGE.

Michael Sanchez, the co-founder and CEO of Raptive, says that the changes coming to Google could “deliver tremendous damage” to the internet as we know it. “What was already not a level playing field … could tip its way to where the open internet starts to become in danger of surviving for the long term,” he said.

When Google’s chief executive Sundar Pichai announced the broader rollout during an earnings call last month, he said the company is making the change in a “measured” way, while “also prioritizing traffic to websites and merchants.” Company executives have long argued that Google needs a healthy web to give people a reason to use its service, and doesn’t want to hurt publishers. A Google spokesperson declined to comment further.

“I think we got to see an incredible blossoming of the internet, we got to see something that was really open and freewheeling and wild and very exciting for the whole world,” said Selena Deckelmann, the chief product and technology officer for Wikimedia, the foundation that oversees Wikipedia.

“Now, we’re just in this moment where I think that the profits are driving people in a direction that I’m not sure makes a ton of sense,” Deckelmann said. “This is a moment to take stock of that and say, ‘What is the internet we actually want?’”

People who rely on the web to make a living are worried.

Jake Boly, a strength coach based in Austin, has spent three years building up his website of workout shoe reviews. But last year, his traffic from Google dropped 96 percent. Google still seems to find value in his work, citing his page on AI-generated answers about shoes. The problem is, people read Google’s summary and don’t visit his site anymore, Boly said.

“My content is good enough to scrape and summarize,” he said. “But it’s not good enough to show in your normal search results, which is how I make money and stay afloat.”

Google first said it would begin experimenting with generative AI in search last year, several months after OpenAI released ChatGPT. At the time, tech pundits speculated that AI chatbots could replace Google search as the place to find information. Satya Nadella, the CEO of Google’s biggest competitor, Microsoft, added an AI chatbot to his company’s search engine and in February 2023 goaded Google to “ come out and show that they can dance .”

The search giant started dancing. Though it had invented much of the AI technology enabling chatbots and had used it to power tools like Google Translate, it started putting generative AI tech into its other products. Google Docs, YouTube’s video-editing tools and the company’s voice assistant all got AI upgrades.

But search is Google’s most important product, accounting for about 57 percent of its $80 billion in revenue in the first quarter of this year. Over the years, search ads have been the cash cow Google needed to build its other businesses, like YouTube and cloud storage, and to stay competitive by buying up other companies .

Google has largely avoided AI answers for the moneymaking searches that host ads, said Andy Taylor, vice president of research at internet marketing firm Tinuiti.

When it does show an AI answer on “commercial” searches, it shows up below the row of advertisements. That could force websites to buy ads just to maintain their position at the top of search results.

Google has been testing the AI answers publicly for the past year, showing them to a small percentage of its billions of users as it tries to improve the technology.

Still, it routinely makes mistakes. A review by The Washington Post published in April found that Google’s AI answers were long-winded, sometimes misunderstood the question and made up fake answers.

The bar for success is high. While OpenAI’s ChatGPT is a novel product, consumers have spent years with Google and expect search results to be fast and accurate. The rush into generative AI might also run up against legal problems. The underlying tech behind OpenAI, Google, Meta and Microsoft’s AI was trained on millions of news articles, blog posts, e-books, recipes, social media comments and Wikipedia pages that were scraped from the internet without paying or asking permission of their original authors.

OpenAI and Microsoft have faced a string of lawsuits over alleged theft of copyrighted works .

“If journalists did that to each other, we’d call that plagiarism,” said Frank Pine, the executive editor of MediaNews Group, which publishes dozens of newspapers around the United States, including the Denver Post, San Jose Mercury News and the Boston Herald. Several of the company’s papers sued OpenAI and Microsoft in April, alleging the companies used its news articles to train their AI.

If news organizations let tech companies, including Google, use their content to make AI summaries without payment or permission, it would be “calamitous” for the journalism industry, Pine said. The change could have an even bigger effect on newspapers than the loss of their classifieds businesses in the mid-2000s or Meta’s more recent pivot away from promoting news to its users, he said.

The move to AI answers, and the centralization of the web into a few portals isn’t slowing down. OpenAI has signed deals with web publishers — including Dotdash Meredith — to show their content prominently in its chatbot.

Matherne, of Easy Family Recipes, says she’s bracing for the changes by investing in social media channels and email newsletters.

“The internet’s kind of a scary place right now,” Matherne said. “You don’t know what to expect.”

A previous version of this story said MediaNews Group sued OpenAI and Microsoft. In fact, it was several of the company's newspapers that sued the tech companies. This story has been corrected.