{"id":988,"date":"2021-04-07T15:01:36","date_gmt":"2021-04-07T20:01:36","guid":{"rendered":"https:\/\/www.onlc.com\/blog\/?p=988"},"modified":"2022-07-01T14:07:21","modified_gmt":"2022-07-01T19:07:21","slug":"10-google-sheets-tips-tricks-to-make-life-easier","status":"publish","type":"post","link":"https:\/\/www.onlc.com\/blog\/10-google-sheets-tips-tricks-to-make-life-easier\/","title":{"rendered":"10 Google Sheets Tips & Tricks To Make Life Easier"},"content":{"rendered":"

Google Sheets is the Google Answer to Microsoft Excel and continues to grow in popularity. While some may think of it as “Excel online,” Google Sheets is a very different product. Regular Excel users might find themselves puzzled by the Google Sheets navigation and not know the platform’s full potential.\u00a0<\/span><\/p>\n

Whether you’re a daily Google Sheets user or diving in for the first time, these tips and tricks can help make your time in online spreadsheet land a little more efficient.\u00a0\u00a0<\/span><\/p>\n

\u00a01. Conditional Formatting\u00a0<\/b><\/h2>\n

Google Sheets conditional formatting and color scale functions are different from Excel but let you accomplish the same outcome. Rather than being part of the main ribbon, you can find the conditional formatting option in Google Sheets under the Format > Conditional Formatting. Learn more about Conditional Formatting in Google Sheets <\/span>here.<\/span><\/a>\u00a0\u00a0\u00a0<\/span><\/p>\n

2.\u00a0 Drop Down Lists and Data Validation\u00a0<\/b><\/h2>\n

Data validation allows you to restrict the values that are entered into a particular cell. Using data validation in your Google spreadsheet lets you create drop-down lists within cells. You can learn more about data validation and drop-down lists <\/span>here<\/span><\/a>.\u00a0\u00a0\u00a0<\/span><\/p>\n

3. Keyboard Shortcuts\u00a0<\/b><\/h2>\n

Like most Microsoft products, there are keyboard shorts in your Google spreadsheets. These can save you a ton of time once you’ve got them down. These keyword shortcuts will let you quickly execute tasks like formatting cells, navigating the spreadsheet, adding new sheets, editing notes and comments, adding formulas, and more. You can find a complete list of Google Sheets keyword shortcuts for Mac and PC <\/span>here.<\/span><\/a>\u00a0\u00a0<\/span><\/p>\n

4. Google Translate\u00a0<\/b><\/h2>\n

If you have cells in different languages, Google Sheets can translate them for you directly in the spreadsheet. You can add =GOOGLETRANSLATE(cell) to any cell of the spreadsheet to automatically translate it. Learn more about Google Translate in your spreadsheet <\/span>here<\/span><\/a>.\u00a0\u00a0<\/span><\/p>\n

5. Check for Valid Email Address Formats\u00a0<\/b><\/h2>\n

If you’re using Google Sheets to collect or send a list of contacts, being able to quickly check that all emails are in the correct format and not listed as “.con” or missing other parts can save hours down the line. Google Sheets has an ISEMAIL function that lets you check if any cell is the correct format for an email with the formula =ISEMAIL(cell). You can learn more about this function <\/span>here<\/span><\/a>.\u00a0\u00a0<\/span><\/p>\n

6. Import Data From Other Sheets\u00a0<\/b><\/h2>\n

The IMPORTRANGE function of Google Sheets allows you to import data from one sheet into another. With this function, you only have to update data in a single sheet, saving time with big data sets. You can learn more about IMPORTRANGE <\/span>here<\/span><\/a>.\u00a0\u00a0<\/span><\/p>\n

7. Create Sparklines\u00a0<\/b><\/h2>\n

Sparklines let you quickly and easily visualize data sets to see trends. A simple formula of =SPRAKLINE(cell range) will create a sparkline in the cell below the data. You can learn more about the SPARKLINE function from Google <\/span>here<\/span><\/a>.\u00a0\u00a0\u00a0<\/span><\/p>\n

8. Clean and Trim<\/b><\/h2>\n

Data sets often end up with extra characters and spaces when they’re being imported or copied and pasted. Having these additional white spaces can cause big headaches down the road when taking action with your data. CLEAN and TRIM functions can help clean these up. The CLEAN function will remove any non-printable ASCII characters in a cell, and the TRIM function will remove any whitespace from the beginning and end of cells. You can learn more about CLEAN <\/span>here<\/span><\/a> and TRIM <\/span>here<\/span><\/a>.\u00a0<\/span><\/p>\n

9. Hyperlink Formula<\/b><\/h2>\n

Inserting links into large sets of data can be a time-consuming task, but luckily Google Sheets has a quick solution with the HYPERLINK function. The formula =HYPERLINK(URL, LINK_LABEL) lets you quickly add the link destination and the anchor text. You can learn more about the HYPERLINK function <\/span>here<\/span><\/a>.\u00a0\u00a0<\/span><\/p>\n

10. Count of Unique Cells\u00a0<\/b><\/h2>\n

If you’ve got a data set with lots of duplicate values (names, numbers, etc.), getting a count of all the unique values is easy with the UNIQUE function in Google Sheets. The formula =UNIQUE(cell range) will give you a count of unique rows. You can learn more about the UNIQUE function <\/span>here<\/span><\/a>.\u00a0\u00a0<\/span><\/p>\n

Want to learn even more Google Sheets tips and tricks? ONLC has <\/span>Google Sheets training classes<\/span><\/a> happening online and in-person to help you become a spreadsheet master.\u00a0\u00a0<\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets is the Google Answer to Microsoft Excel and continues to grow in popularity. While some may think of it as “Excel online,” Google Sheets is a very different product. Regular Excel users might find themselves puzzled by the Google Sheets navigation and not know the platform’s full potential.\u00a0 Whether you’re a daily Google […]<\/p>\n","protected":false},"author":2,"featured_media":989,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[35],"tags":[],"class_list":["post-988","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-workplace"],"aioseo_notices":[],"modified_by":"blogadmin","_links":{"self":[{"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/posts\/988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/comments?post=988"}],"version-history":[{"count":1,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/posts\/988\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/posts\/988\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/media\/989"}],"wp:attachment":[{"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/media?parent=988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/categories?post=988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onlc.com\/blog\/wp-json\/wp\/v2\/tags?post=988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}