ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lost functionality to copy a formula across rows (https://www.excelbanter.com/excel-discussion-misc-queries/259476-lost-functionality-copy-formula-across-rows.html)

SandieB

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