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

How to Change Proofing Language in the Whole PPT Presentation

Often, after working with Excel, you want to present your results in PowerPoint. The problem, especially when working internationally with different language settings involved: The proofing language often seems to have its own life. It’s often troublesome to continuously tell PowerPoint which language to use. Here are three simple (and two of them very fast)… Continue reading How to Change Proofing Language in the Whole PPT Presentation