Vertical merge, more paste options and more import/export support in Google Spreadsheets
September 23rd, 2011 | Published in Google Apps, Google Docs, Uncategorized
The following new features are now available in Google spreadsheets:
Vertical merge: The merge functionality has been extended to let you create vertical merges across several rows of data.
Paste options: Four new paste special options have been added including: paste all cell contents except borders, formulas only, data validation only, or conditional formatting only.
Import/Export support: You can now convert most pivot tables between Microsoft Excel files and Google spreadsheets.
Release track:
Rapid*: Vertical merge, Paste options
Rapid and Scheduled: Import/Export
Editions included:
Google Apps, Google Apps for Business, Government and Education
Languages included:
All languages supported by Google Spreadsheets
How to access what's new:
Vertical merge: Select the set of cells you’d like to merge, then click on the down arrow next to the merge icon, and select ‘Merge vertically’.
Paste options: These new options are in a list under “Paste Special” in the ‘Edit’ menu of Google spreadsheets.
Import/Export support: To import a pivot table you created in Microsoft Excel, click the ‘File’ menu in Google spreadsheets, and select ‘import’, then select the file from the import options, and click the ‘import’ button. If you’ve created a pivot table in Google spreadsheets, go to ‘File’ in the spreadsheet, then click ‘Download As’, and choose ‘Excel’.
For more information:
http://googledocs.blogspot.com/2011/09/this-week-in-docs-importexport-and.html
http://googledocs.blogspot.com/2011/09/merge-cells-vertically-in-google.html
*Rapid Release track: Domains with ‘Rapid release’ checkbox enabled in the administrator control panel. Learn more
New look on the way for Gmail, Calendar, Docs and Sites! Find out more at whatsnew.googleapps.com/new-look
whatsnew.googleapps.com
Get these product update alerts by email
Subscribe to the RSS feed of these updates
Vertical merge: The merge functionality has been extended to let you create vertical merges across several rows of data.
Paste options: Four new paste special options have been added including: paste all cell contents except borders, formulas only, data validation only, or conditional formatting only.
Import/Export support: You can now convert most pivot tables between Microsoft Excel files and Google spreadsheets.
Release track:
Rapid*: Vertical merge, Paste options
Rapid and Scheduled: Import/Export
Editions included:
Google Apps, Google Apps for Business, Government and Education
Languages included:
All languages supported by Google Spreadsheets
How to access what's new:
Vertical merge: Select the set of cells you’d like to merge, then click on the down arrow next to the merge icon, and select ‘Merge vertically’.
Paste options: These new options are in a list under “Paste Special” in the ‘Edit’ menu of Google spreadsheets.
Import/Export support: To import a pivot table you created in Microsoft Excel, click the ‘File’ menu in Google spreadsheets, and select ‘import’, then select the file from the import options, and click the ‘import’ button. If you’ve created a pivot table in Google spreadsheets, go to ‘File’ in the spreadsheet, then click ‘Download As’, and choose ‘Excel’.
For more information:
http://googledocs.blogspot.com/2011/09/this-week-in-docs-importexport-and.html
http://googledocs.blogspot.com/2011/09/merge-cells-vertically-in-google.html
*Rapid Release track: Domains with ‘Rapid release’ checkbox enabled in the administrator control panel. Learn more
New look on the way for Gmail, Calendar, Docs and Sites! Find out more at whatsnew.googleapps.com/new-look
whatsnew.googleapps.com
Get these product update alerts by email
Subscribe to the RSS feed of these updates