1) if you don't want the fill handle (little black dot in bottom-right
corner of selection) then deselect Allow cell drag and drop. This also
stops users stuffing up your formulas by dragging and dropping cells.
2) if you don't want Excel to anticipate what you are going to type in
a cell then deselect the Enable AutoComplete for cell values option
3) if you don't want Excel adding formulas and formats to your table
as it grows then deselect the Extend data range formats and formulas
option
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.
