hidden rows, column copy-paste

O

oldyork90

I realize the error I made in hiding rows where I did so don't pound me on this.

I have a sheet with hidden rows smack in the middle of a "table". If the user does a copy-paste down a column he gets an error. These hidden rows are locked and the sheet is protected. This is good but annoying. The errorwill confuse him. I guarantee I'll get a call.

Is there something that can be setup in Excel that says skip hidden cells when pasting? If the user is going to want to copy-paste that's what he'll do. And there is no way he is going to follow a special process when doingso.

I suspect I'll have to live with it for now and redo the table next.

thanks
 

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

Copy addition formula of non-consecutive horizontal cells 2
How to paste this down? 3
Dealing with a Pivot Table (when I don't want to) 0
Copy columns and paste with blank column between 5
Sort partially hidden data 1
Setting column width in a table with a macro is not working 0
copy text and logo from protected, hidden sheet 1
Want to Copy and paste to new sheet range except hidden rows. 4

Top