
An unofficial blog that watches Google's attempts to move your operating system online since 2005. Not affiliated with Google.

Send your tips to gostips@gmail.com.

March 14, 2009

How to Sort Tables in Google Docs

The word processor from Google Docs lacks a sorting feature for tables, but Firefox users can try an extension that adds the missing feature. Install TableTools, the best extension for managing tables, restart the browser and open the document that includes tables.

To use the extension, you need to right-click on the table and select one of the available options: sorting, filtering, copying data as tab-delimited text or as HTML. Google Docs replaces Firefox's contextual menu, so it's necessary to press Shift + Right-click in order to bring back the original menu. Select from the menu "Sort table column as" and choose the appropriate data type.


If you want to copy a table from Google Docs to Google Spreadsheets, select the cells, choose from the contextual menu: "Other table operations < Copy as tab-delimited text", and paste the text in a spreadsheet using Ctrl+V. Unfortunately, the filtering feature from TableTools doesn't work in a rich-text editor, but it's very useful if you visit a web page that includes long tables.
 
{"cc_re__cc_re__cc_by_3_0": ["ain to be the same height-->\n<div class='clear'>\n            &#160;\n          </div>\n</div>\n<!-- end content-wrapper -->\n<div id='footer-wrapper'>\n<div class='footer section' id='footer'><div class='widget HTML' data-version='1' id='HTML3'>\n<div class='widget-content'>\n<div style=\"text-align:center\"><a href=\"http://googlesystem.blogspot.com\">Google Operating System Blog</a> is not affiliated with Google&trade;. <a href=\"http://googlesystem.blogspot.com/p/privacy-policy.html\">Privacy policy</a>. <a rel=\"license\" href=\"http://creativecommons.org/licenses/by/3.0/\">Some rights reserved</a>.</div>\n\n<!-- /Creative Commons License -->\n\n<!--\n<rdf:RDF xmlns=\"http://creativecommons.org/ns#\"\n    xmlns:dc=\"http://purl.org/dc/elements/1.1/\"\n    xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\n<Work rdf:about=\"\">\n<license rdf:resource=\"http://creativecommons.org/licenses/by/3.0/\" />\n</Work>\n\n<License rdf:about=\"http://creativecommons.org/licenses/by/3.0/\">\n   <requires rdf:resource=\"http://creativecommons.org/ns#Attribution\" />\n   <permits rdf:resource=\"http"]}