Copying data without hidden rows.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.
 
After selecting the range, press the F5 key, click on the Special button, and
check Visible Cells Only
 
After selecting the range, press F5 > Special > Visible cells only > OK.
Then do the copy > paste, and only the visible cells get copied/pasted
 
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

Excel Help to copy information from one row at a time to another sheet 1
Disabling copy/paste hidden cells 4
=counta() unless row is hidden 5
Copy subtotals without hidden rows 2
Exclude Hidden Row Values 4
SUMIFS including hidden rows 1
Hidden text in tables causes empty rows 0
hidden rows reappearing when using filter 2

Back
Top