Copy only visible cells

  • Thread starter Thread starter Beezie
  • Start date Start date
B

Beezie

How would I go about copying cells without copying the
cells that have been hidden
 
Select the range you can see and do Edit / Go To / Visible Cells only, then do Edit / Copy and
then Edit / Paste wherever you like.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy and paste only visible cells from Excel using vbscript 0
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl 2
Don't update hidden cells 0
copy visible cells 1
Paste visible cells? 8
Disabling copy/paste hidden cells 4
hiden cells copied automatically to another workbook, can I stop . 2
Problem with Pasting into Filtered Fields 2

Back
Top