Pasting formulas in excel

Closed
jay - 15 Mar 2010 à 06:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Mar 2010 à 07:15
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Mar 2010 à 13:06
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Mar 2010 à 07:15
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"