Enabling Fill and Drag in MS Excel 2007+

MS Excel has feature where one can drag a cell and fill the series/formula to other cell. The feature I found to be quite useful. For example you can put a date 01/01/2013 in a cell and drag it to fill the rest of the days as in the year.

However I observed that on installing MS Excel 2007 the option was not present and was disabled by default. Its not clear why such an useful functionality is disabled by default. Anyway if one needs to enable it follow the following step

Select the Customize option from the Quick-Access bar which is normally located above the ribbon alongside the Excel Button on the left hand-top of  Excel (Normally you will have shortcut for save-undo-redo in the Quick Access Bar).

Select Customize -> More Commands -> Advanced -> Check “Enable fill handle and cell-drag and drop”

That’s all you need to do to enable this useful feature. Previous option of MS-Excel have this option under Tools -> Option


This entry was posted in Compu, Excel, Office, Windows and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s