JCPS Tech Contact Blog: spreadsheets

Friday Google Tidbit: Hyperlinks in Google Sheets

Brandy Whitley Friday Google Tidbit, Google Spreadsheets, hyperlinks, spreadsheets 5:00 PM

<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="color: #3b3b41; font-family: Arial; font-size: 19px; line-height: 21.8500003814697px; white-space: pre-wrap;">Hyperlinks in Google Sheets</span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="color: #3b3b41; font-family: Arial; font-size: 19px; line-height: 21.8500003814697px; white-space: pre-wrap;"><br /></span></div>
<h6 dir="ltr" style="line-height: 1; margin-bottom: 8pt; margin-left: -11pt; margin-right: -11pt; margin-top: 8pt; text-align: center;">
<span style="background-color: white; color: #3b3b41; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><img height="111px;" src="https://lh5.googleusercontent.com/KQaawOmNdXT4bRZ1JOlPvaWODQoBoDARoFufJkckst-d9VDEHxFJrt8Lisazl38uC7hFPRDD03IGGeFIxk-iozRXQ01M6DklwqpTg5s4yn-t4Ib-LEyy5ipYJFhhHKfJVg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="93px;" /></span></h6>
<b id="docs-internal-guid-aae54547-13a2-f700-de20-e29368dca14f" style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">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.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">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.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #6aa84f; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Method # 1</span><span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">-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.</span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br /></span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><img height="388px;" src="https://lh5.googleusercontent.com/YI6mBgGraRL0YTG24cLRWZCFBoSbww0dpKQQBd55dqX-eXipJrUc0gIHvDHAKMWTdKMFRj11K3lzTkd09kzTJvDSmePNkfawDzY_cSNAPoqcfGYWjDDTzbDXsfc63Br7gA" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="260px;" /></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #6aa84f; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Method # 2</span><span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">- 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.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><img height="64px;" src="https://lh4.googleusercontent.com/JJPqTPK0TWoe-6BYaioHRCzS8T1CZ26qRVpASKJzBYQZNK8qZOBx9qhuDMOqtNIoZZfOEzdc3kWIm07vBUdP4-Y39NwvUWrwEyuMjGFaYNBTjdazw_zynJtqGkagm80ZJw" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="624px;" /></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #6aa84f; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Method # 3</span><span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">- Use the keyboard shortcut: Ctrl k. Type or copy and paste the web address into the link box. Click “Apply” and it’s done.</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #333333; font-family: Arial; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><img height="107px;" src="https://lh3.googleusercontent.com/DApXF5ntWM3f1sYflWjtWBvUGvPEKRlaoH99lE-mow-K_XH-H25zaFybxrWdTUqBABu_gk68U4iUekL8jsPPbdtIZz7-tSXnWaYInghXrzgsvGPTRP4191gj_Zddcz9uhg" style="-webkit-transform: rotate(0.00rad); border: none; transform: rotate(0.00rad);" width="448px;" /></span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.4699999635869807; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #222222; font-family: Arial; font-size: 20px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Questions or comments?</span></div>
<div dir="ltr" style="line-height: 1.4699999635869807; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: white; color: #222222; font-family: Arial; font-size: 20px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Email me at brandywhitley@johnston.k12.nc.us</span></div>
<br />
<br />
<br />

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...

Friday Google Tidbit: Google Spreadsheets

Anonymous friday, Google, spreadsheets, tidbit 3:15 PM

<span style="font-family: inherit;">A new version of Google Sheets was released this week!  It's an exciting time for us!  What's different?</span><br />
<ul><li><span style="font-family: inherit;">It's faster</span></li>
<li><span style="font-family: inherit;"><span style="font-size: large;">larger </span>spreadsheets are supported - <i>millions</i> of cells</span></li>
<li><span style="font-family: inherit;">Text moves over to the next cell - no manual merging needed</span></li>
<li><span style="font-family: inherit;">Filter views - name, save, and share different views of <i>your </i>data (when collaborating)</span></li>
<li><span style="font-family: inherit;">Formulas and complex functions now have a formal help section...there is even error highlighting and coloring to spot mistakes</span></li>
<li><span style="font-family: inherit;">Improved conditional formatting</span></li>
<li><span style="font-family: inherit;">Spreadsheets can now now work offline just like Google Docs and Slides (Chrome browser only)</span></li>
</ul><span style="font-family: inherit;"></span><br />
<div style="text-align: center;"><span style="font-family: inherit;"><span style="font-family: inherit;">Check out it from </span><a href="http://googleblog.blogspot.com/2013/12/new-google-sheets-faster-more-powerful.html?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+blogspot%2FMKuf+%28Official+Google+Blog%29" style="font-family: inherit;" target="_blank">Google's Official Blog</a><span style="font-family: inherit;">!   </span></span></div><span style="font-family: inherit;"> </span> <span style="font-family: inherit;"><br />
</span> <span style="font-family: inherit;">Ready to try it out?  <span style="background-color: white; color: #444444; line-height: 14.399999618530273px;"> Sign into your Google account, and check the “Try the new Google Sheets” box in </span><a href="http://g.co/newsheets" style="background-color: white; color: #7759ae; line-height: 14.399999618530273px; text-decoration: none;">Google Drive settings</a><span style="background-color: white; color: #444444; line-height: 14.399999618530273px;">. From then on, all new spreadsheets you create will work offline and include these new features.  <i>Win!</i></span></span><br />
<span style="font-family: inherit;"><span style="background-color: white; color: #444444; line-height: 14.399999618530273px;"><br />
</span></span> <br />
<br />
<center><iframe allowfullscreen="" frameborder="0" height="370" src="//www.youtube.com/embed/9AyoRkr4I3U" width="580"></iframe><center></center></center>

Friday Google Tidbit: Google Spreadsheets

A new version of Google Sheets was released this week! It's an exciting time for us! What's different? It's faster larger sp...

Showing posts with label spreadsheets. Show all posts

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

Friday, December 13, 2013

Friday Google Tidbit: Google Spreadsheets

A new version of Google Sheets was released this week! It's an exciting time for us! What's different?

It's faster
larger spreadsheets are supported - millions of cells
Text moves over to the next cell - no manual merging needed
Filter views - name, save, and share different views of your data (when collaborating)
Formulas and complex functions now have a formal help section...there is even error highlighting and coloring to spot mistakes
Improved conditional formatting
Spreadsheets can now now work offline just like Google Docs and Slides (Chrome browser only)

Check out it from Google's Official Blog!

Ready to try it out? Sign into your Google account, and check the “Try the new Google Sheets” box in Google Drive settings. From then on, all new spreadsheets you create will work offline and include these new features. Win!

Subscribe to: Posts ( Atom )