Pasting formulas in excel

Closed
jay - Mar 15, 2010 at 06:03 AM
rizvisa1 Posts 4479 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?

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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 /
0
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?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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"
0