Online Excel Tips – Blog – Trump Excel
Repeat Rows N Times in Excel
If you want to repeat rows in your dataset N number of times (say 5 or 7 times), or based on a valu…
Read more
Online Excel Tips – Blog – Trump Excel
Create All Possible Combinations from Lists in Excel
I was recently working on a project where I had multiple lists in Excel and I had to create all the…
Read more
Online Excel Tips – Blog – Trump Excel
Create Data Validation List from Excel Table as Source
A common complaint of many Excel users is that they can’t directly use Excel table’s structured ref…
Read more
Online Excel Tips – Blog – Trump Excel
Enable Dark Mode in Microsoft Excel
Getting Dark Mode has been one of the most requested features for Microsoft Excel and finally the d…
Read more
Online Excel Tips – Blog – Trump Excel
How to Filter Strikethrough in Excel
Recently I was working on a project where I had to filter all the cells that had strikethrough form…
Read more
Online Excel Tips – Blog – Trump Excel
How to Write Vertically in Excel
Sometimes you may want to write text vertically in Excel to save space and make your data more pres…
Read more
Online Excel Tips – Blog – Trump Excel
Return to Normal View in Excel
Excel has three types of worksheet views: In most cases, you will be working with the Normal view. …
Read more
Social Plugin