Microsoft KB Archive/137714

= Works: Fill Series Fills in One Direction: Across or Down =

Article ID: 137714

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



This article was previously published under Q137714



SUMMARY
The Fill Series command on the Edit menu in Works Spreadsheet or the list view in Works Database can only fill cells in one direction: either top-to-bottom, or left-to-right. The direction of the fill is determined by the number of columns and rows in the current selection.



MORE INFORMATION
The direction of the filled series depends on the number of rows and columns selected (highlighted). If more rows are selected than columns, the series fills down. If more columns than rows are selected, the series fills across. If an equal number of columns and rows are selected, the series fills down.

Fill Direction Examples

 * If cell A1 contains a value, and cells A1 through D1 are highlighted, the series will fill across from A1 to D1.


 * If cell A1 contains a value, and cells A1 through A5 are highlighted, the series will fill down from A1 to A5.


 * If cell A1 contains a value, and cells A1 through D5 are highlighted, the series still only fills down from A1 to A5, because more rows than columns are selected.


 * If cell A1 contains a value and cells A1 through G5 are highlighted, the series fills across, because more columns than rows are selected.

Additional query words: 4.00 4.00a 4.50 w_works works2k works6 filler directional defaults highlights selected autofill

Keywords: kbinfo kbui KB137714

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.