3 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

This Week's /r/Excel Recap for the week of February 28 - March 06, 2026

Saturday, February 28 - Friday, March 06, 2026

Top 5 Posts

score comments title & link
12 10 comments [solved] Help calculating BMI percentiles using data set!
8 5 comments [Waiting on OP] Way to automate sending Excel screenshot to WhatsApp groups
7 9 comments [Waiting on OP] Scanning Barcodes on Excel
7 6 comments [Waiting on OP] Rearranging data syntax on a report
5 10 comments [unsolved] Need to know how to proceed with our company's service call excel sheet

 

Unsolved Posts

score comments title & link
5 6 comments [unsolved] Cant figure out bordersss!
4 12 comments [unsolved] Need to create a diagram of connected points
4 28 comments [unsolved] Creating a door access database
3 11 comments [unsolved] Excel Column Conditional Formatting
3 10 comments [unsolved] Automated pdf extraction into excel.

 

Top 5 Comments

score comment
408 /u/SolverMax said There's nothing wrong with adding a visual outline of a block of cells - provided the number of cells doesn't need to change, which would mess up the formatting. A Table structure is better for many ...
359 /u/bradland said Most of the people commenting here don't understand what you're asking. Excel has different types of protection. There's sheet level protection, workbook level protection, and file level encryption. T...
206 /u/shingfunger said I work as a consulting actuary and my colleagues and I use excel for hours a day. Everyone one I work with is comfortable with complex formulas, but honestly not that many use VBA or power query that ...
202 /u/SolverMax said I use both Python and Excel (including Power Query). They are different tools, suited to different things and different circumstances. One is not uniformly better than the other. Use whatever ...
166 /u/Informal-Freedom2558 said Ctrl + Shift + L to toggle filters on and off instantly… I use that way more than I thought I would. Also F4 to repeat the last action in Excel is lowkey elite, especially for formatting. And Alt + H ...

 

submitted by /u/subredditsummarybot
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#no-code spreadsheet solutions
#generative AI for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#enterprise-level spreadsheet solutions
#data visualization tools
#data analysis tools
#big data management in spreadsheets
#self-service analytics tools
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#enterprise data management
#big data performance
#data cleaning solutions
#rows.com
#automated anomaly detection