Fill Adjacent Cells - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Create Maple Worksheets : Create Maple Spreadsheets : worksheet/spreadsheet/filling

Fill Adjacent Cells

  

Filling is a method used to enter data into rows and columns of a spreadsheet. You can either copy the contents of one cell into adjacent cells, or fill adjacent cells with a series of data.

Copying Cell Content

1. 

Select the first cell and drag to the last cell you want filled.

2. 

From the Spreadsheet menu, select Fill, then one of Down, Right, Up, or Left.  For example, if you select Left, the value in the rightmost selected cell is used to fill all selected cells through to the leftmost selected cell.

Filling in a Series

  

Use the Stop At value to specify the integer at which the fill stops. Once an entry has reached the stop value, no additional cells in the column or row are filled.

1. 

Select the first cell and drag to the last cell you want filled.

2. 

From the Spreadsheet menu, select Fill, and then Detailed. The Fill dialog opens.

3. 

Click the direction to be used for filling. For example, if you select Left, the value in the rightmost selected cell is used to fill all selected cells through to the leftmost selected cell.

4. 

(Optional) Enter a Step Size. The Step Size is the amount by which you want to increase or decrease the cell values in the series.

5. 

(Optional) Enter a Stop At value. The Stop At value is the value at which the fill stops. Once an entry has reached the stop value, no additional cells in the column or row are filled, even if more cells were selected.

6. 

Click OK.

See Also

Change Cell Content, Enter Data in Cells, Evaluate Selection, Evaluate Spreadsheet, Reference Cells


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam