Showing posts with label Google Spreadsheets. Show all posts
Showing posts with label Google Spreadsheets. Show all posts

Thursday, 22 June 2017

Google Tip: Saving a file to two or more folders

Has there been a time when you have wanted to save the same file to more than one folder and for it to be simultaneously updated at the same time?


  1. Go to Drive
  2. Click on file to be saved in other folders
  3. Press Shift - Z



Tuesday, 1 July 2014

Pull Data from Spreadsheets

Marama from Clevedon School came up with a great idea of creating a spreadsheet where each sheet has individual student's assessment data. She then wanted to share each student's sheet to them. With normal sharing options you can not share just one sheet, sharing allows you to share the whole spreadsheet. This poses a problem, as she doesn't want the other students or parents to see each others results. There is a hide option in Google Spreadsheets where you can hide the sheets you don't want others to see, but anybody could un-hide them if they are spreadsheet savvy. After a little research  we found an old solution that didn't work but it gave us a basis to work from

You may need change permissions on your original class doc to 'Anyone with this link'.