Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Switch from Excel to Sheets

Manage data

Want to use Google apps at work or school?  Sign up for a Google Workspace trial

On this page

Perform basic operations


Most basic operations work the same way in Sheets and Microsoft Excel, such as:

  • Moving rows and columns
  • Adding or removing rows or columns
  • Adding functions (function names are the same)
  • Printing spreadsheets
  • Copying and pasting data

Highlight and move a row.

Search for data


Find and select

Find and replace

Find & Select option, with Replace highlighted in 2013 version.

Excel 2013

Replace option under Find & Select in 2010 version.

Excel 2010

  1. In Sheets, open a spreadsheet and click Editand thenFind and replace.

  2. Next to Find, enter the text or numbers that you want to find.
  3. Next to Replace with, enter the new data.
  4. Next to Search, choose the sheets that you want to search.
  5. (Optional) To refine your search, select additional options.
    You can make your search case-sensitive, find exact matches, use regular expressions, or search within formulas.
  6. Choose an option to replace the data:
    • To replace instances one at a time, click Findand thenReplace.
    • To replace all instances, click Replace all.

Find and replace appears under the File option in the menu.

See changes to data


Track changes

Version history

Track changes options, including "Highlight Changes," in 2013 version.

Excel 2013

Settings for track changes feature in 2010 version.

Excel 2010

Version history shows who made changes (and when) to a

  1. In Sheets, open the file.
  2. Click Fileand thenVersion historyand thenSee version history.

Activity stream

The Activity stream shows who commented, edited, moved, or
shared a spreadsheet.

  1. Open Drive and single-click a spreadsheet to select it.
  2. At the top right, click View details "".
  3. Click Activity.

Version history includes the date and time.

Restrict data sharing


Sheets: Restrict sharing options

  1. In a spreadsheet you own, click Share.
  2. Click Advanced.
  3. Check one or both of these boxes:
    • Prevent editors from changing access and adding new people
    • Disable options to download, print, and copy for commenters and viewers
  4. Click Save changes.
  5. Click Done.

Sheet with various settings limited for different people.

Use keyboard shortcuts


Sheets: See a complete list of shortcuts

  1. Open Sheets.
  2. For Windows and Chrome OS, press Ctrl+/.
  3. For Mac, press ⌘+/.

For more details, see Keyboard shortcuts for Google Sheets.

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?
How can we improve it?
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.

Important: This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.

Clear search
Close search
Google apps
Main menu
Search Help Center