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:
|
Sheets:
|
---|---|
Excel 2013 Excel 2010 |
|
See changes to data
Excel:
|
Sheets:
|
---|---|
Excel 2013 Excel 2010 |
Version history shows who made changes (and when) to a
Activity streamThe Activity stream shows who commented, edited, moved, or
|
Restrict data sharing
Sheets: Restrict sharing options
- In a spreadsheet you own, click Share.
- Click Advanced.
- 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
- Click Save changes.
- Click Done.
Use keyboard shortcuts
Sheets: See a complete list of shortcuts
- Open Sheets.
- For Windows and Chrome OS, press Ctrl+/.
- 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.