Fill-down vs copy/paste on protected sheets?

  • Thread starter Thread starter Jon Vinson
  • Start date Start date
J

Jon Vinson

I find that on protected sheets with ranges enabled for editing, fill-down
behaves differently from copy and paste. Fill-down is not allowed if the
top row contains formulas or blank cells. Copy and paste always works. Is
there a reason for this?


Alternatively, is there a way to prevent users from inserting or deleting
cells, while allowing all other editing features?
 
When I tried this in xl2002, it seemed to work ok for me--for both constants and
formulas. (Even filling down blanks worked ok.)

Did you select the range to be filled?

And you are writing about Edit|Fill|Down, right?
 
You must log in or register to reply here.

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

Macro to fill down automatically the number of rows in a spreadsheet 1
Series fill only copying and fill series greyed out 1
Macro to select all the filled cells in a worksheet? 42
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
looking for empty row to paste a range of copied cells 1
Inserting a Copied Row inside a table 6
sorting protected sheet not working 6
looking for an empty row to paste a range of copied cells 1

Back
Top