Cell Basics

In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.

To drag and drop cells:

  1. Select the cells you want to move.
  2. Position your mouse on one of the outside edges of the selected cells. The mouse changes from a white cross Cursor to a black cross with 4 arrowsCursor.
    Positioning the mouse to drag and drop cells Positioning the mouse to drag and drop cells
  3. Click and drag the cells to the new location.
  4. Release your mouse, and the cells will be dropped there.
    Dropped cells Dropped cells

To use the fill handle to fill cells:

  1. Select the cell or cells containing the content you want to use. You can fill cell content either vertically or horizontally.
  2. Position your mouse over the fill handle so the white cross Cursor becomes a black cross Cursor.
    Positioning the mouse to use the fill handle Positioning the mouse to use the fill handle
  3. Click and drag the fill handle until all of the cells you want to fill are highlighted.
  4. Release the mouse, and your cells will be filled.
    Filled cells Filled cells