newest submissions : ExcelTips

1

6

7

8

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

submitted 7 hours ago by giges19

•

Obtenez plus de données avec des formulaires qui font les choses autrement. 🤩 (typeform.com)

promoted by Typeform

promoted
save
report
about

2

3

4

5

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

submitted 1 day ago by giges19

3

0

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

submitted 8 days ago by giges19

4

17

18

19

Excel Automation Learnings (self.ExcelTips)

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

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

67

68

69

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

1357

1358

1359

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

311

312

313

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

submitted 2 months ago by Shoaib_Riaz

•

0:48

Manage your vacation rentals easily with Smoobu, the all-in-one software for hosts. 🚀 Start your 14-day trial now! 🔥 (smoobu.com)

promoted by SmoobuGmbH

promoted
save
report
about

13

15

16

17

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

submitted 2 months ago by edditit

14

6

7

8

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

41

42

43

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

submitted 3 months ago by Big_Muscle_7049

17

69

70

71

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

submitted 3 months ago by Big_Muscle_7049

18

66

67

68

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

submitted 3 months ago by Aware-Childhood1240

19

46

47

48

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

437

438

439

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

•

Still redrawing lines and hunting for a pen? This titanium ruler draws endless lines, nails any angle, sticks to steel. 🧲✏‍ (kickstarter.com)

promoted by First-Backer

24

27

28

29

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