Excel problem ? Not able to get drag & drop option (plus (+) sign in bottom right corner of the cell), which help user to drag & drop the values in the incremental sequences. Don't worry, you have or due to some macro , your excel option of fill handle & drag & drop has got disabled. You need to activate (enable) the fill handle & drag-drop option again.
Hope, this helps you .. would be posting on some of the more important & simple tricks as a daily dose of information @ Office
How to Enable Microsoft Excel Drag & Drop Option ?
- Click File Menu
- Go to the option (Excel 2010)
- Click on the Advance tab on the left side of the window
- Tick the 3rd option of Fill handle & drag-drop to enable your dragging option
- That's All
Hope, this helps you .. would be posting on some of the more important & simple tricks as a daily dose of information @ Office
No comments:
Post a Comment