The best Google Sheets tips and shortcuts

Follow these tips and tricks to get the most out of Google Sheets


When it comes to spreadsheets, a lot of business users are evangelical about Microsoft Excel and it's easy to see why. It comfortably remains the go-to application for any business with more complex data handling needs.

In terms of users Microsoft still flattens its competition but an increasing number of businesses are testing out the G-Suite to take advantage of its real-time collaboration features and unbeatable usability. (For a fuller analysis, see our full review of Google Sheets vs Microsoft Excel.)

For all the G-Suite users out there, we run through all of the most interesting things you can do with the application, as well as the best tips and tricks for getting the most out of Google Sheets.

Additional reporting by Laurie Clarke 

Read next: How to use Google Analytics effectively