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