Selecting visible cell only

To select visible cells only first select the range and then press

Alt + ;

You can then copy and paste only paste the visible cells.

Any visible formulas are converted to values.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.