Shared Spreadsheet Tip

EdTech Books by Alice Keeler

  • Student Engagement
  • Google Classroom
  • Student Centered Classrooms
  • Google Apps for Littles
  • Math and Google Apps
  • Ditch That Homework
Shared Spreadsheet Tip

edit

I like sharing my spreadsheets as “anyone can edit” or allow specific people to edit the spreadsheet. The problem with sharing a spreadsheet is the potential for your cells to accidentally be deleted. Currently the new Google Spreadsheets do not allow you to protect cells. That feature is coming, but in the meantime…

Careful Placement

I try to write a lot of my formulas far on the fringes of the spreadsheet. Assume the average user will initially see the first maybe 15 columns and 50 rows. If you have cells that you want to put default information or formulas into, try using cells outside of that range. If users have to scroll in order to accidentally delete or change your information they are less likely to.

Hide Rows and Columns

If you right click on a row or column indicator there is the option to hide the row or column. hide row

Duplicate and Hide the Tab

After writing directions and formulas, click on the tab and choose to duplicate the tab. Click on the copied tab to choose to hide the sheet. If a user accidentally messes up your formulas you can find the hidden sheet and copy and paste the formula back without too much fuss. duplicate and hide sheet

1 thought on “Shared Spreadsheet Tip”

Leave a Comment

© 2025 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.