•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
This Week's /r/Excel Recap for the week of April 04 - April 10, 2026
Our take
Welcome to this week’s recap of the /r/Excel community, covering highlights from April 4 to April 10, 2026. This week, discussions revolved around the enduring relevance of Excel, with a notable post questioning why some "experts" believe the tool is on the decline. Unsolved queries featured challenges like automating image sending from Excel to WhatsApp and creating specific chart types. Engaging comments emphasized the importance of simplicity in formulas and the ongoing need for Excel in data analysis.
Saturday, April 04 - Friday, April 10, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 621 | 179 comments | [Discussion] Why do "experts" insist that Excel is going to die when it is the most indestructible tool in the global economy? |
| 16 | 17 comments | [unsolved] auto send picture to whatsapp from excel |
| 16 | 69 comments | [unsolved] How to make a mathematical formula operate in the same cell in which I input a number? |
| 15 | 8 comments | [Waiting on OP] How to make Excel to stop seeing E as a scientific notation in a column |
| 15 | 26 comments | [unsolved] Database Spreadsheet and a separate Dashboard |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 10 | 13 comments | [unsolved] Can I change data in one worksheet and have it change in all others |
| 4 | 15 comments | [unsolved] Daily account balance variance analysis |
| 3 | 7 comments | [unsolved] Combining Tables that feed from another data set |
| 3 | 4 comments | [unsolved] Trying to create a box and whisker (?) chart without the box. |
| 3 | 13 comments | [unsolved] how to consolidate a one date column, into multiple month columns? |
Top 5 Comments
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- This Week's /r/Excel Recap for the week of April 18 - April 24, 2026Saturday, April 18 - Friday, April 24, 2026 Top 5 Posts score comments title & link 26 22 comments [solved] How to use AND and OR conditions within the same formula 18 15 comments [unsolved] Power Query Rounding Issue 13 21 comments [Waiting on OP] How to handle data from different sources when columns are in different orders? 6 5 comments [unsolved] Excel buffering while working between 2 workbooks 4 13 comments [unsolved] Vlookup on empy field with referece to line above Unsolved Posts score comments title & link 4 13 comments [unsolved] Calculating moving range in power query 4 16 comments [unsolved] how to record the exact time that I Click on a check box? and that the record will not change. 3 10 comments [unsolved] What formula(s) would I use to populate a cell depending on the info of an adjacent cell? 3 7 comments [unsolved] Automate copy from one worksheet to another using a cell reference 3 10 comments [unsolved] Generating a roll call based on recent meeting attendance Top 5 Comments score comment 637 /u/leostotch said The last time I asked copilot for Excel help, it made up an imaginary function. 208 /u/radek432 said When you perform the operation (0.9 - 0.6 - 0.3), Excel is actually dealing with tiny "remainders" created by the conversion to binary: 0.9 -> 0.89999999999999991118... 0.6 -> 0.59999999999... 165 /u/RoleNo3531 said =SUBSTITUTE(A1,"-","") 112 /u/Pestilence_XIV said To answer you question to be best of my knowledge, no. However, you could have them paste into an import sheet where formatting doesn’t matter, then you pull the data from that sheet into the one wi... 105 /u/icleanupdirtydirt said Nah. I've dabbled with copilot to do more complex things for me. It frequently seems to just pick the wrong reference cells even when explicitly told which to use. The formulas also just don't work ha... submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of May 02 - May 08, 2026Saturday, May 02 - Friday, May 08, 2026 Top 5 Posts score comments title & link 321 26 comments [Discussion] Copying a cell in Excel spikes CPU to over 50% 267 186 comments [Discussion] Is excel still worth learning as a skill in 2026? 164 76 comments [Discussion] How many GB of RAM is required make a sheet with all cells filled? 29 28 comments [Discussion] Excel Test to Determine Skill 28 58 comments [unsolved] How to deal with a bulky spreadsheet that is starting to hit the limits of Excel? Unsolved Posts score comments title & link 27 16 comments [unsolved] How to disable new floating Copilot icon in all Excel windows? 5 5 comments [unsolved] Excel in page layout - How to remove pages without any content? 5 4 comments [unsolved] How to confront multiple sheets against each other? 4 9 comments [unsolved] How to make a drop down list based on static values of cells in column beside list 4 15 comments [unsolved] Formula to identify cells that may be a match to another cell in the same column. Not quite a duplicate. Top 5 Comments score comment 975 /u/Sinjazz1327 said Yes. The entire world runs on Excel. Even if you've got a software that replaces Excel, if you want it to talk to your own second software or your client's software you need Excel because the two a... 950 /u/MightyArd said No chance getting paid extra to make a spreadsheet for your current employer. Building it on your own time is likely relevant. You may get some internal kudos, but that's about it. 279 /u/Way-In-My-Brain said No multi national I've worked at is going to pay you for a spreadsheet you built in personal time to solve an in house problem. Not to mention I expect you're salaried and have a contract that covers ... 207 /u/ThorHammer1234 said A high school senior can do what you can with a simple AI prompt. Don’t double down, expand your skills. Launching an Excel course now is like buying a lottery ticket for a prize that was already draw... 186 /u/samspopguy said Yes to excel no to only excel submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of April 11 - April 17, 2026Saturday, April 11 - Friday, April 17, 2026 Top 5 Posts score comments title & link 82 22 comments [Pro Tip] Get more from Power Query in Excel with these little-known capabilities 33 48 comments [solved] How to anonymize user names in a data set 16 17 comments [solved] Populate Cells From a Random Range of Cells, Based on the Contents of Different Cells. 12 8 comments [solved] Formula for vlookup + text or text + vlookup 9 11 comments [unsolved] Search Bar thats acts like a Slicer Unsolved Posts score comments title & link 3 7 comments [unsolved] Weird Excel double-decimal places Top 5 Comments score comment 81 /u/Normalitie said Try SUM(C.:.C) Note the periods before and after the colon, this causes Excel to omit blank rows above and below the data. 55 /u/bradland said This is good stuff for PQ in general, but I find it a bit odd that it is titled "Get more from Power Query in Excel" and then kicks off the conversation with Parameters. Parameters I almost ne... 53 /u/downtownjerm said Are the exports the same every time? It’s not pretty but you could set up a template with lookups to pull the data into a cleaner view. Then when you export the files just paste over the previous data... 32 /u/reggydavis said While the formats may vary bank to bank, each bank should be the same output every month. You’re going to need to build an individual power query for each bank in the format you want. 27 /u/AlgoDip said Guess you won’t be using it for much longer then submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of April 25 - May 01, 2026Saturday, April 25 - Friday, May 01, 2026 Top 5 Posts score comments title & link 9 11 comments [unsolved] How do I get slicers to work with a pivot table with multiple value tables, and also displayed in an easily legible way? 8 12 comments [unsolved] How Can I Move The Formula Bar? 2 17 comments [solved] Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours 2 9 comments [solved] Formula for calculating regular and overtime hours based on a full week with an 8 hour day. 2 13 comments [unsolved] Use of text sequence formula vertically Unsolved Posts score comments title & link 2 8 comments [unsolved] Stop excel from jumping while scrolling Top 5 Comments score comment 333 /u/guy_incognito784 said Found the person who’s never had to scale a company before. If I’m the only one ingesting the info and a handful of other people and the company is small, sure this all works just fine. 172 /u/leostotch said I've had to do Excel assessments before (they're universally awful in my experience), but having to do one while somebody is watching? I promise, you don't want to see how the sausage gets ... 123 /u/Woosafb said The year was 2017 and I needed a way to unpivot columns. 113 /u/seventypercentcacao said you wont always be available to fix something when it breaks, imo using helper columns allow your colleagues to debug the formulas with much more ease 109 /u/FrankDrebinOnReddit said No freaking way. About half of my problems at work come from people using Excel for more than what it does well. That million rows limitation alone comes and goes quickly when you consider accounting ... submitted by /u/subredditsummarybot [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#generative AI for data analysis#AI formula generation techniques#conversational data analysis#formula generator#data analysis tools#natural language processing for spreadsheets#big data management in spreadsheets#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data cleaning solutions#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications