Pasting formulas in excel

Closed
jay - Mar 15, 2010 at 06:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2010 at 07:15 AM
Hello,

Quick question guys, when i insert a formula in a cell in excell i normally get a little cursor appearing on the smae box on the bottom right hand corner of teh cell which i can simply drag the formula down with. However for some reason when a cell is highlighted i dont have that cursor appearing any more, dont know what happened to it?? any ideas how i can get that back pls?
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 15, 2010 at 01:06 PM
What you mean by if cells is highlighted. You mean if the cell is selected or you mean if there is color in the cell or some thing else /
yes, sorry i meant if the cell is highlighted and if that particular cell has a formula in there i could normally jst paste that formula down the spreadsheet by dragging it, however the 'dragging' function of the cells seems to have disappeared not sure what I have done??? any ideas on how to re insert it, please?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 16, 2010 at 07:15 AM
You have changed in options that. If you go to options and look into "EDIT" tab, you will see it there as "Allow cell drag and drop"