Showing posts with label Data Validation. Show all posts
Showing posts with label Data Validation. Show all posts

How not to fill filtered out cells when dragging down from another sheet

Steps: Apply your filter in Sheet1 . Select the range where you want to paste the formula (e.g., A2:A100 ) but only visible cells will...