Create a web base timeline that is easy to use in various projects, easy view and read, and easy to make in the comfort of your Google Dr...
Powered by Blogger.
Friday Google Tidbit: Hyperlinks in Google Sheets
Hyperlinks in Google Sheets Creating a hyperlink in Google Sheets used to mean editing a complicated formula. Not anymore! There ar...
Showing posts with label Google Spreadsheets. Show all posts
Showing posts with label Google Spreadsheets. Show all posts
Wednesday, March 18, 2015
Wednesday Webtool: Timeline JS
Create a web base timeline that is easy to use in various projects, easy view and read, and easy to make in the comfort of your Google Drive.
To get started go to the Timeline JS website: timeline.knightlab.com/#. Make sure you are logged into your Google account and download the TimelineJS Template.
Enter the desired information for each event that will be added to the timeline. Each row is a different event. The only REQUIRED columns on this template are column 1 and column 3 (Start date and Headline), however, the other columns add additional features and details to the timeline.
Add an image url to the Media column to include a picture for the event. The Media Credit and Caption columns add information about the picture.
Once all the information is entered into the Google Spreadsheet, publish the spreadsheet:
Click on File
Select “Publish to the Web”
Check “Automatically republish when changes are made.” (this should be the only thing checked)
Click “start publishing”
Copy the URL
Go back to the Timeline JS website and paste the spreadsheet’s URL in the generator box.
Scroll down to the Embed/Preview/Link to Preview buttons.
Here you can preview, get a link or get the embed code for the timeline. Save the link to view at anytime or embed the timeline on your webpage.
Questions or comments?
Email me at brandywhitley@johnston.k12.nc.us
Labels:
Google Drive
,
Google Spreadsheets
,
timeline
,
Wednesday web tool
Friday, January 23, 2015
Friday Google Tidbit: Hyperlinks in Google Sheets
Hyperlinks in Google Sheets
Creating a hyperlink in Google Sheets used to mean editing a complicated formula. Not anymore! There are 3 easy ways to insert links into Google Spreadsheets.
To get started, open Google Spreadsheet and click on the desired cell and type the text to be hyperlinked. Choose one of the following methods.
Method # 1-Right click the cell and select insert link. Type or copy and paste the web address into the link box. Click “Apply” and it’s done.
Method # 2- Click on the hyperlink icon in the menu. Type or copy and paste the web address into the link box. Click “Apply” and it’s done.
Method # 3- Use the keyboard shortcut: Ctrl k. Type or copy and paste the web address into the link box. Click “Apply” and it’s done.
Questions or comments?
Email me at brandywhitley@johnston.k12.nc.us
Labels:
Friday Google Tidbit
,
Google Spreadsheets
,
hyperlinks
,
spreadsheets
Subscribe to:
Posts
(
Atom
)