Why no "insert copied cells"?


W

wal

Excel 2007

There is probably an easy solution to this...

On a completely blank worksheet, if I select an entire row or rows,
copy, and point to Home > Cells > Insert, an item titled "Insert
Copied Cells" appears. It is also available on the Right-Click menu.

On another sheet, with a fair amount of formatting, hidden columns,
macro buttons, etc., "Insert Copied Cells" does not appear --
including when I make sure to unprotect the sheet.

NEVER MIND. I figured it out -- but I'll leave the post for the next
confused user.

If you have AutoFilter enabled, Insert Copied Cells will not appear.
Turn off filtering first.
 
Ad

Advertisements


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