Fill Adjacent Cells - Maple Programming Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Create Maple Worksheets : Edit 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

Filling in a Series

Copying Cell Content

1. 

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

2. 

Right-click (Control-click for Macintosh) on your selection, select Fill, and then select 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 then drag to the last cell you want filled.

2. 

Right-click (Control-click for Macintosh) on your selection, select Fill, and then select Detailed. The Fill dialog opens.

3. 

Select 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