Lost functionality to copy a formula across rows
Recently I lot the functionality to copy a formula across a group of cells.
Normally clicking on the cell will give you a "handle" to allow you to drag across a range of cells. At work we are currently using the 2002 Excel and I had this functionality until just recently. I have been getting several worksheets from other sources--could there be a problem with compatibility? I note that even my older spreadsheets lost this functionality. Help! |
Lost functionality to copy a formula across rows
Maybe:
Tools Options Edit allow cell drag and drop OK Micky "SandieB" wrote: Recently I lot the functionality to copy a formula across a group of cells. Normally clicking on the cell will give you a "handle" to allow you to drag across a range of cells. At work we are currently using the 2002 Excel and I had this functionality until just recently. I have been getting several worksheets from other sources--could there be a problem with compatibility? I note that even my older spreadsheets lost this functionality. Help! |
All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com