Some while ago in this post I discussed page numbering in Google Docs. Now, you can insert different headers and footers on the first page of their documents, which is useful when making a title page without headers or footers.
For those with a smartphone there are plenty of ways to sync your calendar and access other Google apps. There are still one or two Luddites like me though, who prefer an older-style mobile / cell phone to a smartphone; it’s usually smaller, with a longer battery life, it’s less likely to be stolen or broken and, even if that should happen, it’s a negligible cost to replace it.
Many of you will already know this trick, but here it is in case anyone missed it.
In a recent post I described how Google have extended the capabilities of range protection in spreadsheets. They’ve also made it possible to protect ranges in Google Apps Script by means of the new Protection class.
Usage is pretty straightforward, and code samples probably serve better than written description. Here’s how to protect a simple range:
// Protect range C1:G10 var ss = SpreadsheetApp.getActive(); var range = ss.getRange('C1:G10'); var protection = range.protect().setDescription('This is now a protected range');
The object stored in the variable I’ve called protection now represents my protected range, and I can manipulate it directly in code.
First want to set up who are the editors for it, starting with myself:
var me = Session.getEffectiveUser(); protection.addEditor(me);
This is a very simple little tip of which most people are already aware, but here it is anyway.
Google Chrome does its best to identify situations when you’ve highlighted something it can interpret as a URL, and gives you the chance to navigate to that location in a new browser tab.
In this previous post I discussed managing your Google Drive storage. With spring just (I hope) around the corner, now seems a good time to do a little spring cleaning.
Items you’ve deleted go into the Bin (I believe it’s called Trash in accounts set to US English) and their number can build up alarmingly over time. To see what’s in there, click on Bin in the Drive menu:
I posted a while ago about protecting sheets or ranges in Google Sheets. Google has improved the sheet and range protection in Sheets, to include the ability to protect a whole sheet except for a given range.
I find it a minor irritation that when I’m working in Gmail, and need to consult my contacts list, there’s no straightforward way to open it in a new browser tab. You can get to the Contacts item in the drop-down menu easily enough (as in the figure below) but right-clicking on the item doesn’t offer the option to open the page in a new browser or tab.