Excel cell dragging repeating value of selected column

Fixed Excel on cell dragging not taking formula or correct result

Two option need to verify on Excel

Make workbook calculation on automatic

  1. Go to Right side and click File > Options.
  2. Click on the Formulas.
  3. Check the Workbook Calculation, choose the option to Automatic.

Enable fill handle and cell drag-and-drop option

  1. Go to Right side and click File > Options.
  2. Click on the Formulas button.
  3. Check the Editing Options, check the Enable fill handle and cell drag-and-drop box.

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.