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.
 

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

Inserting a Copied Row inside a table 6
"Insert Copied Cells" dysfunctionality when data is filtered 0
Insert copied cells behavior is bizarre; doesanyone know the whole story? 0
How do I "insert copied cells"? used to be "alt i e" still work 1
array-to-row autofilter issue 3
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Controlling Insert Copied Cells 13
Copy row, Insert>Copied>Cells crashes Excel 0

Top