Autofill option through mouse is not working in Excel 2007

Autofill option can be implemented in Excel 2007 through mouse by selecting the cells and dragging left or right till the desired cells are filled with the values.

1. Plus sign under the selected column should appear to drag the selection to enable autofill option.

2. If it doesnot appear, Click on Microsoft button on the left-top most of the window. Go to Excel Options.

Click Excel options

Click Excel options

3. Click Advanced and select “Enable fill handle and cell drag-and-drop” checkbox.

Select auto fill option

Select auto fill option

4. Now try to drag the cell till the desired cell. The values will be auto-populated.

Drag the cells

Drag the cells

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups