Switching to Sheets from Microsoft Excel

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

Highlight and move a row

3.2 Search for data

" "

Excel:
Find and select

Sheets:
Find and replace

Find & Select option, with Replace highlighted in 2013 version

Sheets 2013

Replace option under Find & Select in 2010 version

 

Sheets 2010

  1. In Sheets, open the file and click Editand thenFind and replace.

  2. Enter the word you want to find.
  3. (Optional) To replace the word, enter the new word.
  4. (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).
  5. Click Find, Replace, or Replace All.

 

Find and replace appears under the File option in the menu

3.3 See changes to data

" "

Excel:
Track changes

Sheets:
Version history

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

Sheets 2013
 

Settings for track changes feature in 2010 version

Sheets 2010

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

  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 Information.
  3. Click Activity.

Version history includes the date and time

3.4 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

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.

 

Was this helpful?
How can we improve it?