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.
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.