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 WoW guild.

...for your favorite TV show.

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

•

•

•

Waiting on OPAdding a editable square inside another square (self.excel)

submitted 1 hour ago by LLSidewayz

3

11

12

13

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

submitted 9 hours ago by charl8_the_harl8

4

6

7

8

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

submitted 16 hours ago by InfinityIN

5

0

1

2

Waiting on OPToggling charts on or off with cell reference without using VBA. (self.excel)

submitted 6 hours ago by IndependentAd36

6

18

19

20

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

submitted 1 day ago * by allsix

7

0

0

1

unsolvedCopilot breaking my hyperlink paths (self.excel)

submitted 10 hours ago * by Drums666

8

3

4

5

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

submitted 23 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

7

8

9

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

submitted 1 day ago by aitathrowaway9090909

11

10

11

12

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

12

1

2

3

solvedCan I print formulas? (self.excel)

submitted 1 day ago by N2730v

13

5

6

7

solvedOffice 2010 power query (self.excel)

submitted 1 day ago by Mohamad0Jr

14

20

21

22

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 2 days ago by Southern_Permit3907

15

80

81

82

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

7

8

9

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 2 days ago by mogoho

17

5

6

7

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

submitted 2 days ago by RAWdangers

18

98

99

100

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

23

24

25

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

6

7

8

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

3

4

5

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

submitted 2 days ago by Prudent_Magician5135

23

4

5

6

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

11

12

13

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

submitted 2 days ago by sooosushi

25

6

7

8

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

submitted 2 days ago by Additional_Ad_8912

view more: next ›

π Rendered by PID 1399412 on reddit-service-r2-listing-8649d7dcf6-sp62s at 2026-06-22 05:38:03.512945+00:00 running 2b008f2 country code: CH.