» To Fill Values Right or Down in a List in Excel 2007

CATEGORY - Excel Editing VERSION - Microsoft Excel 2007

To fill values to the right:

1. Select a range of cells to the right of nonblank cells.
2. Select Home -> Fill (in Editing Group) -> Right or press .
 To fill values down:
1. Select a range of cells under nonblank cells.
2. Select Home -> Fill (in Editing Group) -> Down or press .
Screenshot // To Fill Values Right or Down in a List in Excel 2007