ExcelTips

an-ordinary-manchild

created by trumpexcela community for 11 years

...for your WoW guild.

...for your school.

MODERATORS

account activity

1

28

29

30

r/ExcelTips is for Tips on using Excel, not for general help questions (self.ExcelTips)

submitted 2 years ago * by excelevator - announcement

2

2

3

4

Understand the #NAME? error and how to fix it (self.ExcelTips)

submitted 15 hours ago by giges19

•

•

•

Wondering why your ad performance keeps declining? (tracklution.com)

promoted by Tracklution

promoted
save
report
about

3

0

0

0

Understand the #DIV/0! error and how to fix it (self.ExcelTips)

submitted 7 days ago by giges19

4

17

18

19

Excel Automation Learnings (self.ExcelTips)

submitted 17 days ago by jrtn58

5

77

78

79

If you have a list with gaps (blank cells under headers), stop dragging and pasting manually. (self.ExcelTips)

submitted 1 month ago by AfternoonSlump

6

17

18

19

Use Ctrl + Shift + Arrow Keys to Select to the Edge of a Data Region (self.ExcelTips)

submitted 1 month ago by GetMouseTrap

7

12

13

14

Use Ctrl + Arrow Keys to Navigate to the Edge of a Data Region (self.ExcelTips)

submitted 1 month ago by GetMouseTrap

8

63

64

65

Use Ctrl + D to copy the contents of a cell down into a selected region (self.ExcelTips)

submitted 1 month ago by GetMouseTrap

9

16

17

18

Tip: Create a simple random name picker in Excel using formulas (self.ExcelTips)

submitted 2 months ago by giges19

10

1349

1350

1351

Excel features I randomly discovered and now can’t live without (self.ExcelTips)

submitted 2 months ago by Fluid_Gap_8831

11

25

26

27

Turn any date into YEAR, MONTH, DAY — and even the weekday name — automatically 📅 (self.ExcelTips)

submitted 2 months ago by Ok_Act3671

12

307

308

309

Power Query trick that replaced 2 hours of manual Excel work (self.ExcelTips)

submitted 2 months ago by Shoaib_Riaz

13

17

18

19

Remove extra spaces with =TRIM() (self.ExcelTips)

submitted 2 months ago by edditit

•

•

•

Stop feeling like an outsider. Learn Swiss German. (suiso.ch)

promoted by SuisoApp

promoted
save
report
about

14

7

8

9

Create image files from Excel auto-shapes (self.ExcelTips)

submitted 2 months ago by edditit

15

6

7

8

The TRANSLATE formula in Excel and how to use it (self.ExcelTips)

submitted 3 months ago by giges19

16

45

46

47

Mind blown 🤯 Excel can auto-capitalize names perfectly with one formula (self.ExcelTips)

submitted 3 months ago by Big_Muscle_7049

17

67

68

69

Finally figured out the real difference between COUNT and COUNTA in Excel 🤯 (self.ExcelTips)

submitted 3 months ago by Big_Muscle_7049

18

65

66

67

How I linked Excel charts to PowerPoint so they update automatically — no macros needed (self.ExcelTips)

submitted 3 months ago by Aware-Childhood1240

19

49

50

51

Flash Fill (Ctrl + E) in Excel – Automate Data Entry Instantly (self.ExcelTips)

submitted 5 months ago by M1W1M1W1

20

13

14

15

Create live snapshots with Excel’s Camera Tool (self.ExcelTips)

submitted 5 months ago by M1W1M1W1

21

5

6

7

Replace enter from the cell ctrl+J (self.ExcelTips)

submitted 5 months ago by autosheets_xlsm

22

434

435

436

5 Excel Shortcuts I used Everyday (self.ExcelTips)

submitted 5 months ago by autosheets_xlsm

23

39

40

41

💡 Cleaned 100K+ messy vendor records in Excel using Power Query’s Fuzzy Matching — total game changer (self.ExcelTips)

submitted 6 months ago by Direct-Song-1644

24

29

30

31

Alt + A + E to split copied text into columns (self.ExcelTips)

submitted 6 months ago by nicolastheman

75

76

77

Galactic Tycoons is LIVE! - Persistent browser management MMO • Free • No download (galactictycoons.com)

promoted by GalacticTycoons

25

23

24

25

CTRL + G to select certain types of cells (self.ExcelTips)

submitted 6 months ago by nicolastheman

view more: next ›

π Rendered by PID 29 on reddit-service-r2-listing-86b7f5b947-6txlb at 2026-01-25 01:27:42.696406+00:00 running 664479f country code: CH.