3. Manage data in Sheets

In this section: 3.1 Perform basic operations 3.2 Search for data 3.3 See changes to data 3.4 Restrict data sharing 3.5 Use keyboard shortcuts

3.1 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

3.2 Search for data

Excel: Find and select	Sheets: Find and replace
Excel 2013   Excel 2010	In Sheets, open the file and click EditFind and replace. Enter the word that you want to find. (Optional) To replace the word, enter the new word. (Optional) To narrow your search, specify: Where to search (all sheets, this sheet, a specific range). How to search (match case, match the entire cell, use regular expressions or search in formulas). Click Find, Replace or Replace all.

3.3 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.

3.4 Restrict data sharing

Sheets: Restrict sharing options

1. In a spreadsheet that you own, click Share.
2. Click Advanced.
3. Tick 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.

3.5 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.}