Google Sheets

Sheets Tips

Below you will find the latest hints and tips for Google Sheets. Our tips are carefully categorised so whether you are a beginner, advanced user or an administrator you will find something of interest. Use the Filters to find what you are looking for or scroll down to browse through all our tips. If you have a tip you’d like to share, use our Suggest a Tip form.

Google Sheets

Split text to columns in Google Sheets


This neat feature lets you simply convert text to columns in Google Sheets.
By: Kate | Posted On: October 17th, 2016 |

Gain insights in sheets data via Explore


The Explore function in sheets magically turns the data in your Google Sheets into charts and analysis
By: Kate | Posted On: August 2nd, 2016 |

Open a Sheet on a specific tab


With this simple tip you can open a Sheet on a specific tab using a unique URL of an individual worksheet
open a sheet.fw
By: Kate | Posted On: May 26th, 2016 |

Automatically add colourful stripes in your Google Sheets


Turn on colourful rows or columns via this neat Conditional Formatting trick
By: Kate | Posted On: April 27th, 2016 |

Turn your Data into a Heat Map


How to turn your data set into a heat map with this simple tip
Sheets Conditional Formatting Scales
By: Kate | Posted On: April 8th, 2015 |

Bring some SPARKLINE sparkle to your Google Sheet


Try SPARKLINE for Sheets: miniature charts in a single cell
By: Kate | Posted On: December 12th, 2014 |

How to use Spell Check in Google Sheets


Say goodbye to spelling mistakes in Google Sheets with the new Spell Check feature
Spell Check
By: Kate | Posted On: October 17th, 2014 |

Turn on Spreadsheet Notifications


Use Tools > Notifications rules to get notified by email when someone changes the spreadsheet.
Set Sheet Notifications
By: Mark | Posted On: July 9th, 2014 | 2 Comments

Spreadsheet Locale Setting


Change Locale in File > Spreadsheet Settings to ensure correct date format, currency and number format
By: Mark | Posted On: July 9th, 2014 | 13 Comments

Managing data in spreadsheet with the help of List View


The List View option provides a minimalistic view of your spreadsheet data. It's particularly useful for those that have viewing rights only, but have a great amount of data to manage. If you're trying to access a spreadsheet with more than 50 users currently viewing it, you'll be automatically redirected to list view.
By: Mark | Posted On: July 9th, 2014 |

Google Spreadsheet limitations


Spreadsheets is good for most uses, and converts very well from Excel, but it does have some limitations.
By: Mark | Posted On: July 9th, 2014 | 2 Comments

Try out new Google Sheets

The new version of Google Sheets is currently on the Rapid Release track only but will be available to everyone by the end of April 2014, if you haven't tried it yet, use this tip.
By: Mark | Posted On: March 28th, 2014 |

How to transpose data in a Google spreadsheet

Categories: ,

Excel has a useful transpose feature when copying and pasting. Here's a tip to do the same in a Google spreadsheet.
By: Mark | Posted On: September 20th, 2012 | 5 Comments

Protect individual cells in Google Spreadsheets


Individual cells or a cell range can be protected in Google Spreadsheets with this tip.
By: Mark | Posted On: August 30th, 2012 | 6 Comments

3 ways to protect your Google Spreadsheet data


Protect your Google Spreadsheet data from accidental or malicious changes with these 3 methods.
By: Mark | Posted On: May 1st, 2012 | 6 Comments

Hide rows and columns in a Google Spreadsheet


To hide a row or column in a Google Spreadsheet, right click the row number or column letter and choose the hide option.
By: Mark | Posted On: March 27th, 2012 | 3 Comments

Fill Google Spreadsheets with series of values


As with Excel, a Google spreadsheet can have automatically fill a series of cells - e.g. months of the year, sequential numbers, football teams and almost anything else!
By: Mark | Posted On: March 7th, 2012 |
Add New Tip

Suggest a Tip

What tip would you like to share with the world? Please follow the link

Add New Tip