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
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?
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:
- Pasting formulas in excel
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
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
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
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"