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

Filters: How to Use Filters in Excel

You received a large Excel table, possibly as output of a database system. The first approach when working with data in Excel is often the filter function, previously called “Autofilter”.