{"id":1106,"date":"2021-11-20T16:47:56","date_gmt":"2021-11-20T11:17:56","guid":{"rendered":"https:\/\/sheetstips.com\/?page_id=1106"},"modified":"2022-07-19T17:07:09","modified_gmt":"2022-07-19T11:37:09","slug":"google-sheets-tips","status":"publish","type":"page","link":"https:\/\/sheetstips.com\/","title":{"rendered":"Google Sheets Tips: New Google Spreadsheet Hacks, Tricks with Examples"},"content":{"rendered":"<p><strong>Google Sheets Tips:<\/strong> Even if you use spreadsheets regularly, you may not be aware of the width and depth of their capabilities. This is true with Google Sheets in particular! Google has been developing Google Sheets since 2006 as part of its Google Workspace formerly known as G-Suite. Today, Google Sheets is an attractive solution to rapidly analyze and treat data, because it requires quick and easy collaboration worlds.<\/p>\r\n<p>On this page, we will summarize a list of tips and tricks you must learn today to increase your Google Sheets skills quickly. Scroll down and explore the hacks to use the Google Spreadsheet like a pro!!<\/p>\r\n<h2>Latest Google Sheets Tips<\/h2>\r\n\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/#Keyboard-Shortcuts-for-Google-Sheets\">Keyboard Shortcuts for Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/#insert-bullets-in-google-sheets\">Insert Bullets in Google Sheets<\/a><\/li>\r\n<li><a href=\"#Add-heatmaps-using-conditional-formatting\">Add Heatmaps Using Conditional Formatting<\/a><\/li>\r\n<li><a href=\"#send-emails-when-you-comment-in-Google-Sheets\">Send Emails when you Comment in Google Sheet<\/a><\/li>\r\n<li><a href=\"#how-to-apply-filters-in-Google-Sheets\">How to Apply Filters in Google Sheet<\/a><\/li>\r\n<li><a href=\"#clean-up-values-with-clean-and-trim-in-Google-Sheets\">Clean Up Values with CLEAN and TRIM<\/a><\/li>\r\n<li><a href=\"#protect-data-in-Google-Sheets\">Protect Data in Cells<\/a><\/li>\r\n<li><a href=\"#validate-data-in-Google-Sheets\">Validate Data in Cells<\/a><\/li>\r\n<li><a href=\"#Integrate-Google-sheet-with-Google-Forms\">Integrate Google Sheet with Google Forms<\/a><\/li>\r\n<li><a href=\"#Insert-a-chart-from-google-sheets-into-a-google-doc\">Insert a Chart from Google Sheets into a Google Doc<\/a><\/li>\r\n<li><a href=\"#Import-data-from-a-website-or-RSS-feed-to-google-sheet\">Import data from a website or RSS feed To Google Sheet<\/a><\/li>\r\n<li><a href=\"#Change-capitalization-in-cells\">Change Capitalization in Cells<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/#translate-text-in-Google-Sheets\">Translate Text in Google Sheet<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/#split-names-and-other-data\">Split names and other data<\/a><\/li>\r\n<li><a href=\"#check-for-valid-email-address\">Check for valid email address<\/a><\/li>\r\n<li><a href=\"#spell-check-in-google-sheet\">Spell Check in Google Sheet<\/a><\/li>\r\n<li><a href=\"#import-data-from-other-sheets\">Import data from other sheets<\/a><\/li>\r\n<li><a href=\"#visualize-data-with-a-sparkline\">Visualize data with a sparkling<\/a><\/li>\r\n<li><a href=\"#create-QR-Codes\">Create QR codes<\/a><\/li>\r\n<li><a href=\"#check-if-the-cell-is-really-blank\">Check if the Cell is Really Blank<\/a><\/li>\r\n<li><a href=\"#extend-google-sheets-with-add-ons\">Extend Google Sheets with add-ons<\/a><\/li>\r\n<li><a href=\"#quickly-learn-formulas\">Quickly learn formula<\/a><\/li>\r\n<li><a href=\"#wrap-text-in-google-sheets\">Wrap Text in Google Sheets<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Edit &amp; Format a Spreadsheet<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li>Edit &amp; format a spreadsheet<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/edit-and-view-text-from-right-to-left-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Edit and View Text from Right to Left<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/comments-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Add, Edit, View, Filter and Delete Comments<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/merge-cells-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Merge Cells in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/freeze-rows-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Freeze \/ Lock Rows in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/protect-range-cells-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Lock Cells in Google Sheets<\/a>\u00a0(Protect a Range)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/3-ways-to-protect-your-google-spreadsheet-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Protect Your Google Spreadsheet Data?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/round-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Round Numbers in Google Sheets<\/a>\u00a0(ROUNDUP\/ROUNDDOWN)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-format-phone-numbers-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Format Phone Numbers In Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-text-to-numbers-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Convert Text to Numbers In Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-multiply-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Multiply Numbers in Google Sheets<\/a> (Multiply Rows, Columns or Cells in Google Sheets)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-divide-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Divide in Google Sheets <\/a>(Divide Numbers, Columns, Rows, Multiple Cells)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sum-column-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">SUM a Column in Google Sheets <\/a>(Add Numbers, Row, Columns, Cells)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-image-cell-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert an Image in a Cell in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-add-or-remove-rows-and-columns-in-google-sheets\/\" data-type=\"post\" data-id=\"1514\">Add or move columns &amp; cells<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/3-ways-to-protect-your-google-spreadsheet-data\/\" data-type=\"post\" data-id=\"1450\"> <span style=\"color: initial; letter-spacing: 0px;\">Protect, hide, and edit sheets<\/span><\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/spreadsheet-locale-setting\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"post\" data-id=\"1384\"> <span style=\"color: initial; letter-spacing: 0px;\">Set a spreadsheet\u2019s location &amp; calculation settings<\/span><\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-image-cell-google-sheets\/\" data-type=\"post\" data-id=\"636\">Add an image to a spreadsheet<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Use functions &amp; formulas<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-function-list\/\">Google Sheets function list<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/use-google-sheets-mode-function-to-find-frequently-occuring-values\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use MODE Function in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/istext-function-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use the ISTEXT Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/regexextract-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use REGEXEXTRACT Google Sheets Function<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/regexreplace-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use REGEXREPLACE Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/switch-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use SWITCH function in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-weekday-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets Weekday Function \u2013 Explained with Examples<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-age-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using FILTER Function in Google Sheets<\/a>\u00a0(explained with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-or-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use OR Function in Google Sheets<\/a>\u00a0(with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importrange-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use IMPORTRANGE Function in Google Sheets<\/a>\u00a0(with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importdata-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use IMPORTDATA function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/ifs-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IFS Function in Google Sheets to Test Multiple Conditions<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/iferror-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IFERROR Function in Google Sheets<\/a>\u00a0(with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/index-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use the INDEX function in Google Sheets<\/a>\u00a0(Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-features\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets Features 2022: Check Five Most Commonly Used Functions in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/show-formulas-instead-of-values-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Show Formulas Instead of Values in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-see-basic-calculations-without-formulas-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to See Basic Calculations Without Formulas in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sum-column-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to SUM a Column in Google Sheets? (Add Numbers, Row, Columns, Cells)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-weighted-average-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Calculate Weighted Average In Google Sheets (AVERAGE.WEIGHTED)?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/if-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IF Function in Google Sheets<\/a>\u00a0(with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/query-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Query Function in Google Sheets<\/a>\u00a0\u2013 Examples<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/countif-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use COUNTIF Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/vlookup-another-sheet-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to VLOOKUP from Another Sheet in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-vlookup-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">The Ultimate Guide to Google Sheets VLOOKUP Function<\/a>\u00a0(with Examples)<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Work with Data<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-pivot-table-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create &amp; use pivot tables<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/refresh-pivot-table-google-sheets\/\">How to Refresh Pivot Table in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/slicer-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use Slicer in Pivot Tables in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculated-fields-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add &amp; Use Calculated Fields in Google Sheets Pivot Tables<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/group-by-month-pivot-table-google-sheets\/\">How to Group by Month in Pivot Table in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/auto-suggested-pivot-tables-in-sheets\/\">Auto Suggested Pivot Chart in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/unpivot-in-google-sheets\/\">How To Unpivot Table in Google Sheets?<\/a><\/li>\r\n<li>Reference data from other sheets<\/li>\r\n<li>Using arrays in Google Sheets<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/open-csv-file-google-sheets\/\">How to Import and Open CSV File in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importrange-function-google-sheets\/\">How to Use IMPORTRANGE Function in Google Sheets\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importdata-google-sheets\/\">How to Use IMPORTDATA function in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importfeed-google-sheets\/\">How to Use IMPORTFEED in Google Sheets<\/a><\/li>\r\n<li>Automatically create a series or list<\/li>\r\n<li>Name a range of cells<\/li>\r\n<li>Display KPIs with scorecard charts<\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Sort, filter, or format data<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/sort-by-color-google-sheets\/\">How to Sort by Color in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sort-data-google-sheets\/\">How to Sort Data in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/filter-views-google-sheets\/\">How to Create Filter Views in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/filter-function-google-sheets\/\">How to Use Filter Functions in Google Sheets with Examples<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-filter-google-sheets-data-without-changing-what-collaborators-see\/\">How To Filter Google Sheets Data Without Changing What Collaborators See?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/dependent-drop-list-google-sheets\/\">How to Create a Dependent Drop Down List in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/drop-down-list-in-google-sheets\/\">How to Create a Drop Down List in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-based-on-another-cell-value-in-google-sheets\/\">Conditional Formatting Based on Another Cell Value in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-google-sheets\/\">The Ultimate Guide to Using Conditional Formatting in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/split-text-to-columns-google-sheets\/\">How to Split Text to Columns in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-remove-duplicates-in-google-sheets\/\">How to Remove Duplicates in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/data-cleaning-in-google-sheets\/\">Data Cleaning in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-checkbox-google-sheets\/\">How to Insert Checkbox in Google Sheets<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Create and Edit Charts<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li>Add &amp; edit a chart or graph<\/li>\r\n<li>Add &amp; edit a trendline<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/dynamic-chart-banding-in-google-sheets\/\">Dynamic Chart Banding in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/radial-bar-chart-in-google-sheets\/\">Radial Bar Chart in Google Sheets Example<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-create-a-grid-chart-in-google-sheets\/\">How to Create a Grid Chart in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/funnel-charts-in-google-sheets\/\">Funnel Charts In Google Sheets\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/line-chart-google-sheets\/\">How to Make a Line Chart in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/pie-chart-google-sheets\/\">How to Make a Pie Chart in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/candlestick-chart-google-sheets\/\">How to Create Candlestick Chart in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-make-a-dot-plot-in-google-sheets\/\">How to Make Dot Plot in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-sync-charts-from-google-sheets-to-docs-or-slides\/\">How To Sync Charts From Google Sheets to Google Docs &amp; Google Slides?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-create-a-gantt-chart-in-google-sheets\/\">How to Create a Gantt Chart in Google Sheets?\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-switch-chart-axes-in-google-sheets\/\">How To Switch Chart Axes in Google Sheets?\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-make-an-organization-chart-in-google-sheets\/\">How to\u00a0Make an\u00a0Organization Chart in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/multi-colored-line-charts-google-sheets\/\">How To Create Multi Colored Line Charts in Google Sheets?\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/waterfalls-chart-in-google-sheets\/\">How To Create a Waterfall Chart in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/histogram-google-sheets\/\">How to Make a Histogram in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/bell-curve-google-sheets\/\">How to Make a Bell Curve in Google Sheets<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-4 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Print or Publish a spreadsheet<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/set-print-area-google-sheets\/\" data-type=\"post\" data-id=\"242\">Print from Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/print-labels-from-google-sheets\/\" data-type=\"post\" data-id=\"286\">Print a file<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-share-a-google-sheets-as-web-page\/\" data-type=\"post\" data-id=\"1533\">Make Google Docs, Sheets, Slides &amp; Forms public<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Shortcuts &amp; Troubleshooting<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li>Use Google products side by side<\/li>\r\n<li><a href=\"http:\/\/The Best Google Sheets Add Ons: Automate your Workflow With Best Add-Ons\">Automate tasks in Google Sheets<\/a><\/li>\r\n<li>Troubleshoot Google Docs, Sheets, Slides &amp; Forms error message: &#8220;Something went wrong&#8221;<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-keyboard-shortcuts\/\" target=\"_blank\" rel=\"noreferrer noopener\">Keyboard shortcuts for Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/turn-on-notifications-in-google-sheets\/\" data-type=\"post\" data-id=\"1294\">Turn on notifications in a spreadsheet<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/fill-handle-google-sheets\/\" data-type=\"post\" data-id=\"671\">Use Smart Fill in Sheets to automate data entry<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/dark-theme-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Use Dark theme in Google Docs, Sheets &amp; Slides<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/data-cleaning-in-google-sheets\/\" data-type=\"post\" data-id=\"2087\">Use Sheets Smart Cleanup to prepare your data for analysis<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/slow-google-sheets\/\" data-type=\"post\" data-id=\"2111\">Troubleshoot error message in Google Sheets: \u201cCan&#8217;t save your changes. Please copy your recent edits then revert your changes.\u201d<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Improve Your Sheets Performance<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li>Learn more about Import functions<\/li>\r\n<li>Learn how to improve Sheets performance<\/li>\r\n<li>Optimize your data references to improve Sheets performance<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-5 wp-block-columns-is-layout-flex\">\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Tools<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/things-you-can-do-with-google-sheets-and-google-apps-script\/\" data-type=\"post\" data-id=\"1890\">Use add-ons, Apps Script &amp; AppSheet<\/a><\/li>\r\n<li>Import, edit &amp; sync Salesforce data with Google Sheets<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/what-if-analysis-in-google-sheets-goal-seek\/\" data-type=\"post\" data-id=\"1038\">Find an unknown value with Goal Seek<\/a><\/li>\r\n<li>Import and analyze Zendesk data with Google Sheets<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/the-best-google-sheets-add-ons\/\" data-type=\"post\" data-id=\"1752\">Google Workspace Add-ons<\/a><\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\r\n<h3 class=\"wp-block-heading\">Use BigQuery data in Google Sheets<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li>Get started with BigQuery data in Google Sheets<\/li>\r\n<li>Sort &amp; filter BigQuery data in Google Sheets<\/li>\r\n<li>Analyze &amp; refresh BigQuery data in Google Sheets using Connected Sheets<\/li>\r\n<li>Write &amp; edit a query<\/li>\r\n<li>Fix problems with BigQuery data in Google Sheets<\/li>\r\n<\/ul>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\u00a0<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Google Sheets Tips and Tricks<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/istext-function-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use the ISTEXT Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-make-a-dot-plot-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make a Dot Plot in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/edit-and-view-text-from-right-to-left-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Edit and View Text from Right to Left<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/dark-theme-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Use Dark Theme in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-add-labels-to-legend-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add Labels to Legend in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-hide-columns-from-certain-users\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Hide Columns from Certain Users in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-use-index-match-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use Index Match in Google Sheets<\/a> (Step-by-Step Guide)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/comments-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Add, Edit, View, Filter and Delete Comments<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/regexextract-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use REGEXEXTRACT Google Sheets Function<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/what-if-analysis-in-google-sheets-goal-seek\/\" target=\"_blank\" rel=\"noreferrer noopener\">What-If Analysis in Google Sheets Using Goal Seek<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/regexreplace-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use REGEXREPLACE Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/running-totals-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Get Running Totals in Google Sheets<\/a> (Easy Formula)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/candlestick-chart-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Creating Candlestick Chart in Google Sheets<\/a> (Step-by-step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/index-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use the INDEX function in Google Sheets<\/a> (Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/wildcards-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Wildcards in Google Sheets<\/a> (4 Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/combine-formula-and-text-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Combine Formula and Text in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-pdf-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert PDF to Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-text-to-date-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Text to Date in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-formula-to-value-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Formula to Value in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/slicer-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use Slicer in Pivot Tables in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/group-columns-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Group Columns in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-time-to-decimal-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Time to Decimal in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/comparison-operators-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Comparison Operators in Google Sheets<\/a> (A Complete Guide)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/formula-parse-error-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Formula Parse Error in Google Sheets<\/a> (&amp; How to Fix it)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculated-fields-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add &amp; Use Calculated Fields in Google Sheets Pivot Tables<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/group-by-month-pivot-table-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Group by Month in Pivot Table in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/refresh-pivot-table-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Refresh Pivot Table in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/delete-every-other-row-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Delete Every Other Row in Google Sheets<\/a> (Easy Formula Trick)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/bell-curve-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make a Bell Curve in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/open-csv-file-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Import and Open CSV File in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-military-time-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Time to Military Time Format in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/switch-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use SWITCH function in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/round-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Round Numbers in Google Sheets?<\/a> (ROUNDUP\/ROUNDDOWN)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/print-labels-from-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Print Labels from Google Sheets<\/a> (For Free)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-weighted-average-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Calculate Weighted Average In Google Sheets (AVERAGE.WEIGHTED)?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/scatter-plot-google-sheets\/\">How to Make a Scatter Plot in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/turn-on-notifications-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Turn on Notifications in a Spreadsheet<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-format-phone-numbers-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Format Phone Numbers In Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/recover-deleted-google-sheets-files\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Recover Deleted Google Sheets Files<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/move-column-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Move A Column In Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/set-print-area-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Set Print Area in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/unhide-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Unhide Rows in Google Sheets<\/a> (4 Easy Methods)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/show-formulas-instead-of-values-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Show Formulas Instead of Values in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/format-painter-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Format Painter in Google Sheets<\/a> (Copy formatting easily)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/highlight-duplicates-google-sheets\/\">How to Highlight Duplicates In Google Sheets<\/a> (Easy Steps)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/strikethrough-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Strikethrough in Google Sheets<\/a> (3 Easy Ways + Shortcut)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/vlookup-another-sheet-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to VLOOKUP from Another Sheet in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-text-to-numbers-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Text to Numbers In Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/compare-two-columns-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Compare Two Columns in Google Sheets<\/a> (for matches &amp; differences)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/histogram-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make a Histogram in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/line-chart-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make a Line Chart in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sort-by-color-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Sort by Color in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/pie-chart-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make a Pie Chart in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/automatically-send-emails-from-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Automatically Send Emails from Google Sheets<\/a> (Using Appscript)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-pivot-table-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert a Pivot Table in Google Sheets<\/a> (Step-by-Step)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/capitalize-first-letters-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Capitalize First Letters in Google Sheets<\/a> (Easy Formula)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-remove-last-character\/\" target=\"_blank\" rel=\"noreferrer noopener\">Remove Last Character from a String in Google Sheets<\/a> (or Last N Characters)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/leave-tracker-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Leave Tracker Template in Google Sheets<\/a> (Updated for 2021)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sparkline-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Sparkline in Google Sheets \u2013 The Only Guide You Need<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/hide-gridlines-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Show \/ Hide Gridlines in Google Sheets<\/a> (in less than 5 seconds)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-timestamp\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert Timestamp in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-checkbox-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert Checkbox in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-keyboard-shortcuts\/\" target=\"_blank\" rel=\"noreferrer noopener\">101 Google Sheets Keyboard Shortcuts<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/spin-button-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert Spin Button in Google Sheets<\/a> (+1 Increment Buttons)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/copy-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Copy a Sheet from One Google Sheets to Another<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/data-analysis-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">4 Steps for Quick and Easy Data Analysis with Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/filter-views-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create and Use Filter Views in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/table-of-contents-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a Table of Contents in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-weekday-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets Weekday Function \u2013 Explained with Examples<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/last-monday-month-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Get the Last Monday of the Month in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-age-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Calculate Age in Google Sheets<\/a> (using the Date of Birth)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/hyperlinks-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create Hyperlinks in Google Sheets<\/a> (Step-by-Step Guide)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-age-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using FILTER Function in Google Sheets<\/a> (explained with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/search-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Search in Google Sheets and Highlight the Matching Data<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-or-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use OR Function in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importrange-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use IMPORTRANGE Function in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importdata-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use IMPORTDATA function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calculate-days-between-two-dates-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Calculate the Number of Days Between Two Dates in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/ifs-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IFS Function in Google Sheets to Test Multiple Conditions<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/freeze-rows-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Quickly Freeze \/ Lock Rows in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/iferror-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IFERROR Function in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/drop-down-list-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a Drop Down List in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/importfeed-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IMPORTFEED in Google Sheets to Fetch Feed from URL<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/query-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Query Function in Google Sheets<\/a> \u2013 Examples<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/concatenate-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Concatenate in Google Sheets \u2013 Combine Cells Using Formula<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/zoom-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Zoom In and Zoom Out in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/transpose-data-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Quickly Transpose Data in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/fill-handle-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Fill Down in Google Sheets Using Fill Handle<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/calendar-template-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Calendar Template in Google Sheets<\/a> (Monthly and Yearly)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-vlookup-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">The Ultimate Guide to Google Sheets VLOOKUP Function<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/named-ranges-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create Named Ranges in Google Sheets<\/a> (Static &amp; Dynamic)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-multiple-rows-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Quickly Insert Multiple Rows in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/rotate-text-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Rotate Text in Google Sheets<\/a> (in less than 5 seconds)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/count-non-blank-cells-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Count Cells If Not Blank in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-based-on-another-cell-value-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Conditional Formatting Based on Another Cell Value in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/heat-map-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Creating a Heat Map in Google Sheets<\/a> (Step-by-Step Tutorial)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/split-text-to-columns-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Split Text to Columns in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-excel-to-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Excel to Google Sheets (a Step-by-Step Tutorial)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/dependent-drop-list-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a Dependent Drop Down List in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/insert-image-cell-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert an Image in a Cell in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/countif-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use COUNTIF Function in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/merge-cells-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Quickly Merge Cells in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">The Ultimate Guide to Using Conditional Formatting in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/spell-check-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use Spell Check in Google Sheets to Find Misspelled Words<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/if-function-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using IF Function in Google Sheets<\/a> (with Examples)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/protect-range-cells-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Lock Cells in Google Sheets<\/a> (Protect a Range)<\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sort-data-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Sort Data in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/wrap-text-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Wrap Text in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-bullets-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert Bullets in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/count-number-words-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Count the Number of Words in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-remove-duplicates-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Remove Duplicates in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/color-alternate-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Color Alternate Rows in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/automatically-add-colourful-stripes-in-your-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add ColourFul Stripes in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/open-a-sheet-on-a-specific-tab\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Open Google Sheet on a Specific Tab?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-spreadsheet-limitations\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Spreadsheet Limitations<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/gain-insights-in-sheets-data-via-explore\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Gain Insights to Your Google Sheets Data via Explore<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/managing-data-in-spreadsheet-with-the-help-of-list-view\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Manage Date in Google Spreadsheet with List View?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/3-ways-to-protect-your-google-spreadsheet-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Protect Your Google Spreadsheet Data?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-resize-column-and-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Resize Rows and Columns in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-make-a-table-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Make Tables in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-apply-a-color-scale-based-on-values-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Apply a Color Scale Based on Values in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-convert-currency-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Currency in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-a-google-sheets-spreadsheet-into-google-docs\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Insert a Google Sheets Into Google Docs?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/create-a-star-rating-system-in-google-sheets\/\">How To Create Star Rating System in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sync-data-from-one-spreadsheet-to-another\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Sync Data From One Google Sheet to Another Spreadsheet?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/view-your-activity-dashboard\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to View Activity Dashboard in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/named-versions-in-google-files\/\" target=\"_blank\" rel=\"noreferrer noopener\">Named Versions in Google Sheets\u00a0<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/add-text-rotation-and-accounting-in-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add Text Rotation and Perform Accounting in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/spreadsheet-locale-setting\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Spreadsheet Locale Settings<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/remove-zero-values-from-a-google-spreadsheet\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Remove Zero Value from Google Spreadsheet?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/auto-suggested-pivot-tables-in-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Auto Suggested Pivot Tables in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-add-or-remove-rows-and-columns-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add or Remove Rows and Columns in Google Spreadsheet? (With Keyboard Shortcuts)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-open-links-in-google-sheets-with-a-single-click\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Open Links in Google Sheets with Single Click \u2013 Google Sheets Clickable Cell<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-multiply-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Multiply Numbers in Google Sheets? \u2013 Multiply Rows, Columns or Cells in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-share-a-google-sheets-as-web-page\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Publish Google Sheets as Web Page: Share Google Sheets to Public<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-divide-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Divide in Google Sheets? (Divide Numbers, Columns, Rows, Multiple Cells)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/sum-column-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to SUM a Column in Google Sheets? (Add Numbers, Row, Columns, Cells)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/hide-and-unhide-spreadsheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Hide Tabs or Spreadsheets in Google Sheets? (Hide or Unhide Sheets)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/open-spreadsheets-in-completely-separate-windows\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Open Google Spreadsheet in New Window? (View Two Tabs at Once)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Convert Rows to Columns or Backwards in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-assign-document-tasks-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Assign Tasks in Google Sheets? (Enable Tasks Using Comments)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-see-basic-calculations-without-formulas-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to See Basic Calculations Without Formulas in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-use-the-paste-special-options-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use Paste Special Options in Google Spreadsheet? Google Sheets Paste Special Explained<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-present-google-sheets-in-google-meet\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Present Google Sheets in Google Meet -2 Easy Methods to Present Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/wp-admin\/post.php?post=1626&amp;action=edit\" target=\"_blank\" rel=\"noreferrer noopener\">How to Add Headers and Footers in Google Sheets: 2 Methods to Insert Headers\/Footers<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-check-version-history-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Check Version History in Google Sheets? \u2013 Restore or View Named Versions<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-highlight-blanks-or-errors-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Highlight Blank or Errors in Google Sheets? (Using Conditional Formatting)<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-rename-columns-or-rows-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Rename Columns and Rows in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-change-the-currency-symbol-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Change Currency Symbol in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-set-the-default-currency-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Set Default Currency in Google Spreadsheet \u2013 Change Currency Settings in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-sync-charts-from-google-sheets-to-docs-or-slides\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Sync Charts From Google Sheets to Google Docs &amp; Google Slides?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-change-the-default-date-format-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Change Default Date Format in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-change-and-create-custom-number-format-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Change and Create Custom Number Format in Google Spreadsheet?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-switch-chart-axes-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Switch Chart Axes in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-create-a-gantt-chart-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a Gantt Chart in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/use-google-sheets-mode-function-to-find-frequently-occuring-values\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Use MODE Function in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-generate-random-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Generate Random Numbers in Google Sheets Without Duplicates?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-use-google-translate-directly-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Use Google Translate Directly in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-filter-google-sheets-data-without-changing-what-collaborators-see\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Filter Google Sheets Data Without Changing What Collaborators See?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/the-best-google-sheets-add-ons\/\">The Best Google Sheets Add Ons<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-restrict-data-input-in-google-sheets-with-data-validation\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Restrict Data in Google Sheets with Data Validation?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-features\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets Features 2021: Check Five Most Commonly Used Functions in Google Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/reverse-text-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Reverse Text in Google Sheets?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/waterfalls-chart-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Create a Waterfall Chart in Google Sheets? (Stacked Waterfall Charts)<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3>Python OpenPyxl<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-adjusting-rows-and-columns-of-an-excel-file-using-openpyxl-module\/\">How to Adjust Rows and Columns of an Excel File using openpyxl Module in Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-1\/\">Python Program Plotting Charts in Excel Sheet using Openpyxl module | Set 1<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-2\/\">Python Program Plotting Charts in Excel Sheet using openpyxl module | Set 2<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-3\/\">Python Program Plotting Charts in Excel Sheet using openpyxl module | Set 3<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-delete-one-or-more-rows-in-excel-using-openpyxl\/\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;How to Delete One or More Rows in Excel File using Python Openpyxl?&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4224,&quot;10&quot;:2,&quot;15&quot;:&quot;Arial&quot;}\">How to Delete One or More Rows in Excel File using Python Openpyxl?<\/span><\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3>Python XlsxWriter<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-working-with-pandas-and-xlsxwriter-set-1\/\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Working with Pandas and XlsxWriter in Python | Set \u2013 1&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4737,&quot;3&quot;:{&quot;1&quot;:0},&quot;10&quot;:2,&quot;12&quot;:0,&quot;15&quot;:&quot;Arial&quot;}\">Working with Pandas and XlsxWriter in Python | Set \u2013 1<\/span><\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-working-with-pandas-and-xlsxwriter-set-2\/\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Working with Pandas and XlsxWriter in Python | Set \u2013 2&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">Working with Pandas and XlsxWriter in Python | Set \u2013 2<\/span><\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-working-with-pandas-and-xlsxwriter-set-3\/\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Working with Pandas and XlsxWriter in Python | Set \u2013 3&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4224,&quot;10&quot;:2,&quot;15&quot;:&quot;Arial&quot;}\">Working with Pandas and XlsxWriter in Python | Set \u2013 3<\/span><\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-program-to-plot-combined-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Combined Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-adding-a-chartsheet-in-an-excel-sheet-using-xlsxwriter-module\/\">Python Program to Add a Chartsheet to an Excel sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-stock-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python | Plotting Stock charts in excel sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-area-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Area Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-an-excel-chart-with-gradient-fills-using-xlsxwriter-module\/\">Python Program to Plot an Excel chart with Gradient fills using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-pie-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Pie Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-column-charts-in-excel-sheet-with-data-tables-using-xlsxwriter-module\/\">Python Program to Plot Column Charts in Excel Sheet with Data tables using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-line-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Line Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-with-data-tools-using-xlsxwriter-module-set-2\/\">Python Program to Plot Charts in Excel Sheet with Data Tools using XlsxWriter module | Set \u2013 2<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-charts-in-excel-sheet-with-data-tools-using-xlsxwriter-module-set-1\/\">Python Program to Plot Charts in Excel Sheet with Data Tools using XlsxWriter module | Set \u2013 1<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-radar-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Radar Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-program-to-plot-an-excel-chart-with-pattern-fills-in-column-using-xlsxwriter-module\/\">Python Program to Plot an Excel Chart with Pattern Fills in Column using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-scatter-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Scatter Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-doughnut-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Doughnut Charts in Excel sheet using XlsxWriter Module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-program-to-plot-bar-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Bar Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-plotting-different-types-of-style-charts-in-excel-sheet-using-xlsxwriter-module\/\">Python Program to Plot Different types of Style Charts in Excel Sheet using XlsxWriter module<\/a><\/li>\r\n<\/ul>\r\n<h3>Python &#8211; Google Sheets &#8211; Spreadsheets<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-for-spreadsheet-users\/\">Python for Spreadsheet Users<\/a><\/li>\r\n<\/ul>\r\n<h3>MS Excel<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/worksheets-in-excel\/\">Worksheets in Excel<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-write-pandas-dataframes-to-multiple-excel-sheets-in-python\/\">How to Write Pandas DataFrames to Multiple Excel Sheets in Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/protecting-excel-worksheets-and-workbooks\/\">Protecting Excel Worksheets and Workbooks<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/reading-excel-file-using-python\/\">Reading an Excel File and Performing More Operations on it using Python<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-create-and-write-on-excel-file-using-xlsxwriter-module-in-python\/\">How to Create and Write on Excel File using xlsxwriter Module in Python<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-excel-to-csv-in-python\/\">How to Convert Excel to CSV in Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-convert-pdf-file-to-excel-file-using-python\/\">How to Convert PDF File to Excel File using Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-csv-to-excel-using-pandas-in-python\/\">Convert CSV to Excel using Pandas in Python<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-automate-an-excel-sheet-in-python\/\">How to Automate an Excel Sheet in Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/working-with-excel-files-in-python-using-xlwings\/\">Working with Excel files using Python Xlwings<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-split-given-list-and-insert-in-excel-file\/\">Python | Split given List and Insert in Excel File<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-convert-excel-to-xml-format-in-python\/\">How to Convert Excel File to XML Format Using Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-program-how-to-copy-data-from-one-excel-sheet-to-another\/\">Python Program How to Copy Data from One Excel sheet to Another<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-a-tsv-file-to-excel-using-python\/\">Convert a TSV file to Excel using Python<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-convert-an-html-table-into-excel\/\">Python Program to Convert an HTML Table into excel<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/puzzle-number-of-sheets-to-be-turned-so-that-prime-number-has-a-vowel-on-the-other-side\/\">Puzzle | Number of Sheets to be turned so that Prime Number has a Vowel on the other side<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/combine-multiple-excel-worksheets-into-a-single-pandas-dataframe\/\">Combine Multiple Excel Worksheets Into a Single Pandas Dataframe<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/performing-excel-like-countifs-in-python-pandas\/\">Performing Excel like countifs in Python Pandas<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/python-program-to-compare-excel-files\/\">Python Program to Compare Excel Files<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-merge-all-excel-files-in-a-folder-using-python\/\">How to Merge all Excel Files in a Folder using Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/writing-excel-sheet-using-python\/\">Python Program to Write to an Excel Sheet using xlwt module<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-replace-a-word-in-excel-using-python\/\">Python Program to Replace a Word in Excel<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-convert-json-to-excel-python-pandas\/\">How to Convert JSON to Excel File in Python?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/creating-a-dataframe-using-excel-files\/\">How to Create a dataframe using Excel files?<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Excel R<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/write-data-into-excel-using-r\/\">How to Write Data Into Excel Using R Language<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-perform-a-vlookup-similar-to-excel-in-r\/\">How to Perform a VLOOKUP (Similar to Excel) in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/specify-row-names-when-reading-excel-file-in-r\/\">Specifying the Row Names when Reading Excel File in R<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-read-password-protected-excel-file-in-r\/\">How to Read Password Protected Excel file in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-read-multiple-excel-files-in-r\/\">How to Read Multiple Excel files in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-import-an-excel-file-into-r\/\">How to Import an Excel File into R ?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-export-a-dataframe-to-excel-file-in-r\/\">How to Export a DataFrame to Excel File in R ?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/convert-an-excel-column-into-a-list-of-vectors-in-r\/\">How to Convert an Excel Column into a List of vectors in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-convert-excel-content-into-dataframe-in-r\/\">How to Convert Excel Content into DataFrame in R ?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-plot-excel-data-in-r\/\">How to Plot Excel Data in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-read-excel-file-in-r\/\">How to Read an Excel File in R ?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-read-multiple-excel-files-in-r\/\">How to Read Excel File and Select Specific Rows and Columns in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-read-a-xlsx-file-with-multiple-sheets-in-r\/\">How to read a XLSX file with Multiple Sheets in R?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/import-multiple-excel-sheets-into-in-r\/\">R Program to Import Multiple Excel Sheets<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/combine-multiple-excel-worksheets-into-single-dataframe-in-r\/\">R Program to Combine Multiple Excel Worksheets into Single Dataframe<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-export-multiple-dataframes-to-different-excel-worksheets-in-r\/\">How to Export Multiple Dataframes to Different Excel Worksheets Using R?<\/a><\/li>\r\n<\/ul>\r\n<h3>Java Apache POI Excel<\/h3>\r\n<ul>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-write-data-from-hashmap-to-excel-using-java-in-apache-poi\/\">How to Write Data from HashMap to Excel using Java in Apache POI?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-write-data-from-excel-file-into-a-hashmap-using-java-and-apache-poi\/\">How to Write Data from Excel File into a HashMap using Java and Apache POI?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-fill-background-color-of-cells-in-excel-using-java-and-apache-poi\/\">How to Fill Background Color of Cells in Excel using Java and Apache POI?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-create-formula-cell-in-excel-sheet-using-java-and-apache-poi\/\">How to Create Formula Cell in Excel Sheet using Java and Apache POI?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/java-program-to-create-blank-excel-sheet\/\">Java Program to Create blank Excel Sheet<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/creating-a-cell-at-specific-position-in-excel-file-using-java\/\">How to Create a Cell at Specific Position in Excel file using Java<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-write-data-into-excel-sheet-using-java\/\">How to Write Data into Excel Sheet using Java?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-add-hyperlink-to-the-contents-of-a-cell-using-java\/\">How to Add Hyperlink to the Contents of a Cell In Excel using Java?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/how-to-apply-fonts-to-the-contents-of-a-cell-using-java\/\">How to Apply Fonts to the Contents of a Cell Using Java?<\/a><\/li>\r\n<li><a href=\"https:\/\/sheetstips.com\/creating-sheets-in-excel-file-in-java-using-apache-poi\/\">How to Create Sheets in Excel File in Java using Apache POI?<\/a><\/li>\r\n<\/ul>\r\n<h3 id=\"send-emails-when-you-comment-in-Google-Sheets\">Send Emails When You Comment In Google Sheet<\/h3>\r\n\r\n\r\n\r\n<p>Google Sheets are great for collaborating in real-time. Any individual can easily send an email to the concerned person just with the help of their recipient&#8217;s email id. All you have to do is, just insert a plus sign (+), then type the e-mail address (or name) and the recipients will receive an e-mail automatically when you insert your comment. Also, you can make use of the &#8220;@&#8221; symbol to send an email.<\/p>\r\n\r\n\r\n\r\n<p>Refer to the steps given below, where you will find an example of how to send an email through google sheet:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Open the google sheet and select the cell where you have to write a mail.<\/li>\r\n<li><strong>Step 2:<\/strong> Right-click and select comment from the drop-down menu.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"275\" class=\"wp-image-48\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/comment-in-google-300x275.png\" alt=\"how to send mail in google sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/comment-in-google-300x275.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/comment-in-google-768x703.png 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/comment-in-google.png 881w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure><\/div>\r\n\r\n\r\n<ul>\r\n<li><strong>Step 3:<\/strong> Now either use the<strong> &#8220;+&#8221; or &#8220;@&#8221;<\/strong> symbol and type the email id as shown in the image given below.<\/li>\r\n<li><strong>Step 4:<\/strong> Type the email and click on assign. The email will be sent.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"175\" class=\"wp-image-49\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/sending-email-through-google-sheets-300x175.png\" alt=\"sending email through google sheets\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/sending-email-through-google-sheets-300x175.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/sending-email-through-google-sheets-1024x596.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/sending-email-through-google-sheets-768x447.png 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/sending-email-through-google-sheets.png 1241w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Add-heatmaps-using-conditional-formatting\">Add Heatmaps Using Conditional Formatting<\/h3>\r\n\r\n\r\n\r\n<p>Heatmaps are a great way to highlight important information on your Google sheet. You can use conditional formatting to highlight specific values, outliers, or errors. The function of a colour scale enables you to highlight lower and higher values quickly in your data.<\/p>\r\n\r\n\r\n\r\n<p>Follow the steps listed below to add heatmaps using conditional formatting.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Click on the &#8220;<strong>Format<\/strong>&#8221; and select &#8220;<strong>Conditional Formatting<\/strong>&#8221; from the drop-down menu.<\/li>\r\n<li><strong>Step 2:<\/strong> A new window will open towards the right side of the screen.<\/li>\r\n<li><strong>Step 3:<\/strong> Select the &#8220;<strong>Apply To Range<\/strong>&#8221; under &#8220;<strong>Color Scale<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 4:<\/strong> Now under format rules, Select the value.<\/li>\r\n<li><strong>Step 5:<\/strong> Enter the &#8220;<strong>Mid Point value, Max point value, Min Point Value<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 6:<\/strong> Click on &#8220;<strong>Done<\/strong>&#8220;<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"121\" class=\"wp-image-50\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting-300x121.jpg\" alt=\"Add Heatmaps Using Conditional Formatting\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting-300x121.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting-1024x414.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting-768x311.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting-1536x622.jpg 1536w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Add-Heatmaps-Using-Conditional-Formatting.jpg 1831w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"how-to-apply-filters-in-Google-Sheets\">Apply Filters In Google Sheets<\/h3>\r\n\r\n\r\n\r\n<p>You can only display interest rows within the sheet by using filters. This can be helpful if you work with a wider range of data. Follow the steps listed below to apply filters in the sheet.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the column on which you will have to apply the filter.<\/li>\r\n<li><strong>Step 2:<\/strong> Click on the filter icon as shown in the image below.<\/li>\r\n<li><strong>Step 3:<\/strong> Now you will have the option to choose your desired filter by selecting the required dataset and so on.<\/li>\r\n<li><strong>Step 4:<\/strong> Also you will have options to filter by colour, values and conditions.<\/li>\r\n<li><strong>Step 5:<\/strong> After choosing the desired filter click on &#8220;<strong>OK<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 6:<\/strong> The filter will be applied to the sheet.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1803\" height=\"810\" class=\"wp-image-51\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets.jpg\" alt=\"apply filters in google sheets\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets.jpg 1803w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets-300x135.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets-1024x460.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets-768x345.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/apply-filters-in-google-sheets-1536x690.jpg 1536w\" sizes=\"(max-width: 1803px) 100vw, 1803px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"clean-up-values-with-clean-and-trim-in-Google-Sheets\">Clean Up Values with CLEAN and TRIM<\/h3>\r\n\r\n\r\n\r\n<p>TRIM function is used to clean or remove from the cell start and from the ends. Follow the steps listed below to make use of the CLEAN and TRIM functions in Google Sheets.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the columns where you will have to remove the whitespaces.<\/li>\r\n<li><strong>Step 2:<\/strong> Click on the &#8220;<strong>Data<\/strong>&#8221; tab and select &#8220;<strong>Trim Whitespaces<\/strong>&#8221; from the drop-down menu.<\/li>\r\n<li><strong>Step 3:<\/strong> Now you will get a message saying that &#8220;<strong>Trimmed Whitespace from (No) selected rows<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 4:<\/strong> Click on &#8220;<strong>OK<\/strong>&#8220;.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1033\" height=\"742\" class=\"wp-image-52\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Clean-Up-Values-with-CLEAN-and-TRIM.jpg\" alt=\"Clean Up Values with CLEAN and TRIM\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Clean-Up-Values-with-CLEAN-and-TRIM.jpg 1033w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Clean-Up-Values-with-CLEAN-and-TRIM-300x215.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Clean-Up-Values-with-CLEAN-and-TRIM-1024x736.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Clean-Up-Values-with-CLEAN-and-TRIM-768x552.jpg 768w\" sizes=\"(max-width: 1033px) 100vw, 1033px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Another way to trim the whitespace is to simply select the cells and type the formula &#8211; &#8220;<em><strong>=TRIM(A2)<\/strong><\/em>&#8221; and the whitespace will be cleaned.<\/p>\r\n\r\n\r\n\r\n<p><em><strong>Note:<\/strong> <\/em>A2 is the cell that we have given here for reference.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"protect-data-in-Google-Sheets\">Protect Data in Cells in Google Sheet<\/h3>\r\n\r\n\r\n\r\n<p>You might want to limit data to prevent mistakes if a lot of people work on a sheet. You can also protect sheets and cells so that information is not changed by accident. Follow the steps listed below to protect the data in cells in Google Sheets.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the columns and click on the &#8220;<strong>Data<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 2:<\/strong> Now, scroll down and select &#8220;<strong>Protected Sheets and Ranges<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 3:<\/strong> A new window will open towards the right side of the screen.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1396\" height=\"838\" class=\"wp-image-53\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet.jpg\" alt=\"Protect Data in Cells in Google Sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet.jpg 1396w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-300x180.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1024x615.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-768x461.jpg 768w\" sizes=\"(max-width: 1396px) 100vw, 1396px\" \/><\/figure><\/div>\r\n\r\n\r\n<ul>\r\n<li><strong>Step 4:<\/strong> Now select the &#8220;<strong>Range<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 5:<\/strong> Click on &#8220;<strong>Set Permissions<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 6:<\/strong> Now edit the permissions as per your requirements.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1838\" height=\"750\" class=\"wp-image-54\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1.jpg\" alt=\"Protect Data in Cells in Google Sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1.jpg 1838w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1-300x122.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1-1024x418.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1-768x313.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Protect-Data-in-Cells-in-Google-Sheet-1-1536x627.jpg 1536w\" sizes=\"(max-width: 1838px) 100vw, 1838px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"validate-data-in-Google-Sheets\">Validate Data in Cells<\/h3>\r\n\r\n\r\n\r\n<p>By applying data validation to your cells on Google sheet, you can ensure that certain cells only contain selected data. For instance, validation can be set to include numbers or even a value in a defined list in certain cells only. A drop-down selector is also made available in the sheet by defining a predefined list of values.<\/p>\r\n\r\n\r\n\r\n<p>Follow the steps listed below to validate cells using data validation.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the cells and click on the &#8220;<strong>Data<\/strong>&#8221; tab.<\/li>\r\n<li><strong>Step 2:<\/strong> Now select the &#8220;<strong>Data Validation<\/strong>&#8221; from the drop-down menu.<\/li>\r\n<li><strong>Step 3:<\/strong> Validate the selected cells as per your requirements.<\/li>\r\n<li><strong>Step 4:<\/strong> Once validation is done, click on &#8220;<strong>Save<\/strong>&#8220;.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"837\" class=\"wp-image-55\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells.jpg\" alt=\"Validate Data in Cells\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells.jpg 1920w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells-300x131.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells-1024x446.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells-768x335.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Validate-Data-in-Cells-1536x670.jpg 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Integrate-Google-sheet-with-Google-Forms\">Integrate Google Sheet With Google Forms<\/h3>\r\n\r\n\r\n\r\n<p>Although it is one of the most powerful ways to optimise your forms to integrate your Google Form into Google Sheets. You will need to establish a form before you start feeding your Google Sheet information to automatically sync all of your information. It takes only a few minutes to establish your form.<\/p>\r\n\r\n\r\n\r\n<p>From multiple selections, drop-downs, short answers, long responses, checkboxes, and more, choose different answers.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1143\" height=\"808\" class=\"wp-image-56\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Integrate-With-Google-Forms.jpg\" alt=\"Integrate With Google Forms\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Integrate-With-Google-Forms.jpg 1143w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Integrate-With-Google-Forms-300x212.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Integrate-With-Google-Forms-1024x724.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Integrate-With-Google-Forms-768x543.jpg 768w\" sizes=\"(max-width: 1143px) 100vw, 1143px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Follow the steps listed below to integrate Google Sheets with Google Forms.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Click the Responses tab.<\/li>\r\n<li><strong>Step 2:<\/strong> Click the Google Sheet icon now.<\/li>\r\n<li><strong>Step 3:<\/strong> Choose to create a new spreadsheet.<\/li>\r\n<li><strong>Step 4:<\/strong> Enter your sheet name.<\/li>\r\n<li><strong>Step 5:<\/strong> Click Create.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Insert-a-chart-from-google-sheets-into-a-google-doc\">Insert a Chart from Google Sheets into a Google Doc<\/h3>\r\n\r\n\r\n\r\n<p>You can insert a chart into Google Docs when you have created a chart inside Google Sheets. Follow the steps listed below to insert a chart from Google Docs to Google Sheets.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select &#8216;<strong>Insert<\/strong>&#8216; in the Google document.<\/li>\r\n<li><strong>Step 2:<\/strong> Now select &#8220;<strong>Chart<\/strong>&#8221; and hit on &#8220;<strong>From sheets<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 3:<\/strong> Now select the &#8220;<strong>Sheets<\/strong>&#8221; from your drive.<\/li>\r\n<li><strong>Step 4:<\/strong> Now click on &#8220;<strong>Select<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 5:<\/strong> The chart will be displayed on the Google doc.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>This saves you much time since you can reflect any modifications made in google sheets by updating the diagram in the document.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1058\" height=\"788\" class=\"wp-image-57\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Insert-a-Chart-from-Google-Sheets-into-a-Google-Doc.jpg\" alt=\"Insert a Chart from Google Sheets into a Google Doc\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Insert-a-Chart-from-Google-Sheets-into-a-Google-Doc.jpg 1058w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Insert-a-Chart-from-Google-Sheets-into-a-Google-Doc-300x223.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Insert-a-Chart-from-Google-Sheets-into-a-Google-Doc-1024x763.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Insert-a-Chart-from-Google-Sheets-into-a-Google-Doc-768x572.jpg 768w\" sizes=\"(max-width: 1058px) 100vw, 1058px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Import-data-from-a-website-or-RSS-feed-to-google-sheet\">Import Data from a Website or RSS feed<\/h3>\r\n\r\n\r\n\r\n<p>You can import data from websites and RSS feeds via various features. The steps to import data on\u00a0 Google Sheets are explained.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the cell where you have to import the data.<\/li>\r\n<li><strong>Step 2:<\/strong> Now type the formula &#8220;<strong>=Import(function type)(URL)&#8221;<\/strong>.<\/li>\r\n<li><strong>Step 3:<\/strong> Click on &#8220;<strong>Enter<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 4:<\/strong> The data will be imported on the sheet.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Various features to import data are:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>ImportHTML<\/strong> tables and lists to import HTML<\/li>\r\n<li><strong>ImportFeed<\/strong> to import RSS feed<\/li>\r\n<li><strong>ImportData<\/strong> to import a CSV file on the web<\/li>\r\n<li><strong>ImportXML<\/strong> to import a customised section of an Xpath webpage.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"754\" height=\"359\" class=\"wp-image-58\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Import-data-from-a-website-or-RSS-feed-.jpg\" alt=\"Import data from a website or RSS feed \" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Import-data-from-a-website-or-RSS-feed-.jpg 754w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Import-data-from-a-website-or-RSS-feed--300x143.jpg 300w\" sizes=\"(max-width: 754px) 100vw, 754px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Change-capitalization-in-cells\">Change Capitalization in Cells<\/h3>\r\n\r\n\r\n\r\n<p>You can use the PROPER function to capitalise on the first letter in each word. This is useful if values are to be cleaned for consistency. Alternatively, the LOWER function can be used to reduce all letters. The steps to change the case are explained below:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the cell where you have to make modifications.<\/li>\r\n<li><strong>Step 2:<\/strong> Now to capitalize, write the formula &#8220;<strong>=Upper(Cell Number)<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 3:<\/strong> Click enter. The word or sentence will be capitalized.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Referto the image below to know the different types of cases used to represent a word.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"136\" class=\"wp-image-60\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Using-formulas-to-change-case-in-Google-Sheets.png\" alt=\"Using-formulas-to-change-case-in-Google-Sheets\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Using-formulas-to-change-case-in-Google-Sheets.png 632w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Using-formulas-to-change-case-in-Google-Sheets-300x65.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/figure><\/div>\r\n\r\n\r\n<p>Also, one can make use of the Add-Ons function in google sheet, to change the case of an word.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"translate-text-in-Google-Sheets\">Translate Text in Google Sheet<\/h3>\r\n\r\n\r\n\r\n<p>Below is the formula to translate the text,<\/p>\r\n\r\n\r\n\r\n<p>=GOOLGETRANSLATE(&#8220;Text&#8221;, &#8220;Source Language&#8221;, &#8220;Destination Language&#8221;)<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"294\" height=\"300\" class=\"wp-image-46\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-trans-294x300.png\" alt=\"translate language in google sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-trans-294x300.png 294w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-trans.png 547w\" sizes=\"(max-width: 294px) 100vw, 294px\" \/><\/figure><\/div>\r\n\r\n\r\n<p>Example:<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"160\" class=\"wp-image-47\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-translate-example-300x160.png\" alt=\"\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-translate-example-300x160.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/google-translate-example.png 382w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\">Split Names and Other Data in Google Sheet<\/h3>\r\n\r\n\r\n\r\n<p>These are steps to split the full names into the first name and last name:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Choose the data you would like to divide.<\/li>\r\n<li><strong>Step 2:<\/strong> Go to the Data tab.<\/li>\r\n<li><strong>Step 3:<\/strong> Click on &#8220;<strong>Split text to columns<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 4:<\/strong> It divides the names in the first and last names immediately.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1378\" height=\"765\" class=\"wp-image-62\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Split-names-and-other-data-.png\" alt=\"Split names and other data \" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Split-names-and-other-data-.png 1378w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Split-names-and-other-data--300x167.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Split-names-and-other-data--1024x568.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Split-names-and-other-data--768x426.png 768w\" sizes=\"(max-width: 1378px) 100vw, 1378px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"check-for-valid-email-address\">Check for Valid Email Address<\/h3>\r\n\r\n\r\n\r\n<p>You can check it by using Google Sheets if you have a list of e-mails and you want to make certain that they have a valid e-mail address structure. It will not verify that your e-mails are delivered, but it will help identify all rebounding mail addresses (such as &#8216;@&#8217; or &#8216;.com&#8217; missing).<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the cells for which you have to validates the Email.<\/li>\r\n<li><strong>Step 2:<\/strong> Enter the formula &#8220;<strong>=ISEMAIL(Cell Number)<\/strong>&#8220;<\/li>\r\n<li><strong>Step 3:<\/strong> Click on &#8220;<strong>Enter<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 4:<\/strong> The Email Address will be validated with True or False<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"274\" class=\"wp-image-63\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Check-for-valid-email-addresses-on-google-sheets.jpg\" alt=\"Check for valid email addresses \" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Check-for-valid-email-addresses-on-google-sheets.jpg 671w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Check-for-valid-email-addresses-on-google-sheets-300x123.jpg 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"spell-check-in-google-sheet\">Spell Check in Google Sheet<\/h3>\r\n\r\n\r\n\r\n<p>You can check the word spelling on Google Sheets. Click the Main Menu Tools and then search for Spelling. For a Spell check, click on it. Click on the Spell check and the spelling of words is checked by Google Sheets automatically.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"504\" class=\"wp-image-64\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Ensure-that-spelling-is-correct.png\" alt=\"Spell check on google sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Ensure-that-spelling-is-correct.png 482w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Ensure-that-spelling-is-correct-287x300.png 287w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"import-data-from-other-sheets\">Import Data from Other Sheets<\/h3>\r\n\r\n\r\n\r\n<p>You can simply import data from one sheet to another instead of maintaining data in multiple sheets. This also means that only one place (and not several sheets) needs to update your data, which can save time.<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li>Open the Google Sheets.<\/li>\r\n<li>Enter the formula, &#8220;<strong>=IMPORTRANGE<\/strong>&#8221; in a cell that is empty.<\/li>\r\n<li>In parenthesis, in quota marks and separated by a comma* add the following specifications:\r\n<ul>\r\n<li>The URL is in sheets of the table.<\/li>\r\n<li>The name of the sheet and the cells to be imported are (optional).<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Press Enter.<\/li>\r\n<li>Click &#8220;<strong>Allow<\/strong>&#8221; access.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Refer to the image given below for example.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1053\" height=\"286\" class=\"wp-image-65\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/import-data-from-other-sheet.png\" alt=\"import data from other sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/import-data-from-other-sheet.png 1053w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/import-data-from-other-sheet-300x81.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/import-data-from-other-sheet-1024x278.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/import-data-from-other-sheet-768x209.png 768w\" sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"visualize-data-with-a-sparkline\">Visualize Data with a Sparkline<\/h3>\r\n\r\n\r\n\r\n<p>In order to quickly see trends in your data, you can easily add sparklines to your sheets.<br \/>This may be useful if you compare data or you want to turn your sheet into a dashboard, like comparing metrics, sales and so on. The steps to visualize the data with sparkline are given below:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Select the cells.<\/li>\r\n<li><strong>Step 2:<\/strong> Enter the formula &#8220;<strong>=Sparkline(B2:B31)<\/strong>&#8220;<\/li>\r\n<li><strong>Step 3:<\/strong> Click on Enter.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>You will see a chart showing the trends. Refer to the image given below for reference.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"463\" class=\"wp-image-66\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Visualize-data-with-a-sparkline-.jpg\" alt=\"Visualize data with a sparkline \" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Visualize-data-with-a-sparkline-.jpg 460w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Visualize-data-with-a-sparkline--298x300.jpg 298w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Visualize-data-with-a-sparkline--150x150.jpg 150w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"create-QR-Codes\">Create QR Codes<\/h3>\r\n\r\n\r\n\r\n<p>Barcodes are a useful way to monitor things, such as checking people for information, conferences or events. And in Google Sheets you can easily create QR codes. All you have to do is, select the cell and enter the formula. The formula to be entered has been provided in the sheet below:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"981\" height=\"485\" class=\"wp-image-67\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Create-QR-codes-.jpg\" alt=\" Create QR codes using google sheet\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Create-QR-codes-.jpg 981w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Create-QR-codes--300x148.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Create-QR-codes--768x380.jpg 768w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Formula used to create QR code: <strong>=IMAGE(&#8220;https:\/\/chart.googleapis.com\/chart?chs=200&#215;200&amp;cht=qr&amp;chl=&#8221;&amp;A1&amp;&#8221;&#8221;)<\/strong><\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"check-if-the-cell-is-really-blank\">Check if the Cell is Really Blank<\/h3>\r\n\r\n\r\n\r\n<p>The results of a COUNTA() feature that you may use to control the number of cell with existing entries can be misleading characters that do not appear as apostrophic and stray spaces on the table. The solution is to use ISBLANK() to identify which cells have the attributes that offend.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"extend-google-sheets-with-add-ons\">Extend Google Sheets with Add-ons<\/h3>\r\n\r\n\r\n\r\n<p>You can easily add many features to Google Sheets, just by using the &#8220;Add-Ons&#8221; option. The steps to use add-ons on Google Sheets are explained below.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Click on the &#8220;<strong>Add-ons<\/strong>&#8221; tab.<\/li>\r\n<li><strong>Step 2:<\/strong> Click on &#8220;<strong>Get add-ons<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 3:<\/strong> You will be displayed with various add-ons tab.<\/li>\r\n<li><strong>Step 4:<\/strong> Select the Add-ons and click on &#8220;<strong>Install for Google Sheets<\/strong>&#8220;.<\/li>\r\n<li><strong>Step 5:<\/strong> The add-on will be enabled.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1320\" height=\"389\" class=\"wp-image-68\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Extend-Google-Sheets-with-Add-ons.jpg\" alt=\"Extend Google Sheets with Add-ons\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Extend-Google-Sheets-with-Add-ons.jpg 1320w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Extend-Google-Sheets-with-Add-ons-300x88.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Extend-Google-Sheets-with-Add-ons-1024x302.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Extend-Google-Sheets-with-Add-ons-768x226.jpg 768w\" sizes=\"(max-width: 1320px) 100vw, 1320px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"quickly-learn-formulas\">Quickly Learn Formulas<\/h3>\r\n\r\n\r\n\r\n<p>Google Sheets make it easy during work to learn formulas. You will see a handy reference when you begin typing a form that contains important information about the formula you are adding. For example, just start typing the formula = DATEDIF(and you will see this:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"965\" height=\"785\" class=\"wp-image-71\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Quickly-learn-formulas-.jpg\" alt=\"Quickly learn formulas\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Quickly-learn-formulas-.jpg 965w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Quickly-learn-formulas--300x244.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Quickly-learn-formulas--768x625.jpg 768w\" sizes=\"(max-width: 965px) 100vw, 965px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"Keyboard-Shortcuts-for-Google-Sheets\">Keyboard Shortcuts for Google Sheets<\/h3>\r\n\r\n\r\n\r\n<p>Below provided Google sheets <a href=\"https:\/\/btechgeeks.com\/keyboard-shortcuts\/\">keyboard shortcuts<\/a> make it easier to perform common actions, like copying and selecting the cells(rows and columns) in the Google sheets:<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Ctrl+C<\/strong>: Copies the selected row\/column<\/li>\r\n<li><strong>Ctrl+V<\/strong>: Pastes the selected row\/column<\/li>\r\n<li><strong>Ctrl+X<\/strong>: Cut\/Deletes the selected row\/column<\/li>\r\n<li><strong>Ctrl+Shift+V<\/strong>: Pastes only the value of cell<\/li>\r\n<li><strong>Ctrl+Space<\/strong>: Selects the whole column<\/li>\r\n<li><strong>Shift+Space<\/strong>: Selects the whole row<\/li>\r\n<li><strong>Ctrl+A<\/strong>: Selects entire sheet\/cell<\/li>\r\n<li><strong>Ctrl+Z<\/strong>: Undo an action<\/li>\r\n<li><strong>Ctrl+Y<\/strong>: Redo an action<\/li>\r\n<li><strong>Ctrl+F<\/strong>: Find in the sheet\/cell<\/li>\r\n<li><strong>Ctrl+H<\/strong>: Find and replace in the sheet\/cell<\/li>\r\n<li><strong>Shift+F11<\/strong>: Insert a new sheet<\/li>\r\n<li><strong>Ctrl+Alt+Shift+H<\/strong>: Opens the history of the sheet<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Below provided Google sheets keyboard shortcuts will help the user to format the cells easily,<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Ctrl+B<\/strong>: Bold<\/li>\r\n<li><strong>Ctrl+I<\/strong>: Italicize<\/li>\r\n<li><strong>Ctrl+U<\/strong>: Underline<\/li>\r\n<li><strong>Ctrl+Shift+E<\/strong> : Center align<\/li>\r\n<li><strong>Ctrl+Shift+L<\/strong> : Left align<\/li>\r\n<li><strong>Ctrl+Shift+R<\/strong> : Right align<\/li>\r\n<li><strong>Ctrl+;<\/strong> : Insert the Current date<\/li>\r\n<li><strong>Alt+Shift+7<\/strong>: Apply the outer border to the selected row\/column<\/li>\r\n<li><strong>Alt+Shift+6<\/strong>: Removes the outer border for selected row \/column<\/li>\r\n<li><strong>Ctrl+Shift+1<\/strong>: Format as decimal<\/li>\r\n<li><strong>Ctrl+Shift+2<\/strong>: Format as time<\/li>\r\n<li><strong>Ctrl+Shift+3<\/strong>: Format as date<\/li>\r\n<li><strong>Ctrl+Shift+4<\/strong>: Format as currency<\/li>\r\n<li><strong>Ctrl+Shift+5<\/strong>: Format as percentage<\/li>\r\n<li><strong>Ctrl+Shift+6<\/strong>: Format as the exponent<\/li>\r\n<li><strong>Ctrl+\\<\/strong>: Clear formatting from the selected cell<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Below provided Google sheets keyboard shortcuts make it easier to move around the spreadsheet easily<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Left\/Right\/Up\/Down Arrow<\/strong>: Move from one cell to another to the left, right, up and down<\/li>\r\n<li><strong>Ctrl+Left\/Right Arrow<\/strong>: Moves to first or last cell with the data in the row<\/li>\r\n<li><strong>Ctrl+Up\/Down Arrow<\/strong>: Moves to first or last cell with the data in the column<\/li>\r\n<li><strong>Home<\/strong>: Moves to the beginning of a row<\/li>\r\n<li><strong>End<\/strong>: Moves to end of the row<\/li>\r\n<li><strong>Ctrl+Home<\/strong>: Moves to the beginning of the sheet<\/li>\r\n<li><strong>Ctrl+End<\/strong>: Moves to the end of the sheet<\/li>\r\n<li><strong>Ctrl+Backspace<\/strong>: Scroll back to the active cell<\/li>\r\n<li><strong>Alt+Up\/Down Arrow<\/strong>: if you have more than one sheet in the current file, use this shortcut to move to the next or previous sheet<\/li>\r\n<li><strong>Alt+Shift+K<\/strong>: Display a list of all sheets<\/li>\r\n<li><strong>Ctrl+Alt+Shift+M<\/strong>: Move focus out of the spreadsheet<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Below provided Google sheets keyboard shortcuts make it easier to use and find the formulas applied on the sheet.<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Ctrl+~<\/strong>: Shows all formulas in the sheet<\/li>\r\n<li><strong>Ctrl+Shift+Enter<\/strong> : Insert an array formula (type &#8220;=&#8221; first)<\/li>\r\n<li><strong>F1<\/strong>: Full or compact formulas help<\/li>\r\n<li><strong>F9<\/strong>: Toggle formula result previews<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Below provided Google sheets keyboard shortcuts make it easier to Add or Change Rows and Columns eailsy.<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Cmd+D<\/strong>: Duplicate the data from the first column of the selected range down<\/li>\r\n<li><strong>Cmd+R<\/strong>: Duplicate the data from the first row of the selected range to the right<\/li>\r\n<li><strong>Cmd+Enter<\/strong>: Duplicate the data from the first cell of the selected range into the other cell<\/li>\r\n<li><strong>Cmd+Option+9<\/strong>: Hide a row<\/li>\r\n<li><strong>Cmd+Shift+9<\/strong>: Unhide a row<\/li>\r\n<li><strong>Cmd+Option+0<\/strong>: Hide a column<\/li>\r\n<li><strong>Cmd+Shift+0<\/strong>: Unhide a column<\/li>\r\n<li><strong>Ctrl+Option+I, then R<\/strong>: Insert the row above<\/li>\r\n<li><strong>Ctrl+Option+I, then W<\/strong>: Insert the row below<\/li>\r\n<li><strong>Ctrl+Option+I, then C<\/strong>: Insert the columns to the left<\/li>\r\n<li><strong>Ctrl+Option+I, then O<\/strong>: Insert the columns to the right<\/li>\r\n<li><strong>Ctrl+Option+E, then D<\/strong>: Delete Rows<\/li>\r\n<li><strong>Ctrl+Option+E, then E<\/strong>: Delete Columns<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>Below provided Google sheets keyboard shortcuts make it easier to access the menu easily<\/p>\r\n\r\n\r\n\r\n<ol>\r\n<li><strong>Alt+F<\/strong>: Access the File menu<\/li>\r\n<li><strong>Alt+E<\/strong>: Access the Edit menu<\/li>\r\n<li><strong>Alt+V<\/strong>: Access the View menu<\/li>\r\n<li><strong>Alt+I<\/strong>: Access the Insert menu<\/li>\r\n<li><strong>Alt+O<\/strong>: Access the Format menu<\/li>\r\n<li><strong>Alt+T<\/strong>: Access the Tools menu<\/li>\r\n<li><strong>Alt+H<\/strong>: Access the Help menu<\/li>\r\n<li><strong>Alt+A<\/strong>: Access the accessibility menu<\/li>\r\n<li><strong>Shift+Right-click<\/strong>: This shows your browser context menu<\/li>\r\n<li><strong>Ctrl+Shift+F<\/strong>: Switch to compact mode<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"insert-bullets-in-google-sheets\">Insert Bullets in Google Sheets<\/h3>\r\n\r\n\r\n\r\n<p>On Google sheets, we don&#8217;t have a feature to insert bullets automatically. To insert bullets or number list of Google Spreadsheet, follow the steps listed below:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Choose the cell where you want the bullets to go.<\/li>\r\n<li><strong>Step 2:<\/strong> Now type \u201c<strong>=CHAR(8226)<\/strong>\u201d in the CHAR function.<\/li>\r\n<li><strong>Step 3:<\/strong> On your keyboard, press the \u201c<strong>Enter<\/strong>\u201d key.<\/li>\r\n<\/ul>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"401\" height=\"243\" class=\"wp-image-198\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-add-bullets-in-google-sheets-1.jpg\" alt=\"how to add bullets in google sheets\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-add-bullets-in-google-sheets-1.jpg 401w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-add-bullets-in-google-sheets-1-300x182.jpg 300w\" sizes=\"(max-width: 401px) 100vw, 401px\" \/><\/figure><\/div>\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"wrap-text-in-google-sheets\">Wrap Text in Google Sheets<\/h3>\r\n\r\n\r\n\r\n<ul>\r\n<li><strong>Step 1:<\/strong> Choose the cells you&#8217;d like to wrap.<\/li>\r\n<li><strong>Step 2:<\/strong> Go to the menu bar and select &#8220;<strong>Format<\/strong>.&#8221;<\/li>\r\n<li><strong>Step 3:<\/strong> Go to the section titled &#8220;<strong>Text Wrapping<\/strong>.&#8221;<\/li>\r\n<li><strong>Step 4:<\/strong> From the drop-down option, select &#8220;<strong>Wrap<\/strong>.&#8221;<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>The selected text will be wrapped now.<\/p>\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"754\" class=\"wp-image-208\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Wrap-Text-in-Google-Sheets-2.jpg\" alt=\"How to Wrap Text in Google Sheets\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Wrap-Text-in-Google-Sheets-2.jpg 1012w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Wrap-Text-in-Google-Sheets-2-300x224.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Wrap-Text-in-Google-Sheets-2-768x572.jpg 768w\" sizes=\"(max-width: 1012px) 100vw, 1012px\" \/><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>Google Sheets Tips: Even if you use spreadsheets regularly, you may not be aware of the width and depth of their capabilities. This is true with Google Sheets in particular! Google has been developing Google Sheets since 2006 as part of its Google Workspace formerly known as G-Suite. Today, Google Sheets is an attractive solution &#8230; <a title=\"Google Sheets Tips: New Google Spreadsheet Hacks, Tricks with Examples\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/\" aria-label=\"More on Google Sheets Tips: New Google Spreadsheet Hacks, Tricks with Examples\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"jetpack-related-posts":[{"id":1324,"url":"https:\/\/sheetstips.com\/contact-us\/","url_meta":{"origin":1106,"position":0},"title":"Contact Us","author":"Anthony","date":"October 7, 2021","format":false,"excerpt":"Sheets Tips 1346 Ranch Rd 1471, Marble Falls, TX 78659, United States. Contact us today to take your business to the next level! You can reach us by email at Sheets Tips 1 at gmail dot com.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1326,"url":"https:\/\/sheetstips.com\/disclaimer\/","url_meta":{"origin":1106,"position":1},"title":"Disclaimer","author":"Anthony","date":"October 7, 2021","format":false,"excerpt":"SheetsTips.com is purely made for education purpose and we keep every measure to avoid any possibility of offensive material. If anyone finds a content which is injuring your rights then you can provide us with a clue on our contact us @ \u2013 Sheets Tips 1 at gmail dot com\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1331,"url":"https:\/\/sheetstips.com\/about-us\/","url_meta":{"origin":1106,"position":2},"title":"About Us","author":"Anthony","date":"October 7, 2021","format":false,"excerpt":"SheetsTips.com is one of those Excel blogs where you can find some of the most amazing Excel and data analytics. We have Excel Tutorials which can help you to learn Excel, faster. As a team, we have combined experience of 20+ years using Microsoft Excel and analytics. It is one\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1328,"url":"https:\/\/sheetstips.com\/privacy-policy\/","url_meta":{"origin":1106,"position":3},"title":"Privacy Policy","author":"Anthony","date":"October 7, 2021","format":false,"excerpt":"Who we are Our website address is: https:\/\/sheetstips.com\/ This privacy policy has been compiled to better serve those who are concerned with how their \u2018Personally identifiable information\u2019 (PII) is being used online. PII, as used in US privacy law and information security, is information that can be used on its\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/pages\/1106"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=1106"}],"version-history":[{"count":22,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/pages\/1106\/revisions"}],"predecessor-version":[{"id":4165,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/pages\/1106\/revisions\/4165"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}