https://www.groovypost.com The premier source for tech news, tips, reviews and how to galleries Wed, 06 Dec 2023 18:35:53 +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/nest-group-rows-excel/ https://www.groovypost.com/howto/nest-group-rows-excel/#respond Wed, 06 Dec 2023 18:15:47 +0000 https://www.groovypost.com/?p=254403 If your spreadsheet is complex and chock-full of data, it might help to learn how to group, or nest, your rows in Excel for easier visibility.]]> https://www.groovypost.com/howto/nest-group-rows-excel/feed/ 0 https://www.groovypost.com/howto/calculate-z-score-excel/ https://www.groovypost.com/howto/calculate-z-score-excel/#respond Wed, 06 Dec 2023 15:05:10 +0000 https://www.groovypost.com/?p=254300 If you need to calculate a Z-Score from your data, here's how to do that in Excel.]]> https://www.groovypost.com/howto/calculate-z-score-excel/feed/ 0 https://www.groovypost.com/howto/excel-document-not-saved-error-fix/ https://www.groovypost.com/howto/excel-document-not-saved-error-fix/#respond Wed, 15 Nov 2023 15:05:50 +0000 https://www.groovypost.com/?p=253419 Are you struggling to save your Excel spreadsheet? Here's what to try if you're getting an Excel document not saved error.]]> https://www.groovypost.com/howto/excel-document-not-saved-error-fix/feed/ 0 https://www.groovypost.com/howto/fix-the-excel-out-of-memory-error/ https://www.groovypost.com/howto/fix-the-excel-out-of-memory-error/#respond Wed, 08 Nov 2023 15:05:48 +0000 https://www.groovypost.com/?p=253099 Are you getting warnings about Excel running out of memory? Here are some steps to try to fix the Excel out of memory error.]]> https://www.groovypost.com/howto/fix-the-excel-out-of-memory-error/feed/ 0 https://www.groovypost.com/howto/extract-year-date-excel/ https://www.groovypost.com/howto/extract-year-date-excel/#respond Wed, 25 Oct 2023 20:00:12 +0000 https://www.groovypost.com/?p=251328 Through the powerful features of Excel, learn how you can extract just the year from a date or series of dates.]]> https://www.groovypost.com/howto/extract-year-date-excel/feed/ 0 https://www.groovypost.com/howto/add-remove-drop-down-list-excel/ https://www.groovypost.com/howto/add-remove-drop-down-list-excel/#respond Thu, 12 Oct 2023 07:05:20 +0000 https://www.groovypost.com/?p=251220 To help enter consistent data in your spreadsheets, drop-down lists are invaluable tools. Here's how to add, change, or remove a drop-down list in Excel.]]> https://www.groovypost.com/howto/add-remove-drop-down-list-excel/feed/ 0 https://www.groovypost.com/howto/add-remove-page-break-lines-excel/ https://www.groovypost.com/howto/add-remove-page-break-lines-excel/#respond Tue, 10 Oct 2023 00:06:36 +0000 https://www.groovypost.com/?p=251435 The blue page break lines are handy in Excel, once you know how to add or remove them. Here's how.]]> https://www.groovypost.com/howto/add-remove-page-break-lines-excel/feed/ 0 https://www.groovypost.com/howto/extract-text-from-a-cell-in-excel/ https://www.groovypost.com/howto/extract-text-from-a-cell-in-excel/#respond Mon, 25 Sep 2023 17:30:45 +0000 https://www.groovypost.com/?p=236625 Are you looking to extract text from a cell in Microsoft Excel? This guide walks you through using the LEFT, RIGHT, MID, or FIND functions to do that.]]> https://www.groovypost.com/howto/extract-text-from-a-cell-in-excel/feed/ 0 https://www.groovypost.com/howto/calculate-averages-excel/ https://www.groovypost.com/howto/calculate-averages-excel/#respond Mon, 25 Sep 2023 14:05:50 +0000 https://www.groovypost.com/?p=236849 Calculating averages is a good way to learn more about your data in Excel. Learn how to calculate averages using Excel here.]]> https://www.groovypost.com/howto/calculate-averages-excel/feed/ 0 https://www.groovypost.com/howto/fix-excel-not-recognizing-dates/ https://www.groovypost.com/howto/fix-excel-not-recognizing-dates/#respond Fri, 11 Aug 2023 17:30:18 +0000 https://www.groovypost.com/?p=246960 Is Excel not recognizing dates in your spreadsheet? There could be a few reasons why. To fix the problem, follow the steps in this guide.]]> https://www.groovypost.com/howto/fix-excel-not-recognizing-dates/feed/ 0 https://www.groovypost.com/howto/excel-cannot-insert-column-fixes/ https://www.groovypost.com/howto/excel-cannot-insert-column-fixes/#respond Thu, 10 Aug 2023 14:05:35 +0000 https://www.groovypost.com/?p=246534 Struggling to add columns in Excel? If Excel can't insert columns, follow this guide to fix the problem.]]> https://www.groovypost.com/howto/excel-cannot-insert-column-fixes/feed/ 0 https://www.groovypost.com/howto/disable-scientific-notation-in-excel/ https://www.groovypost.com/howto/disable-scientific-notation-in-excel/#respond Tue, 08 Aug 2023 14:05:05 +0000 https://www.groovypost.com/?p=245686 By default, Excel converts longer numbers into scientific notation to save space. Learn how to disable scientific notation in Excel using this guide.]]> https://www.groovypost.com/howto/disable-scientific-notation-in-excel/feed/ 0 https://www.groovypost.com/howto/swap-columns-in-excel/ https://www.groovypost.com/howto/swap-columns-in-excel/#respond Mon, 07 Aug 2023 14:05:08 +0000 https://www.groovypost.com/?p=245598 Is the order of your Excel columns not working for you? It's easy to switch them around. Learn how to swap columns in Excel here.]]> https://www.groovypost.com/howto/swap-columns-in-excel/feed/ 0 https://www.groovypost.com/howto/fix-excel-not-highlighting-cells/ https://www.groovypost.com/howto/fix-excel-not-highlighting-cells/#respond Mon, 31 Jul 2023 14:05:44 +0000 https://www.groovypost.com/?p=246560 Are you having trouble selecting cells in Excel? Here's what to try if you're having issues with Excel not highlighting cells.]]> https://www.groovypost.com/howto/fix-excel-not-highlighting-cells/feed/ 0 https://www.groovypost.com/howto/fix-excel-not-dividing-correctly/ https://www.groovypost.com/howto/fix-excel-not-dividing-correctly/#respond Mon, 24 Jul 2023 14:30:10 +0000 https://www.groovypost.com/?p=246691 Are your Excel formulas misbehaving? If you're having issues with Excel not dividing correctly, follow this guide to fix the problem.]]> https://www.groovypost.com/howto/fix-excel-not-dividing-correctly/feed/ 0 https://www.groovypost.com/howto/fix-excel-not-auto-calculating/ https://www.groovypost.com/howto/fix-excel-not-auto-calculating/#respond Mon, 10 Jul 2023 17:30:24 +0000 https://www.groovypost.com/?p=246103 Are you having problems with Excel not auto calculating? Here are a few fixes that should get things working again.]]> https://www.groovypost.com/howto/fix-excel-not-auto-calculating/feed/ 0 https://www.groovypost.com/howto/fix-excel-not-sorting-numbers-correctly/ https://www.groovypost.com/howto/fix-excel-not-sorting-numbers-correctly/#respond Tue, 04 Jul 2023 17:30:23 +0000 https://www.groovypost.com/?p=246179 Are you having problems with Excel not sorting numbers correctly? If so, here are a few fixes that you should try.]]> https://www.groovypost.com/howto/fix-excel-not-sorting-numbers-correctly/feed/ 0 https://www.groovypost.com/howto/name-a-range-in-excel/ https://www.groovypost.com/howto/name-a-range-in-excel/#respond Fri, 30 Jun 2023 17:30:16 +0000 https://www.groovypost.com/?p=245723 If you're constantly referring to a range of cells in Excel, it can save time to give it a name. Learn how to name a range in Excel.]]> https://www.groovypost.com/howto/name-a-range-in-excel/feed/ 0 https://www.groovypost.com/howto/combine-two-columns-in-excel/ https://www.groovypost.com/howto/combine-two-columns-in-excel/#respond Wed, 28 Jun 2023 20:30:34 +0000 https://www.groovypost.com/?p=245484 Do you need to merge data from different columns in your spreadsheet? Here's how to combine two columns in Excel.]]> https://www.groovypost.com/howto/combine-two-columns-in-excel/feed/ 0 https://www.groovypost.com/howto/extract-a-number-from-a-string-in-excel/ https://www.groovypost.com/howto/extract-a-number-from-a-string-in-excel/#respond Wed, 07 Jun 2023 14:05:14 +0000 https://www.groovypost.com/?p=242999 When you import data into Excel, you may need to separate it. Learn how to extract a number from a string in Excel using this guide.]]> https://www.groovypost.com/howto/extract-a-number-from-a-string-in-excel/feed/ 0 https://www.groovypost.com/howto/check-for-partial-matches-in-excel/ https://www.groovypost.com/howto/check-for-partial-matches-in-excel/#respond Wed, 31 May 2023 17:30:47 +0000 https://www.groovypost.com/?p=243573 Do you need to match part of a string in your spreadsheets? Learn how to check for partial matches in Excel in this guide.]]> https://www.groovypost.com/howto/check-for-partial-matches-in-excel/feed/ 0 https://www.groovypost.com/howto/fix-excel-online-retrieving-data-error/ https://www.groovypost.com/howto/fix-excel-online-retrieving-data-error/#comments Mon, 15 May 2023 19:44:43 +0000 https://www.groovypost.com/?p=243854 When you're trying to copy data from Excel, you may run into problems retrieving it. Here's how to fix the Excel Online 'Retrieving Data' error.]]> https://www.groovypost.com/howto/fix-excel-online-retrieving-data-error/feed/ 3 https://www.groovypost.com/howto/change-axis-labels-and-positions-in-excel/ https://www.groovypost.com/howto/change-axis-labels-and-positions-in-excel/#respond Wed, 10 May 2023 17:00:18 +0000 https://www.groovypost.com/?p=242123 If you're using charts in Excel, the default axis labels may not be ideal. Learn how to change axis labels and positions in Excel.]]> https://www.groovypost.com/howto/change-axis-labels-and-positions-in-excel/feed/ 0 https://www.groovypost.com/howto/find-and-remove-external-links-in-excel/ https://www.groovypost.com/howto/find-and-remove-external-links-in-excel/#comments Wed, 26 Apr 2023 20:30:23 +0000 https://www.groovypost.com/?p=241405 Outdated or broken external links can cause issues with your Excel spreadsheets. Learn how to find and remove external links in Excel in this guide.]]> https://www.groovypost.com/howto/find-and-remove-external-links-in-excel/feed/ 1 https://www.groovypost.com/howto/convert-a-zero-to-a-dash-in-excel/ https://www.groovypost.com/howto/convert-a-zero-to-a-dash-in-excel/#respond Fri, 24 Mar 2023 14:05:28 +0000 https://www.groovypost.com/?p=239703 Zeroes in Excel are still registered as numbers by functions such as COUNT. Learn how to convert a zero to a dash in Excel.]]> https://www.groovypost.com/howto/convert-a-zero-to-a-dash-in-excel/feed/ 0