Filling Cells

Using the fill commands, you can duplicate data across a range of cells.  Fill can copy one cell or a range of cells in any direction.  For example, if you needed to fill 25 cells with the same value, you could enter the value once in the first cell, select the other 24 cells and then fill those with the first cell. 

There are four types of fill: up, down, right, and left

Up/Down Fill


Down fill example.

In an up or down fill, values are duplicated down through columns.   If more than one column is selected (as shown above),  each column is filled separately. 

Right/Left Fill


Right fill example.

In a right or left fill, values are duplicated across rows.  If more than one row is selected (as shown above), the each row is filled separately.

NOTE:  All fills overwrite existing data in selected cells.

To Fill Cells

  1. Enter the text you want to use to fill a block cells.  Enter the text in the first or last row or column where the data will appear. 

  2. Select the block of cells you wish to fill.  You can fill values up or down, right or left. 

  3. From the Options menu select the Fill command you wish to perform. 
  • Fill Up duplicates values from the bottom cells, up.

  • Fill Right duplicates values from the cells on the left cells, right.

  • Fill Down duplicates values from the top cells, down.

  • Fill Left duplicates values from the right cells, left. 
  1. The selected cells are filled based on the fill command you selected. 


Copyright © 1999, Gobe Software, Inc