https://www.groovypost.com The premier source for tech news, tips, reviews and how to galleries Wed, 20 Dec 2023 21:45:15 +0000 en-US hourly 1 https://www.groovypost.com/wp-content/uploads/2017/11/cropped-gp-logo-512-32x32.png https://www.groovypost.com 32 32 https://www.groovypost.com/howto/calculate-percentage-google-sheets/ https://www.groovypost.com/howto/calculate-percentage-google-sheets/#respond Tue, 05 Dec 2023 15:05:51 +0000 https://www.groovypost.com/?p=253944 If you've been wondering how to use Google Sheets to calculate a percentage value, we've got the answer here.]]> https://www.groovypost.com/howto/calculate-percentage-google-sheets/feed/ 0 https://www.groovypost.com/howto/use-quotient-google-sheets/ https://www.groovypost.com/howto/use-quotient-google-sheets/#respond Thu, 26 Oct 2023 17:30:34 +0000 https://www.groovypost.com/?p=252287 Dividing numbers in Google Sheets will give an exact answer, but this isn't always what you want. Here's how to use QUOTIENT in Google Sheets.]]> https://www.groovypost.com/howto/use-quotient-google-sheets/feed/ 0 https://www.groovypost.com/howto/count-checkboxes-in-google-sheets/ https://www.groovypost.com/howto/count-checkboxes-in-google-sheets/#respond Tue, 03 Oct 2023 14:05:43 +0000 https://www.groovypost.com/?p=249044 With checkboxes in your spreadsheet, it's not obvious how to count those that are checked. Here's how to count checkboxes in Google Sheets.]]> https://www.groovypost.com/howto/count-checkboxes-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/save-google-sheets-as-a-pdf/ https://www.groovypost.com/howto/save-google-sheets-as-a-pdf/#respond Tue, 11 Jul 2023 17:30:45 +0000 https://www.groovypost.com/?p=245205 If you want a read-only copy of your Google Sheets spreadsheet data, you might want to save it as a PDF. This guide explains how.]]> https://www.groovypost.com/howto/save-google-sheets-as-a-pdf/feed/ 0 https://www.groovypost.com/howto/import-cryptocurrency-prices-into-google-sheets/ https://www.groovypost.com/howto/import-cryptocurrency-prices-into-google-sheets/#respond Wed, 21 Jun 2023 14:05:18 +0000 https://www.groovypost.com/?p=242841 Do you want to keep on top of the latest crypto price rises (and falls)? Learn how to import cryptocurrency prices into Google Sheets using this guide.]]> https://www.groovypost.com/howto/import-cryptocurrency-prices-into-google-sheets/feed/ 0 https://www.groovypost.com/howto/remove-html-tags-in-google-sheets/ https://www.groovypost.com/howto/remove-html-tags-in-google-sheets/#respond Thu, 08 Jun 2023 17:30:31 +0000 https://www.groovypost.com/?p=243626 If you copy data from web pages into Google Sheets, it may include a lot of unwanted HTML code. Here's how to remove HTML tags in Google Sheets.]]> https://www.groovypost.com/howto/remove-html-tags-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/remove-outliers-in-google-sheets/ https://www.groovypost.com/howto/remove-outliers-in-google-sheets/#respond Fri, 02 Jun 2023 20:30:30 +0000 https://www.groovypost.com/?p=243645 Sometimes your spreadsheet can include unusually high or low values that skew your results. Learn how to remove outliers in Google Sheets here.]]> https://www.groovypost.com/howto/remove-outliers-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/create-qr-codes-in-google-sheets/ https://www.groovypost.com/howto/create-qr-codes-in-google-sheets/#respond Mon, 24 Apr 2023 20:30:30 +0000 https://www.groovypost.com/?p=241986 QR codes are a great way to share a web link, and you can make them yourself. Learn how to create QR codes in Google Sheets in this guide.]]> https://www.groovypost.com/howto/create-qr-codes-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/share-a-single-sheet-in-google-sheets/ https://www.groovypost.com/howto/share-a-single-sheet-in-google-sheets/#respond Tue, 18 Apr 2023 20:30:58 +0000 https://www.groovypost.com/?p=240080 There isn't a built-in way to share a single sheet in Google Sheets, but there are some workarounds. This guide explains how.]]> https://www.groovypost.com/howto/share-a-single-sheet-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/comment-and-react-in-google-sheets/ https://www.groovypost.com/howto/comment-and-react-in-google-sheets/#respond Fri, 14 Apr 2023 14:05:52 +0000 https://www.groovypost.com/?p=240087 Collaborating on spreadsheets is made easy in Google Sheets, thanks to comments, notes, and other reactions. Here's how to use them.]]> https://www.groovypost.com/howto/comment-and-react-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/use-timestamps-in-google-sheets/ https://www.groovypost.com/howto/use-timestamps-in-google-sheets/#respond Thu, 13 Apr 2023 17:30:16 +0000 https://www.groovypost.com/?p=240084 Trying to track time in Google Sheets? You may want to insert some timestamps. This guide explains how.]]> https://www.groovypost.com/howto/use-timestamps-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/insert-google-sheets-into-google-docs/ https://www.groovypost.com/howto/insert-google-sheets-into-google-docs/#respond Thu, 13 Apr 2023 14:05:04 +0000 https://www.groovypost.com/?p=240078 Want to include data from your Google Sheets spreadsheet in your Google Docs document? Follow this guide to get started.]]> https://www.groovypost.com/howto/insert-google-sheets-into-google-docs/feed/ 0 https://www.groovypost.com/howto/make-cells-bigger-in-google-sheets/ https://www.groovypost.com/howto/make-cells-bigger-in-google-sheets/#respond Fri, 03 Mar 2023 21:40:21 +0000 https://www.groovypost.com/?p=236904 If you're finding it hard to read the data in your Google Sheets cells, why not make them bigger? Learn how in this guide.]]> https://www.groovypost.com/howto/make-cells-bigger-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/print-labels-from-google-sheets/ https://www.groovypost.com/howto/print-labels-from-google-sheets/#respond Tue, 31 Jan 2023 17:30:07 +0000 https://www.groovypost.com/?p=237512 If you have a spreadsheet of addresses, you may want to print them off as labels. Here's how to print labels from Google Sheets.]]> https://www.groovypost.com/howto/print-labels-from-google-sheets/feed/ 0 https://www.groovypost.com/howto/convert-negative-numbers-to-positive-in-google-sheets/ https://www.groovypost.com/howto/convert-negative-numbers-to-positive-in-google-sheets/#respond Tue, 17 Jan 2023 15:05:21 +0000 https://www.groovypost.com/?p=236873 Negative, positive, absolute, what's the difference? If you want to know how to switch from negative to positive numbers in Google Sheets, read this guide.]]> https://www.groovypost.com/howto/convert-negative-numbers-to-positive-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/remove-dollar-signs-in-google-sheets/ https://www.groovypost.com/howto/remove-dollar-signs-in-google-sheets/#respond Tue, 10 Jan 2023 18:30:35 +0000 https://www.groovypost.com/?p=236908 If you want to remove dollar signs from a data set in Google Sheets, there are a few methods you can try. This guide explains how.]]> https://www.groovypost.com/howto/remove-dollar-signs-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/merge-sheets-in-google-sheets/ https://www.groovypost.com/howto/merge-sheets-in-google-sheets/#respond Mon, 09 Jan 2023 18:30:17 +0000 https://www.groovypost.com/?p=236902 Merging sheets together in Google Sheets can help you organize and analyze your data. This guide explains how.]]> https://www.groovypost.com/howto/merge-sheets-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/change-default-font-in-google-docs/ https://www.groovypost.com/howto/change-default-font-in-google-docs/#comments Sun, 25 Dec 2022 15:05:38 +0000 https://www.groovypost.com/?p=236337 An excellent way to customize your documents is to use a custom font. You can change the default font in Google Docs, Slides, and Sheets using this guide.]]> https://www.groovypost.com/howto/change-default-font-in-google-docs/feed/ 2 https://www.groovypost.com/howto/set-print-area-in-google-sheets/ https://www.groovypost.com/howto/set-print-area-in-google-sheets/#respond Fri, 21 Oct 2022 17:30:46 +0000 https://www.groovypost.com/?p=233798 If you want to print off your Google Sheets spreadsheet, you'll need to choose the the print area, or the parts you want to print. This guide explains how.]]> https://www.groovypost.com/howto/set-print-area-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/fix-a-formula-parse-error-in-google-sheets/ https://www.groovypost.com/howto/fix-a-formula-parse-error-in-google-sheets/#respond Mon, 03 Oct 2022 14:05:10 +0000 https://www.groovypost.com/?p=232619 A formula parse error in Google Sheets is usually a problem with how the formula is written or the data it uses. This guide explains how to fix it.]]> https://www.groovypost.com/howto/fix-a-formula-parse-error-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/copy-a-value-not-a-formula-in-google-sheets/ https://www.groovypost.com/howto/copy-a-value-not-a-formula-in-google-sheets/#respond Tue, 27 Sep 2022 20:30:24 +0000 https://www.groovypost.com/?p=232268 In Google Sheets, you may find that cells aren't pasting in the right format. Learn how to copy a value not a formula in Google Sheets]]> https://www.groovypost.com/howto/copy-a-value-not-a-formula-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/calculate-averages-in-google-sheets/ https://www.groovypost.com/howto/calculate-averages-in-google-sheets/#respond Mon, 01 Aug 2022 08:00:29 +0000 https://www.groovypost.com/?p=229403 One of the easiest (and most useful) calculations in Google Sheets is to calculate averages. This guide will explain how.]]> https://www.groovypost.com/howto/calculate-averages-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/show-formulas-in-google-sheets/ https://www.groovypost.com/howto/show-formulas-in-google-sheets/#respond Fri, 29 Jul 2022 13:30:19 +0000 https://www.groovypost.com/?p=229408 Want to see the behind-the-scenes calculations in your Google Sheets spreadsheet? You can enable formula view. This guide will explain how.]]> https://www.groovypost.com/howto/show-formulas-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/sum-a-column-in-google-sheets/ https://www.groovypost.com/howto/sum-a-column-in-google-sheets/#respond Mon, 04 Jul 2022 17:05:44 +0000 https://www.groovypost.com/?p=228559 If you want to add up your column values in Google Sheets, you'll need to use SUM. This guide will show you how.]]> https://www.groovypost.com/howto/sum-a-column-in-google-sheets/feed/ 0 https://www.groovypost.com/howto/add-error-bars-in-google-sheets/ https://www.groovypost.com/howto/add-error-bars-in-google-sheets/#respond Thu, 30 Jun 2022 14:05:59 +0000 https://www.groovypost.com/?p=228823 If you want to quickly show error projections, you can use an error bar. Here's how to add error bars to a Google Sheets spreadsheet.]]> https://www.groovypost.com/howto/add-error-bars-in-google-sheets/feed/ 0