Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Protecting Sheets and Ranges | Collaboration and Security
Google Spreadsheets
course content

Course Content

Google Spreadsheets

Google Spreadsheets

1. Introduction to Google Sheets
Why do you need Google Sheets?Creating Google SheetsOpening Google SheetsRenaming Google SheetsCopying Google SheetsDeleting Google SheetsMoving Google SheetsDownloading Google Sheets
2. Formatting of Cells and Ranges
Basic Editing OperationsFormatting DataFormatting TextFormatting BordersMerging Cells and Text AlignmentClear Formatting and Paint Format ToolsSelecting Cells and RangesAdjusting Column and Row Size and PositionCopying and Deleting Columns and Rows Freezing and Grouping Rows and Columns
3. Advanced Formatting of Cells
Splitting Text to ColumnsTrimming WhitespacesInserting Internal and External HyperlinksAutocompleting CellsCreating CheckboxesCreating FormsAdding NotesAdding ImagesCreating DrawingsChallenge: Mastering Event Planning ChallengeChallenge: Your Event, Your Plan
4. Sorting, Filtering and Cleaning Data
Find and ReplaceSorting RangeSearching Filter and Filter by ConditionCustom Filter ViewsConditional Formatting and Color Scale Using SlicersNamed Range Removing DuplicatesChallenge: Library Book List Management
5. Creating Charts
Line ChartBasic Chart SettingsChart Style and Chart and Axis TitlesLegend, Gridlines and TicksHorizontal and Vertical Axis CustomizationArea ChartColumns and Stacked ColumnsPie ChartChallenge: Data Visualization Sprint Sales Insights
6. Basic Functions
Basic CalculationsArithmetic Functions Statistical FunctionsRounding FunctionsWorking with Numbers and Integers Working with Roots and PowersRandom Number GenerationText Functions Working with Dates and TimeSort FunctionChallenge: Sales Visualization Trends and Analytics
7. Logical Functions
AND and OR FunctionsIF and Nested IF FunctionsIFS FunctionSUMIFS, COUNTIFS and AVERAGEIFSChallenge: Employee Performance and Payroll Analysis with Excel Functions
8. Collaboration and Security
Access Control and Real-Time Document CollaborationNotification Rules Chatting with Other UsersProtecting Sheets and RangesComments and Google Meet IntegrationVersion History and Data Recovery

book
Protecting Sheets and Ranges

Protecting Sheets

  • Select the range of cells you want to protect;
  • Go to Data → Protect sheets and ranges;
  • A settings panel will appear on the right side of the screen. Enter a description for the protection to make it easier to identify later;
  • Click Set permissions to configure who can edit the selected range;
  • In the permissions menu, choose who will have editing access:
    • Only you — only you can edit this range;
    • Custom — set specific permissions for other users;
  • Click Done to save the changes.

Protecting Ranges

  • To protect an entire sheet, go to Data → Protect sheets and ranges;
  • In the Sheet section, select the sheet you want to protect;
  • Click Set permissions and configure who can edit the sheet;
  • You can also specify exceptions, allowing edits to certain ranges within the protected sheet;
  • Click Done to enable protection.

Removing Protection

  • To remove protection, go to Data → Protect sheets and ranges;
  • In the right-hand panel, select an existing protection rule;
  • Click the trash icon to delete the protection or modify the permissions.
How do you protect a specific range of cells?

How do you protect a specific range of cells?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 8. Chapter 4
We're sorry to hear that something went wrong. What happened?
some-alt