Ask Experts Questions for FREE Help !
    Annhelpmehomewk's Avatar
    Annhelpmehomewk Posts: 5, Reputation: 1
    New Member

    Sep 15, 2013, 01:07 PM
    Copy visible cell only
    How do I copy and paste visible cells in another column in the same worksheet with out the hidden cells copying also. If it can't be done is there an east macro to do the same thing?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man

    Sep 15, 2013, 01:48 PM
    You can use the Ctrl Key to select non contiguous ranges.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert

    Sep 15, 2013, 05:55 PM
    1) Select the range of cells to copy
    2) Ctrl-G opens the Go to window
    3) Select Visible cells only
    4) Now copy and paste.

    Video example

Not your question? Ask your question View similar questions


Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.

Check out some similar questions!

Copy cell down... When another is filled [ 7 Answers ] I have a form that fills col A to E. Have "if" formula in F. What is the best way to have the "if" formula copied Down every time a new entry is added ? I would like it dynamic... as not to just copy the "if" formula

Copy of cell phone bills [ 2 Answers ]

How can I get a copy of my friend's cell phone bill showing outgoing and incoming calls?

Copy of cell phone bills [ 2 Answers ]

I want to know if there is a way of getting a copy of a celular phone bill

Copy Of Cell Phone Bill [ 4 Answers ]

I Recently Returned From Out Of Town To Find That My Wife To Be Had Pretty Much Cleaned Me Out And Has Taken My Son And Will Not Give Me An Address Or Number. I Have Her Ssn, Cell Phone Number, And Dob. Is It Possible For Me To Get A Detailed Copy Of Her Cell Bill For The Last 4 Months?

View more questions Search