Tag Archives: Visible cells only

Hidden Rows vs. Filtered Rows

One day, a friend asked me: “If she deletes contents from a filtered range, would she also delete the hidden content?” ┬áI answered: “Try and observe!” ­čśŤ I know that is not the answer she expected. ┬áNevertheless, I believe that … Continue reading

Rate this:

Posted in Excel Basic | Tagged , | Leave a comment

Another useful tips with Go to Special – Visible cells only

This is an extension of the previous post that talks about Go to Special -> Visible cells only Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally. ┬áSound … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment