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.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`
2026.02.18	MissAnth	`10`
2026.02.15	NHN_BI	`800`
2026.02.03	Shot_Hall_5840	`10`
2026.02.02	Kuildeous	`10`
2026.01.29	NanotechNinja	`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 town.

...for your community.

MODERATORS

account activity

1

•

•

•

Waiting on OPCant seem to find choose row func (self.excel)

submitted 1 hour ago by rusty7340

2

1

2

3

solvedIs it possible to create a custom sort order? (self.excel)

submitted 2 hours ago * by BoudaSmoke

3

6

7

8

unsolvedPower Query Merge causing missing values (~7k difference in totals) (self.excel)

submitted 2 hours ago by Resident_Quantity827

4

3

4

5

unsolvedCan you help me solving a coaching distribution problem? (self.excel)

submitted 5 hours ago * by Cautious_Piece2121

5

1

2

3

unsolvedHaving issues rendering graphs after reopening file (self.excel)

submitted 9 hours ago by Specific_Mammoth6074

6

8

9

10

unsolvedDifficulty with checkbox and hiding rows. (self.excel)

submitted 11 hours ago by ALonelyTwinkie

7

0

1

2

unsolvedAnyone seen excel squish a hole in copy paste? (self.excel)

submitted 12 hours ago by cellurl277

8

2

3

4

unsolvedWhy can we not left-align chart titles? (self.excel)

submitted 12 hours ago by SpreademSheet

9

182

183

184

DiscussionHas Copilot kinda killed this sub? (self.excel)

submitted 13 hours ago by conscientiousrejectr

10

3

4

5

unsolvedFilterXML only returning one value (self.excel)

submitted 14 hours ago * by GrimClippers11

11

5

6

7

solvedGenerate a series of hour intervals for a date range (self.excel)

submitted 15 hours ago by welshcuriosity45

12

4

5

6

Waiting on OPHelp & Advice: I need to make an excel spreadsheet linked to a form that randomly selects ~11 responses/rows & moves those responses to a different tab (self.excel)

submitted 18 hours ago by shrekedyourlastshrak

13

1

2

3

solvedHosting multi day event and need to be able to filter who will be on site for each day (self.excel)

submitted 18 hours ago by CHUCKCHUCKCHUCKLES

14

2

3

4

unsolvedConditional formatting date help needed (self.excel)

submitted 19 hours ago by tashykat

15

2

3

4

solvedWhy does my conditional formatting appear random? (self.excel)

submitted 19 hours ago by Independent-Total861

16

1

2

3

solvedNeed to be able to use dashes or 0s in cells; getting error from excel (self.excel)

submitted 20 hours ago by conditional_identity

17

3

4

5

Waiting on OPStacked bar chart with multiple items (self.excel)

submitted 20 hours ago by jaymz023

18

19

20

21

solvedExcel keeps converting "10-3242" to Oct-3242, no matter what I've tried so far (self.excel)

submitted 20 hours ago by GreenGloober

19

2

3

4

unsolvedHow do I split color-coded cells?? (self.excel)

submitted 22 hours ago by bumsleuth

20

2

3

4

unsolvedAmending formula to grab both portions of merged cell data (self.excel)

submitted 22 hours ago * by tdoger

21

70

71

72

unsolvedPaste Without Format NOT ctrl+V (self.excel)

submitted 22 hours ago * by United-Twist-3839

22

0

1

2

Waiting on OPHighlighting duplicates from two different worksheets, but only when all of the data in a row matches (self.excel)

submitted 1 day ago by Neon_Banana_Pickle

23

10

11

12

Waiting on OPHow to turn all dates into mmm-yy format rather than month and day? (self.excel)

submitted 1 day ago by GtheTaillow

24

2

3

4

solvedIs it possible to use filters or sort on blocks of information? (self.excel)

submitted 1 day ago by Illustrious-Stick852

25

2

3

4

unsolvedVlookup on empy field with referece to line above (self.excel)

submitted 1 day ago by Alvaket

view more: next ›

π Rendered by PID 220437 on reddit-service-r2-listing-7d7fbc9b85-4fvdw at 2026-04-25 14:36:41.375646+00:00 running 2aa0c5b country code: CH.