Today when I opened my Excel sheet for editing, I found that the cell drag option is not working. For those who are not aware of this feature, the cell drag feature allows you to copy a cell content or its formula to all other cells in the same row by dragging it. It is a very useful feature and is active by default in MS Excel.
To enable this feature again just follow the steps given below.
- Open MS Excel and click on File.
- Under left side pane select Options , below Help.
- In the Excel Options window, click on Advanced.
- There check the box beside Enable fill handle and cell drag-and-drop and you are done.
The cell drag feature should work now in your Excel.