Saturday, April 14, 2012

Excel Data Entry Mouse Shortcuts

Copy Data to Adjacent Cells

 

  1. Select the cell that contains the data to be copied
  2. Point to the Fill Handle -- the black square at the lower right of the selection
  3. When the pointer changes to a black plus sign, press the Left mouse button, and drag left, right, up or down, across one or more cells.
  4. When finished, release the mouse button.

Copy to Adjacent Cells -- with options

  1. Select the cell that contains the data to be copied
  2. Point to the Fill Handle -- the black square at the lower right of the selection
  3. When the pointer changes to a black plus sign, press the Right mouse button, and drag left, right, up or down, across one or more cells.
  4. When finished, release the mouse button.
  5. Select one of the options from the shortcut menu
Watch this Excel Quick Tips Video for creating a list of dates that are a week apart.


 

No comments:

Post a Comment