Wednesday, February 5, 2020

Display or hide the fill handle in Microsoft Excel

Display or hide the fill handle in Excel

By default, the fill handle and drag-and-drop editing is turned on in Excel so that you can drag the mouse to move and copy cells by doing the following:
  • Move a cell or range of cells by positioning the mouse pointer on a cell or cell range border so that it changes to a move pointer Excel Move Pointer , and then dragging the cell to another location.
  • Copy a cell or range of cells by holding down CTRL while you position the mouse pointer on a cell or cell range border so that it changes to a copy pointer Excel Copy Pointer , and then dragging the cell or range of cells to another location.
  • Drag the fill handle Fill handle to copy data or to fill adjacent cells with a series of data.
You can turn this option on or off as needed by doing the following:
  1. Click File > Options.
  2. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.

No comments:

Post a Comment

Describe BIOS and UEFI

  BIOS (Basic Input/Output System) and UEFI (Unified Extensible Firmware Interface) are firmware interfaces responsible for initializing har...