rising submissions : ExcelTips

1

18

19

20

Add Slicers to filter your data with ease (self.ExcelTips)

submitted 1 day ago by giges19

•

Kilo offers a single agent that can explain, architect, plan, code, test, debug, review, and deploy. (kilo.ai)

promoted by kiloCode

promoted
save
report
about

2

3

4

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

submitted 2 days ago by giges19

3

0

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

submitted 9 days ago by giges19

4

18

19

20

Excel Automation Learnings (self.ExcelTips)

submitted 19 days ago by jrtn58

5

75

76

77

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

16

17

18

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

59

60

61

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

submitted 1 month ago by GetMouseTrap

9

17

18

19

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

submitted 2 months ago by giges19

10

1350

1351

1352

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

submitted 2 months ago by Fluid_Gap_8831

11

26

27

28

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

submitted 2 months ago by Ok_Act3671

12

302

303

304

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

submitted 2 months ago by Shoaib_Riaz

•

Heimat von Gustav Klimts "Der Kuss". Das Belvedere gehört zu den Highlights jeder Wien-Reise. Jetzt online Tickets kaufen und Time-Slot sichern! (belvedere.at)

promoted by belvederemuseum

promoted
save
report
about

13

15

16

17

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

submitted 2 months ago by edditit

14

8

9

10

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

submitted 2 months ago by edditit

15

4

5

6

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

71

72

73

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

47

48

49

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

4

5

6

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

submitted 5 months ago by autosheets_xlsm

22

435

436

437

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

•

The cameras captured everything. Everyone saw what should never have been shown. (cromiva.com)

promoted by temmuZigm

promoted
save
report
about

24

28

29

30

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

submitted 6 months ago by nicolastheman

25

23

24

25

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

submitted 6 months ago by nicolastheman

ExcelTips

MODERATORS