Tip Printed from ExcelTip.com

---

To Fill Values Right or Down in a List in 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 .