April 2008
Intermediate to advanced
384 pages
15h 52m
English
Content preview from Google Apps Hacks
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
70 GOOGLE APPS HACKS
HaCK 26:
Google Spreadsheets is smart enough to nish lists of information
for you, and can even go beyond what Excel or OpenOfce.org can do.
It’s not unusual to nd lists of related values in a a spreadsheet. For instance, you may come across
a list of weekdays. To ll out such a list, you can start by typing the rst three:
Sunday
Monday
Tuesday
You can automatically grow the list to include the other weekdays. You might have encountered this
feature (auto-ll) in Microsoft Excel. Select your list cells, and then drag the handle in the bottom-
right corner down over empty cells. Thanks to this feature, your list now reads:
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Monday
Tuesday
...
This trick works with other sequential list data too, like 1, 2, 3 or A, B, C and more. When Google
Spreadsheets is not able to continue the list data, it will just repeat the existing data in a loop for the
repeated cells.
You can even grow arbitrary lists with a different feature: Magic-Fill. Open a new spreadsheet and
type the following superhero names into the cells:
Batman
Superman
Wonder Woman
Expanding this list as usual will just repeat the list. But here’s a trick: instead of just dragging the handle
in the bottom-right corner down, as shown in Figure 3-22, this time hold down the Control key (Option
on ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.