Previous Topic Next Topic

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?

2 responses

Answer 1 / 2
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 /
0
Answer 2 / 2
jay
Mar 16, 2010 at 06:25 AM
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 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"
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Root directory is full or errors during pasting
5468960 -
aryann9152 -

5 responses