How to create bookmarks / anchor tags on Google Docs documents

Sometimes you want to link within a document so that when you click a link you leap to the relevant bit without having to scroll, this can easily be done in Google Docs using the Bookmark facility. On web pages it’s usually known as anchors.

The thing buried at the bottom of your document that you will bookmark is ‘the pointee’ and the link in your table of contents that points to it is ‘the pointer’. The pointer points to the pointee 🙂

Quick ‘tl;dr’ instructions

  1. Select your Pointee (the bit of area you want to point to), click Insert » Bookmark
  2. Select Pointer (text that will hyperlink to it), click Insert » Link and expand the Bookmarks section, to select your bookmark. Done!
  3. An example here: make a copy of this document to edit and try it yourself.

 

Detailed instructions with pictures

  1. Select the text of the Pointee. It could just be the first word in a heading or paragraph, or a full sentence.
    01 Select the Pointee
  2. From the menu at the top click Insert » Bookmark, it will then have a little blue flag next to it.
  3. Select the text of the Pointer. That could be a word or phrase in a table of contents, or any word or phrase that you want to make clickable so that clicking it takes the reader to the pointe04 Select the text of The Pointer
  4. Click Insert » Link, then expand the Bookmarks sections (it’ll have just one bookmark in it for now) and select the one you’ve previously created. Click Apply.
    05 Insert a Link
    06 Expand the Bookmarks
    07 Click Apply
  5. Go to your pointer, click on its new link, it will pop up a “where you’re going to be taken to” tiny window, click on the link again and off you go.
    08 Click the Pointer link
  6. Try it out yourself, make a copy of this document and edit it.

 

 

 

Google spreadsheets timestamp – US to UK date format settings

tl;dr
File » Spreadsheet settings
In Locale (in general tab) change to United Kingdom, adjust time settings if necessary

If you use Google Forms the chances are that your data will go to a Google Spreadsheet, which you can view at your leisure. Each time someone fills in the form a new record (row) is created in the spreadsheet and the time they did it is added in the timestamp column with the date.

Google defaults to American settings so will generally show US date format (month/day/year).

If you want to make it UK date format (day/month/year) do the following: Open the form, click on File, then Spreadsheet settings… then change ‘United States’ to ‘United Kingdom’ and click the blue Save settings button. The spreadsheet will refresh and the timestamps will now be UK style.

1. File / Spreadsheet settings…

Screen Shot 2016-03-06 at 23.30.50

2. Locale – change United States to United Kingdom, click Save settings.

Screen Shot 2016-03-06 at 23.31.08

3. What the setting looks like with United Kingdom (I got carried away taking screenshots).

Screen Shot 2016-03-06 at 23.31.24