Manage data

On this page

• Perform basic operations
• Search for data
• See changes to data
• Restrict data sharing
• Use keyboard shortcuts

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

Search for data

Excel: Find and select

Sheets: Find and replace

Excel 2013 Excel 2010

In Sheets, open a spreadsheet and click EditFind and replace. Next to Find, enter the text or numbers that you want to find. Next to Replace with, enter the new data. Next to Search, choose the sheets that you want to search. (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. Choose an option to replace the data: To replace instances one at a time, click FindReplace. To replace all instances, click Replace all.

See changes to data

Excel: Track changes	Sheets: Version history
Excel 2013   Excel 2010	Version history shows who made changes (and when) to a spreadsheet.  In Sheets, open the file. Click FileVersion historySee version history. Activity stream The Activity stream shows who commented, edited, moved, or shared a spreadsheet. Open Drive and single-click a spreadsheet to select it. At the top right, click View details . Click Activity.

Restrict data sharing

Sheets: Restrict sharing options

Use keyboard shortcuts

Sheets: See a complete list of shortcuts

For more details, see Keyboard shortcuts for Google Sheets.