vert line

Use Fill->Smart to fill ranges with sequences of data.

Select the cell containing the data you want to start the sequence with, and Drag to also select all the cells you want to copy the data into. Then use the appropriate Range->SmartFill command to paste the data in.

If the starter cell contains text, Mesa checks to see whether it recognizes the text. If so, the sequential cells are filled in using the NEXT() function. If not, Mesa tags a 1 on the end of the text and increases the number by 1 in subsequent cells.

If the starter cell contains a number, Mesa increases the number by 1 in subsequent cells using the NEXT() function.

If the starter cell contains a formula, Mesa mimics the normal Copy+Paste operation using the SAME() function.

In all cases, if the contents of the starter cell is changed, the adjacent cells will automatically take on new values based on the new starter cell. This is especially useful if a formula has to be changed.

Apple-Return is a useful Shortcut key for SmartFill

Time Sequences. Mesa knows about

Days of the week

Months of the year

Quarters

Quarters and Years

Numbers

Dates

For example, if you enter 'May' into A1 and SmartFill across to H1, the cells fill with 'May' through to 'November'.

See also

 

 

Also go to:

Index help

Contents help