Gooru Tip - Maximize the video player and adjust video quality for optimal viewing!
Named ranges, a recent update for Google Spreadsheets, allow you to use a range throughout different sheets, formulas etc. and then update that range from one location. It’s a very powerful feature that brings Google Spreadsheets closer to replacing Excel, in my opinion.
If you haven’t watched my video about Protected Ranges in Google Spreadsheets, definitely check that one out as well.
Loading ...
once again great video today and yesterdays please dont stop!
I want to create a master spreadsheet in google and have 14 separate sheets feed into it. All documents need to be able to be edited with results showing up on both master and seperte sheet. Is this possible? If so, how do I do it? Thanks for your help!
How come when I click name range the panel does not appear?
Tod,
Are you sure you clicked on “Data” and then selected “named and protected ranges?” Im not sure why the panel wouldn’t appear, but if this is still not working for you, email me and maybe I can figure out what the problem is.