Hidden Cells

S

sgrech

Sorry another issue. I have a spreadshseet with values in A1 B1 & C1.
Column B is hidden. I want to copy the values in A1:C1 and paste these
into F1:G1 but i don't want the value in hidden cell (B1) to be included
in the pasted items.

Cheers
Simon
 
D

Dave Peterson

Try selecting your range (A1:C1)
edit|goto|special
visible cells only
edit|copy

Select F1
edit|paste

(but if it's really only two cells, I'd just copy them one at a time.)
 
D

Dave Peterson

If you pasted into G1, then check to see if column H is hidden--maybe you pasted
into a hidden column.
 

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

Top