Learn Excel Episode 445: Filter Copying
A question from Mike in Oklahoma City. Excel is supposed to copy only the visible rows in a dataset where AutoFilter is turned on. However, sometimes this does not work. Episode 445 shows the simple shortcut to make sure that you have only the visible rows.