Often, you’ll find that you need to copy a cell to an adjacent cell or range. This type of copying is quite common when working with formulas. For example, if you’re working on a budget, you might create a formula to add the values in column B. You can use the same formula to add the values in the other columns.

Rather than re-enter the formula, you can copy it to the adjacent cells. Excel provides additional options for copying to adjacent cells. To use these commands, select the cell that you’re copying and the cells that you’re copying to. Then issue the appropriate command from the following list for one-step copying:

• Home?Editing?Fill?Down (or Ctrl+D) copies the cell to the selected range below.
• Home?Editing?Fill?Right (or Ctrl+R) copies the cell to the selected range to the right.
• Home?Editing?Fill?Up copies the cell to the selected range above.
• Home?Editing?Fill?Left copies the cell to the selected range to the left.

None of these commands places information on either the Windows Clipboard or the Office Clipboard.

You also can use AutoFill to copy to adjacent cells by dragging the selection’s fill handle (the small square in the bottom-right corner of the selected cell or range). Excel copies the original selection to the cells that you highlight while dragging. For more control over the AutoFill operation, drag the fill handle with the right mouse button, and you’ll get a shortcut menu with additional options.

• Scientists push stem cell therapies into new frontiers Image via Wikipedia Don’t look for this just yet at your neighborhood clinic, but Minnesota scientists are pushing stem cell...
• Molecule that leads stem cells to bone marrow discovered An ‘antenna’ molecule, which is capable of guiding blood stem cells to their natural ‘home’, the bone marrow, has been...
• The Physics of Musical Instruments User Reviews Send this to a friend The Physics of Musical Instruments Manufacturer: Springer Customer Rating: List Price: $99.00 Sale...
• How To Get A Bad Credit Cell Phone Getting a bad credit cell phone can be challenging, but there are several things that you can do to overcome...
• World first windpipe transplant in child using stem cells In a world first in children, British and Italian doctors have transplanted a new airway (trachea) into a child and...