This Week's /r/Excel Recap for the week of May 23 - May 29, 2026
Our take
The recent discussions in the /r/Excel community during the week of May 23 to May 29, 2026, reveal an ongoing debate about the relevance of traditional spreadsheet tools in an increasingly digital and collaborative environment. Notably, the top post asked whether users still prefer Excel over Google Sheets for daily work, indicating that many professionals are reassessing their tool choices as they navigate the complexities of modern data management. This conversation is not merely academic; it underscores a critical moment in how we approach productivity and collaboration in our workflows. For instance, related topics like Extremely unorganized ERP data and VBA code for pulling a number at the end of another sheet illustrate the practical challenges users face when working within legacy frameworks and the need for innovative solutions.
The lively discussions surrounding preferences for Excel or Google Sheets highlight a fundamental question: what does productivity mean in the context of data management? Users are seeking tools that not only accommodate their immediate needs but also provide flexibility and robustness for future demands. The sentiment expressed by many users that Excel remains superior in functionality, as echoed by comments like, "Google Sheets has barely a fraction of Excel functionality," reflects a lingering attachment to established tools that have long been the backbone of data analysis. However, as users also grapple with challenges like the integration of AI and automation—illustrated by posts questioning how to remove AI features from Excel—there is a clear tension between the comfort of legacy systems and the push toward more innovative, integrated solutions.
Moreover, the unresolved queries in the community, such as how to transfer data from PDFs to Excel or auto-fill blank cells, further emphasize the need for accessible methodologies that streamline these processes. The fact that users are still wrestling with these basic tasks suggests there is a significant opportunity for solutions that simplify these complexities. As we consider the future of spreadsheets, it is essential to empower users to transcend these limitations, creating environments where data management is intuitive and seamlessly integrated into their daily workflows.
In looking ahead, the dialogue within the /r/Excel community serves as a microcosm of a larger trend in how we interact with technology. As businesses and individuals continue to seek greater efficiency and adaptability, the challenge will be to balance the power of established tools like Excel with the collaborative advantages offered by cloud-based alternatives like Google Sheets. This evolution raises important questions: Will legacy tools adapt to meet new user needs, or will they become relics of a bygone era? As we strive for more innovative and human-centered solutions, the key lies in fostering environments that not only encourage exploration but also empower users to redefine their data journeys. Thus, it will be crucial to watch how these discussions evolve and what innovations emerge to address the pressing needs expressed by users this week.
Saturday, May 23 - Friday, May 29, 2026
Top 5 Posts
| score | comments | title & link |
|---|---|---|
| 285 | 340 comments | [Discussion] Do people still prefer Excel over Google Sheets for daily work? |
| 192 | 59 comments | [unsolved] How to remove this copilot thing ? |
| 79 | 32 comments | [unsolved] Do you guys actually use Excel's native "Trace Dependents" for massive files, or is it just an obscure relic? |
| 23 | 38 comments | [unsolved] Confirm character count without the LEN function |
| 21 | 15 comments | [solved] Summarizing data by row and column headers |
Unsolved Posts
| score | comments | title & link |
|---|---|---|
| 20 | 44 comments | [unsolved] How do I convert a Train Timetable into an Excel Document? |
| 20 | 41 comments | [unsolved] Is there a way to auto-populate blank cells with a center-aligned dash? |
| 16 | 34 comments | [unsolved] How would you structure an excel/google sheets file to track multiple banks, savings, credit cards, loans, and cash? |
| 14 | 35 comments | [unsolved] Transferring a table from a PDF to Excel |
| 12 | 16 comments | [unsolved] Formula for an Average that Reduces each Month |
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 May 09 - May 15, 2026Saturday, May 09 - Friday, May 15, 2026 Top 5 Posts score comments title & link 113 22 comments [Discussion] All You Need Is SWITCH 110 213 comments [Discussion] When people ask you, what's your excel level? What would you say? 95 56 comments [unsolved] How to get the copilot icon off my spreadsheet? 77 38 comments [unsolved] New accounting job - massive databases in Excel! 55 47 comments [Discussion] What unusual thing do you use excel for Unsolved Posts score comments title & link 12 8 comments [unsolved] Pulling data from one sheet to another conditionally 12 16 comments [unsolved] Excel Crashes w/ ODBC Query After Copilot Integration 9 15 comments [unsolved] Expanding Sheets in Workbook 9 13 comments [unsolved] many to many relationship problem 7 12 comments [unsolved] Copying data from website to excel? Top 5 Comments score comment 315 /u/ExistingBathroom9742 said This is square in Dunning Kruger. Im pretty good. I’m so good I know what my failings and shortcomings are, so I rate myself lower. But people who have told me they were good don’t seem to know anythi... 166 /u/swhitty17 said https://preview.redd.it/6gev577cp30h1.jpeg?width=1170&format=pjpg&auto=webp&s=cf1b27c81f5576fa33f875f06f6432fc24033db9 Crochet patterns! 129 /u/The8BitBat said Advanced beginner, always a google away from doing just about anything with excel - but I 100% need that google. 104 /u/Cannibale_Ballet said I hate how Microsoft keeps shoving Copilot everywhere but then when you need it to do something useful it has no idea what to do 101 /u/LowShake5456 said In SharePoint, there is a setting to have files Checked Out, that give exclusive editing privileges until the file is Checked In again. You can set a requirement on that file that editing can only be... 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 January 31 - February 06, 2026Saturday, January 31 - Friday, February 06, 2026 Top 5 Posts score comments title & link 100 52 comments [unsolved] Struggling to work with PDF data in Excel, feel like I’m missing something obvious 8 8 comments [unsolved] Assistance needed for Sage export - how to 'clean'? 5 6 comments [unsolved] Need support on a work tracker for my employees that will be a share document 3 6 comments [unsolved] How can I add two x-axis labels in a graph? 3 9 comments [solved] Count and sum cells with items decided by comers and “x” used for multiples Unsolved Posts score comments title & link 2 4 comments [unsolved] ctrl + [ for mac 2 17 comments [unsolved] Identify duplicate overlapping events Top 5 Comments score comment 323 /u/Difficult_Phase1798 said No. XLOOKUP is far superior to VLOOKUP 280 /u/Thiseffingguy2 said It was only a matter of time before “vibe coding” came for Excel… good lord, we’re doomed. 186 /u/MayukhBhattacharya said Its mainly because of Conditional Formatting, Circular References, Volatile Functions and unwanted formatting which can be avoided to large data sets. 184 /u/crabcountyreelestate said See table.buffer for a less convoluted workaround Edit: power query analyzes all your steps and performs them in the most optimal way according to their structure. Apparently sorting two ways back to... 121 /u/dexinfan said Try disabling automatic calculation; some formulas require re-calculating the whole sheet after eg. row deletion so it slows the whole workbook down. Also, XLSB may reduce the file size but not necess... submitted by /u/subredditsummarybot [link] [comments]
- This Week's /r/Excel Recap for the week of February 14 - February 20, 2026Saturday, February 14 - Friday, February 20, 2026 Top 5 Posts score comments title & link 9 12 comments [Waiting on OP] Turning a paragraph into excel data 7 19 comments [solved] Tools limited. How to automate multiple SQL server queries -> Excel workflow at work? 5 12 comments [Waiting on OP] BYROW with dynamic range, not working as expected? 5 12 comments [unsolved] Workbook from Microsoft Form encountering very long load times from excessive complex formulas 3 9 comments [unsolved] Conditional formulas when column groups are hidden? Unsolved Posts score comments title & link 2 0 comments [unsolved] Does advanced filtering work with sheetview? Top 5 Comments score comment 225 /u/loveLisega said formulas should definitely be protected by more than a color code. lock all cells that don't need user input and lock the sheet ! 202 /u/MayukhBhattacharya said My top recommendation before anything else, learn proper data structure first. Most beginners rush into formulas or Pivot Tables. But if the data is messy, everything feels harder than it should. Prop... 149 /u/soap_coals said Couldn't you use Sumifs() 123 /u/soap_coals said The only change for me has been to add additional steps to check for it and turn it off. It's also made me distrust documents produced by people who are new to the business. 109 /u/Parker4815-2 said Saves time. Chuck files in a folder. Hit refresh. Done. The problem is it takes time to setup and might go wrong a few times as steps are missed out (human error). That's when it gets hard to... submitted by /u/subredditsummarybot [link] [comments]