why cut and insert cells only works randomly?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It seems that cutting and inserting cells in the spreadsheet, errors every
other time and locks the excell spread sheet...
 
Hi Tony,
You'll have to be more specific, but you might find the answers to such problems
as inserting rows, using OFFSET with formulas. And you will probably find why
extending formulas and does not work for you. -- if any of those are the problem.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

I don't know what you mean by locking the sheet, have you turned on sheet protection
or have merged cells in your copy..
 
Back
Top