You now have the ability to copy a sheet from one spreadsheet to the other, when using the new version of Google spreadsheets.
Standard, Premier, Education, Team and Partner Editions
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:
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.
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.
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
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
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.
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
Smart Rescheduler Lab in Google Calendar
If you’ve ever tried to schedule time with a group of people who have packed agendas, you know how hard it can be to find a good meeting time that works for everyone. With the Smart Rescheduler, Google Calendar can sift through the details for you. When you need to reschedule an appointment, Smart Rescheduler quickly compares people’s calendars and ranks potential meeting times based on criteria like attendees, schedule complexity, conference rooms, and time zones. You can enable Smart Rescheduler by going to “Labs” under “Settings” in Google Calendar.
Suspicious account activity alerts
To help keep Gmail users and the data in their accounts safer, on Wednesday we launched a new security feature to alert you if our systems detect suspicious activity in your account. When something unusual is identified, you’ll see a warning notification near the top of your inbox. You can choose to view a log of recent activity, and if it looks like your account has been compromised, you can change your password immediately. (And while we’re on the topic of security, we encourage you to brush up on our tips to keep your account safer.) We know that security is also a top priority for businesses and schools, and we plan to bring this feature to Google Apps customers once we have gathered and incorporated their feedback.
Businesses using Google Apps can use a feature called email delegation, which lets employees appoint delegates who are allowed to read, send and manage email on their behalf. For example, this allows executive assistants to handle email for their managers. As of last Monday, delegates can also access and manage contacts. Now, a delegate can pick contacts from the manager’s contact list when composing a message on behalf of the manager, and keep the manager’s contacts up-to-date.
Google Apps Migration for Microsoft® Exchange
Millions of companies and schools have switched to Google Apps, and we hope to help millions more “go Google” in the near future. To make the transition as smooth as possible, we’ve released Google Apps Migration for Microsoft® Exchange, a server-to-server migration utility that brings email, contacts and calendar data from a legacy Microsoft® Exchange system to Google Apps. This makes the transition more seamless for employees, faculty and students. When they sign in to Google Apps, they’ll see the messages, contact information and calendar appointments from the old system right in Gmail and Google Calendar.
Who’s gone Google?
The number of businesses and other organizations using Google Apps continues to shoot up, and we hit another big milestone by crossing the 25 million user mark. Among those are the 7,000 employees at Konica Minolta, who are using Google Apps to help the company move fast and be more productive.
We’re excited to welcome another string of schools and universities too, including the University of Arkansas at Little Rock and the College of William and Mary. Marshall University has a particularly great story: their technology group challenged themselves to deploy Google Apps to over 50,000 students in less than 24 hours – quite a feat when it typically takes large organizations months or even years to make major technology changes. We hope Marshall’s nimble approach inspires others to make the switch!
I hope you’re enjoying the latest round of new features, whether you’re using Google Apps with friends and family, with colleagues or with classmates. And don’t forget, you can always check the Google Apps Blog for more details and the latest news in this area.
Posted by Jeremy Milo, Google Apps Marketing Manager
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:
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.
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 “@google.com” 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.