Create List/Add Row

H

hjneedshelp

Hello,
I used the "Create List" function for a number of columns in a worksheet -
but not all.

I need to add a row, and I keep getting a message that says, "This operation
is not allowed. The operation is attempting to shift cells in a list on your
worksheet."

I can add a row IN a list, but it only adds it in one column and doesn't
carry it across the worksheet. It's when I try to add a row outside of a list
that I get the error.
Is there a way to correct this, so I can add/delete rows as needed?

Thank you, in advance.
 
D

Dave Peterson

Maybe you can convert each list back to a range, delete the row and then change
the ranges back to lists.
 

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