When we paste data on filtered rows it always past it on both visible and hidden rows. And if you are doing this for a huge set of data then I am sure you must be pasting it manually and
576 total views, no views today
Suppose you apply a formula in a cell and you get an error, the reason could be anything but the problem lies where you don’t want to share a report which contains errors. With the use of IFERROR we can
23,023 total views, no views today
How to Prevent Duplicate values through Data Validation
In this post we will see how we can prevent/stop any range to accept any duplicate values. We all know the power of Data Validation. We can do a lot of
426 total views, no views today
As most of us already use drop down lists through data validation but sometimes it makes much more sense to create a dependent drop down lists e.g. you create a drop down list in cell A1 and as you choose
477 total views, no views today