Selecting a Series of Cell in Excel 2013

In Microsoft Office 2013, the feature of selecting a series of cells with incremental values & dragging the cell corner (+ sign) down to complete the rest of the series, is turned off by default.

To enable this, follow the steps mentioned below:

Click File on the main menu.
Click Options.
In the Options dialogue box, click on Advanced option.
Select the check-box which says “Enable fill handle and cell drag-and-drop”.
The relevant settings are highlighted in the attached image for your better understanding.

Comments are closed.

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter