Category Archives: Operating Systems

Operating Systems general commands and issue fixes cover in Linux , Windows, Solaris, Unix , HP-UX etc.

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.