Unlock the potential of Excel’s TEXTJOIN function and revolutionize the way you handle text manipulation! Say goodbye to scattered data across cells and embrace the simplicity of merging text effortlessly. Dive into our comprehensive guide to discover how TEXTJOIN transforms your concatenation woes into seamless, efficient solutions. Master the art of combining text strings in… Continue reading TEXTJOIN in Excel: Mastering Text Concatenation
Category: General
Paste to Visible Cells Only: How to Skip Filtered Out Cells
You have copied a cell and want to paste it to multiple other cells. Sounds easy, right? But what if you only want to paste this value to all visible cells? So that you skip all filtered out or hidden cells in-between? It’s also very easy but requires one more small step. Here is how… Continue reading Paste to Visible Cells Only: How to Skip Filtered Out Cells
How to Fill Down Empty Cells With Values From Above
You work with a table or PivotTable and have an issue: Only the first item is filled. The cells underneath are blank, indicating that the first cell should repeat. Here is how to easily fill down the first filled cell for all blank cells underneath. Example: Fill down empty cells with values from above Let’s… Continue reading How to Fill Down Empty Cells With Values From Above
Greek Letters: How to Insert Alpha, Delta, Omicron in Excel
In Mathematics, many Greek letters have meanings. For example, the delta symbol, or the sigma character. Also, with nowadays naming the COVID-19 variants after Greek letters, you might need to use them in Excel. Here are 5 simple methods of how to add them to Excel cells and to use them in Excel charts –… Continue reading Greek Letters: How to Insert Alpha, Delta, Omicron in Excel
Per Mille ‰: How to Show Excel Values per Mille
Working with percent values in Excel is very easy and convenient. In some cases, however, you want to work with per mille values. My impression: It was not really considered when Excel was developed. In this article, you will find three main methods, each with different options to insert per mil (or: parts per thousand).
Harvey Balls: How to Insert Filled Circles ഠ◔◑◕⬤ in Excel
Harvey Balls are circles filled to some level with color. Or, as Wikipedia says, “are round ideograms used for visual communication of qualitative information”. If you want to use them in Excel, you have two options: Make them dynamic with conditional formatting rules or fix them by inserting them as characters. Here is how to… Continue reading Harvey Balls: How to Insert Filled Circles ഠ◔◑◕⬤ in Excel
Delta ∆: How to Easily Insert Difference Sign “∆” in Excel
The capital Greek letter Delta (∆) stands for difference or increment in Mathematics. In some cases, it would also help to use it in Excel: Instead of writing “Difference” or “Change”, you could simply insert the Delta sign. Here is how to do that in Windows and Mac!
Ʃ: How to Easily Insert Sum / Total Sign “Ʃ” in Excel
You have created a nice dashboard in Excel? Or a beautiful Profit and Loss calculation? Now, you want to bring it to the next level: Insert the sum or total sign, the Greek character sigma: Σ. In general mathematics, uppercase Σ is used as an operator for summation. Here is how to quickly do this in Excel!
Fun in Excel: 6 Ways of Fun with Spreadsheets
Let’s have some fun in Excel! You probably do your work with spreadsheets, but there are also ways of having fun in Excel. In this article, we introduce you to 6 fun applications for Microsoft Excel.
How to Quickly Insert Check Mark Symbols in Excel Cell
When it comes to presenting your Excel results beautifully, you might want to use check mark (or tick ) symbols or (as the opposite) “x” characters. Here is how to quickly do that – either inserting them directly into cell or returning them from an Excel formula.