Hidden gridlines in Google Spreadsheets

The following feature is now available for domains with ‘enable pre-release features’ checkbox enabled in the Administrator Control Panel:

The highly requested feature to hide gridlines in spreadsheets is now available

When editing a spreadsheet, under the ‘View’ menu, click on ‘Hide gridlines’ for each sheet, leaving only the borders that have been put there.

New revision history interface in Google Spreadsheets

The newer revision history interface in Google Documents is now also available in Spreadsheets. You can now see all of the changes that collaborators have made cell-by-cell.

How to access what’s new:
– To see the new interface, go to ‘File’, then ‘See revision history’ when editing a spreadsheet.
– Click on a time stamp in the right column to see what changes were made at a given time or use the arrow keys to quickly scan through many revisions.
– Changes are color-coded based on each collaborator, making it easy to tell what has been added or deleted.
– Time stamps are also improved in the new interface.
– The interface also batches revisions into groups of changes to make it easier to understand how a spreadsheet has changed over time. To see a finer-grained list of revisions, click ‘Show more detailed revisions’.

For more information:

New Charts Editor in Google Spreadsheets

Google Spreadsheets has a new editor for charts. The editor recommends charts, lets you select colors and has a bigger preview pane.

Charts look much better and you can now add timelines, organizational charts, gauges, and motion charts without using gadgets. Here are some of the new charts.

What’s not so great is that you have to manually update each chart to see the new features:

Now that we have a new version of charts, you may be wondering what will happen to your old charts. You’ll be able to edit your old charts for a short time, but you’ll be able to create charts using the new version only. In the long term, you can keep your old charts as view-only or you can upgrade your charts to be able to edit them. When you upgrade, your data and chart type will remain the same, but the look and feel of your chart will be improved.

That’s cumbersome and completely unnecessary.

More Options for Importing Files into Google Spreadsheets

Google Spreadsheets improved the feature that lets you import files. After uploading a file, you can preview it, select a separator character and choose where to put the data. You can create a new spreadsheet, insert a new sheet, replace the spreadsheet or only the current sheet, append the data to the current sheet or replace the data starting from the selected cell.

You can’t select multiple delimiters, exclude certain columns or pick the data format before importing the file. These features are available in Microsoft Excel and, even though some them aren’t necessary, they make it easier to properly import the data you need.

{ Thanks, Cougar Abogado. }

In-cell dropdown and data validation now in Google Spreadsheets

Google have introduced in-cell dropdown and validation to spreadsheets. This makes it easy to constrain the values of an individual cell to a specific range or list.

How to access what’s new:
1. Enter data into a range of cells. For example, create a list of destinations on your spreadsheet.
2. Select the cell(s) you would like to validate.
3. Under the Tools menu, select Data validation…
4. Change the Criteria to ‘Items from a list.’
5. Click the button next to the ‘Create list from range’ option and select the range of cells you entered data in during Step 1.
6. Click Save and the cell you chose to validate will have a dropdown arrow in it with the data in your cell range as the potential input values. If you want, you can set a cell to allow invalid data.

Easily see all formulas at once in Google Spreadsheets

Now introduced the ability to reveal all formulas with one click

How to access what’s new:
When editing a spreadsheet you can enable this view in three ways: Select the ‘Show All Formulas’ button on the top right; Select ‘Show All Formulas’ in the View menu; Click Ctrl ‘ (Cmd ‘ on a Mac.)

For more information:

Check spelling in Google Spreadsheets

You can now check your spelling in spreadsheets. The tool will go through all the cells on your sheet, highlighting each cell which has a misspelled word in red. Words that might be misspelled in each cell are underlined in red and can be changed by clicking on them and selecting the right spelling.

How to access what’s new:
When editing a spreadsheet, select ‘Tools’, then ‘Check spelling’ to check your sheet. Click ‘Next’ to go to the next cell and once all the cells on one sheet have been checked, you can continue to the next sheet.

For more information:

Google Spreadsheets Adds Format Painter

Google Spreadsheets added a feature that lets you copy the formatting a cell and use it for other cells. It’s called “format painter”, like the similar feature from Microsoft Office.

To use the format painter, select a cell that has special formatting, click on the “paint format” button from the toolbar and then select one or more cell to apply the formatting.

Microsoft offers an example to show why this feature is useful:

“Say you’ve written a report in Word. You like the look, especially your headings, which are 14 pt. Bookman Old Style, centered, green, and bold, with a nice subtle shadow. Fifteen minutes before you’re supposed to present the report to the team, your manager asks you to add four new sections to the report. You spend thirteen minutes adding the information, and the next two wishing that you hadn’t chosen such complicated formatting for your headings, since you now have to apply it to all the new ones. Using Format Painter saves you that time and duplicated effort. Instead of having to manually apply the font, font effects, centered paragraph alignment, and other formatting to each new section heading, you can quickly copy all of the formatting attributes by using one toolbar button.”

Unfortunately, format painter is not available in all Google Docs applications and you can only use it in Google Spreadsheets. So much for the Google Docs consistency.

{ Thanks, Cougar Abogado. }

Google Docs: Format painter and GoogleLookup function now in the new Google Spreadsheets editor

– Format painter allows you to apply the same formatting to other elements more easily.
– GoogleLookup function attempts to find the values for straightforward facts about specific things.

Format Painter: Apply the formatting that you want to a particular cell/column/row. Click the paintbrush icon to use the format painter, then click your desired cell/column/row to apply the exact same formatting.

GoogleLookup: Enter this formula syntax in the desired cell: =GoogleLookup(“entity”; “attribute”) where “entity” represents the name of the entity that you want to access, like Kuala Lumpur, Audrey Hepburn, or oxygen, and “attribute” is the type of information that you want to retrieve. An example would be =GoogleLookup(“Ireland”; “internet users”)

Google Spreadsheets : Edit form responses after you submit them in Google Spreadsheets

If the creator of a form has enabled it, you can now edit your response to a form after you’ve submitted it.

– The creator of the form needs to enable the new checkbox ‘Allow users to edit responses’ to allow respondents to edit their responses after they’ve submitted the form.
– If your username is being collected by the form and you check the ‘Send me a copy of my responses’ option, then there will be a link to change your responses in the confirmation email that you receive.
– You can also edit your responses on the form submission confirmation page. On the confirmation page, click the ‘Edit your response’ link.

For more information: