Google Apps:Copy sheets from one spreadsheet to another in the new spreadsheets editor

You now have the ability to copy a sheet from one spreadsheet to the other, when using the new version of Google spreadsheets.

Editions included:
Standard, Premier, Education, Team and Partner Editions

Languages included:
All languages supported by Google Docs

How to access what’s new:
1. When working on a spreadsheet, click on the sheet tab at the bottom of the page and select “Copy to…”.
2. In the pop-up dialog, you can search for the destination spreadsheet. You can choose any spreadsheet you own or have editing access to.
3. Once you’ve selected a spreadsheet, you can open it to find that the sheet has been copied.

For more information:

Google Apps:New ability to remove/include individual users from contact sharing

Administrators now have the ability to remove individual users from appearing in contact sharing when that option is enabled. Contact sharing is also sometimes referred to as the global address list.
How to access what’s new:
– In the Google Apps control panel, click the ‘Users and groups’ tab, then click on the individual user’s name to access the user’s settings.
– Under ‘Contact sharing’, disable/enable the checkbox to remove/include the user from appearing in contact sharing.
– If contact sharing is enabled, then the user’s contact information is shared by default.
– If contact sharing has not been enabled, then this new option will not be visible.

Note: The control panel needs to be the ‘Next generation’ version.

For more information:

Google Apps: Now reset sign-in User cookies from the control panel


Now Google Apps admins can reset the sign-in cookies for any user from the Google Apps control panel. This will log out a user from all current browser sessions and require new authentication the next time that user tries to initiate an browser session to log in to Google Apps.

Google Apps for Education to public schools

Growing up in the late seventies in Hell’s Kitchen in Manhattan, technology wasn’t really a part of my educational life. My teachers graded printouts and the idea of collaborating with my classmates on a project anytime, anywhere just wasn’t possible. Not to mention, we didn’t have a computer at home and working on the Internet was still a pipe dream for a middle schooler.

Things have changed since I was in middle school of course, and there are people working hard to bring technology into classrooms to help students learn and teachers teach. Today Oregon is taking a huge step in that direction — they’re the first state to open up Google Apps for Education to public schools throughout the state.

Starting today, the Oregon Department of Education will offer Google Apps to all the school districts in the state — helping teachers, staff and students use Gmail, Docs, Sites, Video, Groups and more within their elementary, middle and high schools. School funding has been hit hard over the past couple of years, and Oregon is no exception. This move is going to save the Department of Education $1.5 million per year — big bucks for a hurting budget.

With Google Apps, students in Oregon can build websites or email teachers about a project. Their documents and email will live online in the cloud — so they’ll be able to work from a classroom or a computer lab, at home or at the city (or county) library. And instead of just grading a paper at the end of the process, Oregonian teachers can help students with their docs in real time, coaching them along the way. It’s critical that students learn how to use the kind of productivity technology they’ll need throughout their lives, and Oregon is helping students across the state do just that.

It blows my mind to think about how far technology in the classroom has come since I was in school, and how far we still have to go to make sure kids in classrooms everywhere have access to these tech resources. Cloud computing tools like Google Apps are one way teachers, schools — and now a whole state — are addressing the issue. Oh, and alis volat propriis? That’s the Oregon motto. It means “she flies by her own wings” — makes perfect sense for a state heading to the cloud.

Posted by Jaime Casap, Google Apps Education Manager

Now Google Apps Sync for Microsoft Outlook and with new Global Address List functionality

Version 1.8 of the Google Apps Sync for Microsoft Outlook plugin has been released with the following new features:

– New sync-status interface. This new interface provides progress indicators for address book, contacts, calendar, and email
– Support for sharing read-only calendars
– The option to cancel import

We have also started updating users of Google Apps Sync for Microsoft Outlook with access to their domain’s Global Address List (GAL). This list contains, users, groups, and contacts uploaded through the shared contacts API. It will also include name, email address, and telephone number (support for additional data is in development). The GAL, which will be updated automatically, will also be searchable within Outlook and available offline. Users who had not previously configured a GAL will automatically receive the latest data. Please note any changes to the GAL itself can take up to 24hrs to be in effect.

This GAL supersedes the previous Global Address List functionality, which required that the domain admin deploy a static XML file to each user’s computer and configure a registry key. If domains wish to switch from their previous GAL to this new automatically generated and updated GAL, they may do so by removing the registry key they previously set, or setting a new registry key: HKEY_CURRENT_USER\Software\Google\Google Apps Sync\AddressBookSync
Value name: DynamicGal
Value data: 1
Value type: DWORD

Google Apps highlights this week – 4/16/2010

Today’s update includes a big batch of new functionality in Google Docs and several new capabilities in Gmail. So the next time you’re in Google Apps, give these new features a spin.

Google Docs reloaded

On Monday we released a preview of the new Google Docs, which brings added features, higher fidelity for imported documents, more speed and faster collaboration to our browser-based productivity tools. Documents sport features that weren’t feasible with older browser technology, like a new ruler for margins and tab stops, better bullets and numbered lists, easier image placement and character-by-character real-time collaboration in the browser. Spreadsheets now have a formula editing bar, drag-and-drop columns and cell auto-fill. They support up to 50 simultaneous collaborators, and are much faster and more responsive overall. We added Google drawings to the mix as well, so you can work with others to create flow-charts, schematics and other kinds of diagrams together in real-time.

Calendar integration in Gmail

To make it easier to schedule time with people without leaving your inbox, now you can see people’s availability (if you have permission) and send event invitations from Gmail. As you’re composing a message, click the “Insert: Invitation” link to choose a time that works for the recipients on your email and add details about your event. When you’re done, the email message will display details about your event.

Drag-and-drop attachments in Gmail

Yesterday we introduced a simpler way to add attachments in Gmail: just drag files onto Gmail from your desktop or from a folder as you compose a message. You can drag multiple files at once, and on a Mac, you can even drag files from folders in the Dock. This feature works in Chrome or Firefox 3.6+ right now, and other browsers may support this feature in the future.

Nested Labels and Message Sneak Peek in Gmail Labs

Last week we launched two new Labs features in Gmail. Nested Labels lets you create hierarchies of labels, giving you more flexibility how you organize your saved email. Message Sneak Peek lets you preview messages without having to open them. Just right-click a message in your inbox to sneak a quick peek.

Gmail on the Apple iPad

We released a new version of the Gmail web interface specially designed for the larger screen of the iPad. Gmail on the iPad has a convenient two-pane display with a list of your conversations on the left, and full messages on the right.

Who’s gone Google?
More and more colleges and universities are moving to the cloud with Google Apps. This week we’re pleased to welcome the University of Wisconsin at La Crosse, UNLV, Meredith College and Belmont Abbey College. The State Library of Kansas, the Mind Research Network and more than 50,000 other businesses and organizations have also gone Google in the last few weeks.

I hope you’re making the most of these new features, whether you’re using Google Apps with friends, family, coworkers or classmates. For more details and updates from the Apps team, head on over to the Google Apps Blog.

Posted by Jeremy Milo, Google Apps Marketing Manager

Google Apps Make 25 million people to be Google

Over the past year, we’ve highlighted companies around the world who have switched to Google Apps. And that means more than 25 million people have “gone Google”, including those at such globe-trotting organizations as Jaguar Land Rover and National Geographic. (You might have seen their Gone Google messages in print.)

Recently we visited one of our newest customers, Konica Minolta, to learn about why they decided to join us. Here’s their story:

For those considering a switch to Google Apps, this updated resources page offers a variety of info such as customer testimonials, white papers, links to webcasts and more. Be sure to visit the Google Enterprise Blog and visit, too.

If your company is already using Apps, join the Gone Google community. Put yourself on the map to share your experience and see who else has, yes, gone Google.

After you add yourself to the map, grab a laptop sticker that you can personalize. We’re giving them away free for a limited time*. More details here.

*And our lawyers ask us to tell you that the “giveaway offer is void where prohibited and valid only while supplies last” — so hurry!

Google Apps Migration for Microsoft Exchange a New Plug-in

There’s no question that Google is setting its sights on taking some of Microsoft’s marketshare in the productivity suite space. Last year, Google announced a new plug-in that syncs Google’s enterprise versions of Apps, including Gmail, contacts, and calendar, with Microsoft’s Outlook. And Google just acquired Docverse, an application lets users collaborate directly on Microsoft Office documents. Today Google is taking another swipe at Microsoft with a new tool that makes it significantly easier to make the switch over to Google Apps from Microsoft Exchange.

Google Apps Migration for Microsoft Exchange is a new server-side tool that migrates a company’s email, calendar and contact data from Microsoft Exchange, an email server software product from Microsoft, to Google Apps. Google promises ease with the tool, allowing IT administrators the ability to select the mail, calendar and contact data to move in phases and migrate hundreds of users at the same time. Plus, employees can use Exchange during the migration without any interruption. The tool works with Exchange 2033 and 2007 for both on-premise and hosted applications and is available to the enterprise and education versions of Google Apps.

This is clearly a play at showing businesses how simple it is to move from from Microsoft products, such as Exchange, that may not be hosted in the cloud to the cloud-based Google Apps product. Google product Manager Matt Glotzbach told me that the search giant wants to make it as simple as possible for potential customers to make the switch to Google Apps, and many potential Google Apps’ clients are using Microsoft Exchange to host and power email, calendar, and contacts. Google also launched Google Apps Migrator for Lotus Notes and a Connector for BlackBerry Enterprise Server.

Google Apps has steadily been growing; already 25 million people are using the Apps product. And that also includes over 2 million businesses ranging from startups, to small businesses, to Fortune 500 companies. And Google is developing a compelling ecosystem around Google Apps, recently launching the Google Apps Marketplace, which is an an app store for enterprise apps in the cloud.

by Leena Rao

Google To Link Gmail And Google Apps Accounts Coming soon


Many people (including myself) have come to the conclusion that Gmail, with its threaded messages, spam filtering, and vast storage space, is one of the web’s best webmail providers. In fact, we like it so much that we use it for both our personal accounts and work accounts using Google Apps. But that also poses a problem: many of us wind up having to maintain two separate Google accounts, which means we have to swap logins whenever our Gmail, Reader, or other data is stored under the other account. Fortunately, there may be an end in sight for this juggling act.

As today’s SXSW panel on Gmail came to a close, the panelists revealed one last juicy tidbit: they’re working to resolve the problems with multiple namespaces that users have to deal with. The team didn’t get specific — they simply repeated that they have to deal with the same problems, as they have “” accounts for work and standard Gmail accounts for personal use. And they know it’s a pain.

There’s no time frame, and we have no idea what form the feature will take. But at least we know Google is working on it.