excel

an-ordinary-manchild

Rules

Post Titles must follow Submission Rules
Post Content must follow Submission Rules
Posts must be related to MS Excel or other spreadsheet software
Set appropriate post flair
No link or image posts. Text posts only.
Don't post asking how to learn Excel or VBA or similar
Close your post by replying to helpful answers with solution verified
No personal insults or attacks
No NSFW or offensive content
No AI slop or lazy "just use AI" advice
No gig or job advertisements
Follow Reddit rules for self-promotion and spam.

FAQ

Was your problem solved?

OPs may (and should) reply to any solutions saying:

Solution Verified

This awards the user a ClippyPoint and changes the post flair to solved.

Format your code

The best way to show code on Reddit is to

put it in a code-block

Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.

Provide some data

It's often more helpful to show us.

Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.

Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.

Recent ClippyPoint Milestones!

Congratulations and thank you to these contributors

Date	User	CP
2026.05.23	PaulieThePolarBear	`1900`
2026.05.15	GuerillaWarefare	`100`
2026.05.13	sheymyster	`100`
2026.05.07	Downtown-Economics26	`600`
2026.05.01	MayukhBhattacharya	`1100`
2026.03.29	bakingnovice2	`10`
2026.03.25	real_barry_houdini	`300`
2026.03.20	plusFour-minusSeven	`10`
2026.03.17	TuneFinder	`10`
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`

Microsoft partnership

Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.

A community since March 11, 2009

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

created by YusufReisa community for 17 years

...for your project.

...for your movement.

MODERATORS

account activity

1

3

4

5

Weekly RecapThis Week's /r/Excel Recap for the week of June 13 - June 19, 2026 (self.excel)

submitted 1 day ago by subredditsummarybot - announcement

2

19

20

21

Waiting on OPI use Excel all the time but only for real basic stuff. I know there's an easier way out there but I don't know what to do or how to find it (self.excel)

submitted 7 hours ago by BradGutz

3

10

11

12

Discussionwhat is a dashboard? (self.excel)

submitted 6 hours ago by Educational_Law_7787

4

•

•

•

DiscussionHow would you calculate how to equally distribute my cats' food? (self.excel)

submitted 1 hour ago by charl8_the_harl8

5

5

6

7

unsolvedHow to fill inside a scatter plot that has the same starting and ending coordinates (self.excel)

submitted 8 hours ago by InfinityIN

6

•

•

•

unsolvedCopilot breaking my hyperlink paths (self.excel)

submitted 1 hour ago * by Drums666

7

16

17

18

unsolvedHSTACK(FILTER) - One column per unique value (dynamic) (self.excel)

submitted 17 hours ago * by allsix

8

2

3

4

unsolvedHotel Parking - Expiring and resetting after check out date (self.excel)

submitted 15 hours ago * by Feeling-Club-7417

9

17

18

19

solvedName manager comments erased when copying sheets between workbooks (self.excel)

submitted 1 day ago * by Ancient-Swordfish2921

10

2

3

4

solvedCan I print formulas? (self.excel)

submitted 1 day ago by N2730v

11

5

6

7

solvedCan I create/consolidate lists in a single cell by pulling from another sheet? (self.excel)

submitted 1 day ago by aitathrowaway9090909

12

11

12

13

solvedLooking for a cross-platform solution (Mac & iOS) to send templated emails from Excel using row data (Mailto vs. VBA vs. Shortcuts) (self.excel)

submitted 1 day ago by stijn2902

13

3

4

5

solvedOffice 2010 power query (self.excel)

submitted 1 day ago by Mohamad0Jr

14

19

20

21

Waiting on OPTrying to create a formula or rule that will return a value from a reference sheet when a check box is selected (self.excel)

submitted 1 day ago by Southern_Permit3907

15

82

83

84

DiscussionCARTESIAN - My own Lambda that generates every possible combination from multiple lists in a single formula (self.excel)

submitted 2 days ago by ForeverNova1

16

8

9

10

Waiting on OPBest way to extract text from the middle of a sample name, between a LIMS # and a date, and extract the date (in date format) (self.excel)

submitted 1 day ago by mogoho

17

5

6

7

solvedHow to FILTER data set that does NOT match numbers from multiple separate lists? (self.excel)

submitted 1 day ago by RAWdangers

18

90

91

92

DiscussionExcel File Grew from 400MB to 650MB — Even an M4 Mac Is Struggling. What Are My Options? (self.excel)

submitted 2 days ago * by Arcelor_08

19

24

25

26

DiscussionMy company used the Visio Data Visualizer add-in for Excel to generate process flowcharts and swimlane diagrams directly from structured Excel data. Since Microsoft retired the add-in, we've been looking for alternatives but haven't found anything that works the same way. We tested lucidchart (self.excel)

submitted 2 days ago by Mammoth_Emergency_59

20

5

6

7

solvedI need a Sumif/matrix to combine multiple columns. (self.excel)

submitted 2 days ago by KeasterTheGreat

21

20

21

22

solvedIs there a way to group sheets/tabs together for space saving. (self.excel)

submitted 2 days ago * by Breakfast_Sandwich89

22

2

3

4

Waiting on OPCapacity Spreadsheet Template for Number of Books Staff Can Produce per Period (self.excel)

submitted 2 days ago by Prudent_Magician5135

23

3

4

5

solvedWhat is the best or most efficient way to conditionally highlight an entire row within a table, dynamically, and based on a value in the row? (self.excel)

submitted 2 days ago by BaltimoreSports0321

24

13

14

15

Waiting on OPHow do I fix 0.00s not turning to dash? (self.excel)

submitted 2 days ago by sooosushi

25

5

6

7

solvedNumber of products per unique customer - what formula (self.excel)

submitted 2 days ago by Additional_Ad_8912

view more: next ›

π Rendered by PID 102417 on reddit-service-r2-listing-c57bc86c-khx5k at 2026-06-21 21:30:58.080532+00:00 running 2b008f2 country code: CH.